IT Journey
My Learning and Experience in IT Industry
Wednesday, October 17, 2012
How to rename the db
ALTER
DATABASE
[lab]
SET
SINGLE_USER
--SETTING TO SINGLEUSER
GO
sp_renamedb
[lab]
,
'LABs'
---RENAMEDB
GO
ALTER
DATABASE
LABs
SET
MULTI_USER
--AGAIN SETTING TO MULTIUSER
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment