If you are referring to trace flags, then try this (more info in BOL)

DBCC TRACESTATUS(-1)

OK - I didn't get that from your earlier specifications.

Try this

SELECT TYPE = CASE WHEN TERM_ID LIKE '040%' THEN 'A GROUP'

...

Moorthy,

Can you try this query?

SELECT TYPE = CASE WHEN TERM_ID LIKE '040%' THEN 'A GROUP'

...

What version of SQL Server are you using? I strongly suggest you upgrade to SQL2005 or 2008 and use SSIS instead of DTS.

Please check BOL and Google before asking.

From BOL:

User-defined functions can be nested; that is, one user-defined function can call another. The nesting level is incremented when the called function starts...

Here's another way to write the query, but compared to what you have it is only marginally better on the sample set you provided (49% to 51% 🙂

SELECT [t1].

...

SELECT [t1].[Id]

,[t1].[Name]

,[t1].[Designation]

,[t1].[Address]

...

Use an outer join with a table that contains the dates you require like in my example.

http://www.sommarskog.se/grantperm.html#ownerschema

Please provide create table statements, sample data and an example of the output you would like to see for it.

You'll first need to generate all the necessary dates. You can either to this dynamically (e.g. using a CTE - see BOL) or use a calendar table. For the solution...

Not sure why you think you need a WHILE. Try this:

SELECT [t1].[Id] AS [Id_Table1]

,[t1].[Name]

,[t1].[Designation]

...

Open the Object Explorer Details window (F7) and click on Security - Logins in the Object Explorer pane.

Dave,

I have the impression that in your first step (FST Rename Source File) you are trying to copy the file onto itself which raises the error.

This seems to happen because...

Did you try correcting the metadata using the Advanced Editor on the source?