Subscribe To

Subscribe to SQL Server and XML by Email

Saturday, June 17, 2006

Rename a SQL Server 2000 datatabase

I was looking for a quick way to rename a SQL SERVER 2000 database I found the information handy. EXEC sp_dboption 'OldDbName', 'Single User', 'TRUE' EXEC sp_renamedb 'OldDbName', 'NewDbName' EXEC sp_dboption 'NewDbName', 'Single User', 'FALSE' Thankx to Jason Fisher. His short artcile has explanation for this code.


Post a Comment

About Me
Jacob Sebastian
* XQuery Tutorials
My Links
SQL Server White Papers
SQL Server 2008
My Articles
XML Workshop RSS Feed
Contact me
Free Hit Counter
Web Site Hit Counters
SQL Server Bloggers
Blog Directories
blogarama - the blog directory Programming Blogs - BlogCatalog Blog Directory
Copyright Jacob Sebastian