Posts
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.
|
|
|||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||
| Copyright Jacob Sebastian | |||||||||||||||||||||||||||
0 comments:
Post a Comment