This can guide you:

http://www.mssqltips.com/tip.asp?tip=1122

http://www.sqlusa.com/bestpractices/renamedb/

http://www.sqlserverandxml.com/2006/06/rename-sql-server-2000-datatabase.html

http://decipherinfosys.wordpress.com/2007/10/24/re-naming-database-in-sql-server/

This is also a very good info for us. But it is not an article. It is information sharing. This comes under knowledge/information sharing. I would request Steve to open...

Hi Guys

Can anyone remember what is the topic of the actual article? Why we are debating on some trivial issues which we cannot solve? Guys lets discuss more on SQL....

First of all thank the author for the information sharing. This cannot be an article. This comes under knowledge/information sharing. I would request Steve to open a new category called...

You are welcome. 🙂

Vivien has provided a good link. Go thru that and also you can check:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

🙂

It is a good article. Thanks Jacob.......:)

This is a excellent article and well written too. Very simple and easy to understand. Also thanks to people who added more value to this by commenting.

Regards

🙂

These may help you:

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

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1089808,00.html

http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en

🙂

Megha go ahead with your studies. surely it will be more fruitful later. Slowdown is temporary but knowledge is permanent.......:P

The tool seems cool. But I should not comment on these in positive or negative unless and until using it. As the tool is new we will know the advantages...

I am not impressed with the article. I am not clear what the author wants to say bythese lines in step 1:

' The only thing that should change is the...

It will increase the performance of the database but at the same increase the burden (decrease the performance) of the DBA.

😀

The query provided by Tao will cost less in a large database then CTE no doubt........

Go thru these:

http://support.microsoft.com/kb/873235

http://support.microsoft.com/kb/110139

😛