Kyle,

Thanks for the update and solution.

Happy T-SQL'ing!

Excellent article. I am looking into broadening my skills, by moving more into the Business Intelligence and Data Warehousing "arenas". Thanks so much for the article. I...

Yann,

Ne rien.

(My wife translated for me.)

Regards,

Yann,

I believe that answers your original question. Is there anything else you need assistance with in your Report?

Regards,

Yann,

We are getting closer. Open your Compliance Report and scroll down to the "(-)Database SQL Options" entry. Under the column "Description" there will be a blue link for...

I think I did get User1 and User2 jumbled up a bit. The bottom line is that the people involved knew that the system was monitored for unauthorized data...

Yann,

Can you send the output of the entire Best Practices Analyzer Report?

To do this:

Open the Best Practices Analyzer.

On the left column, go to "Compliance Reports".

Open your...

I don't know what "ftdata" is. What type of file(s) do you want to move? .MDF, .NDF, , .TRN, .LOG, .TXT? Give us more information and description...

All of the below mentioned tools are for SQL Server backups only. I believe all of these products can be downloaded for evaluation:

Litespeed (Quest)

http://www.quest.com/litespeed-for-sql-server/

SQL Backup (Red Gate)

What query did you execute to get these results? Are you expecting different results? What are you trying to accomplish with this output?

I work for a health care organization. Unfortunately security, especially computer security, is becoming more and more important in our society. In the last 10 or so years...

For those who would like to know where to order SQL Server 2005 Developer Edition ...

SQL Server 2005 Media

MSDN Subscription: If you have access to an MSDN subscription,...

niranjankumar_k,

Your "*=(left outer join)" syntax problem may not be your only issue regarding your SQL 2000 to SQL 2005 upgrade. If you have not already done so, I recommend...

Jeff is correct about the Bulk Insert Task for SSIS, but the Bulk Insert Task cannot transform data. I suggest you look into using a Data Flow Task instead,...

From the Horse's Mouth:

Linking Servers

SQL Server 2005 Books Online (September 2007)

http://msdn2.microsoft.com/en-us/library/ms188279.aspx

A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers....