You can try using this script at http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1447

Congrats for 5 successfull years of SQLServerCentral. This site is awesome and most happening SQL Server Site.

Good work guys!!

Hi Susan,

You need to update your statistics and also rebuild your indexes in this case.

Mike,

I would advice you to use SQL Server Upgrade Advisor. This can be downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=6107C27A-662C-4319-AFE7-B52D1568C30A&displaylang=en

Good article!!

What does the HTML file contain? I suggest you to export the data in HTML file to txt file or excel file and then import into SQL Server.

Yep, its always advicable to use InformationSchema Views, but as you said your code refers to syscomments , sysobjects etc.

You can now use sys.syscomments, sys.sysobjects to make it compatable with...

Managed code is the code which is managed by CLR(Common Language Runtime). All the key functions like talking to OS, resource allocation and garbage collection is all managed by your...

Bhushan,

Did you try updating statistics of your Test DB?

Tom,

If you don't want to use DTS . Here is the approach i can think of

• BCP out the data from all your 19 disparate servers into flat files.
• BCP in...

Vinod,

Good work :-). Its better to update the screenshots which refer to the name "DTS", as now there is nothing called DTS in SQL Server 2005, as you know its...

I found a few flaws in the generic look up table design

1. You are retrieving the data from look up table based on a string rather than int, it slow downs...

Yes u can created a linked server to access and use it .

Check this out:

http://www.databasejournal.com/features/mssql/article.php/3085211

http://www.informit.com/articles/article.asp?p=360063&seqNum=1

May be this url can help you,

http://www.techinterviews.com/?p=161

Regards,

Sudheer

With Sql server 2005, you can write your procedures in CLR apart from TSQL. But saying that, its always recommended to write your regular DML statements in TSQL.

I have used...