Re: renaming database
From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 07/09/04
- Previous message: dave: "Re: renaming database"
- In reply to: dave: "Re: renaming database"
- Next in thread: Vishal Parkar: "Re: renaming database"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 8 Jul 2004 22:30:54 -0700
Try this. Stop the SQL Server from SQL Server Service Manager and Start
again, and then try to rename it.
Rohtash Kapoor
http://www.sqlmantra.com
"dave" <anonymous@discussions.microsoft.com> wrote in message
news:28f5f01c4656d$493c0f50$a601280a@phx.gbl...
> still same proble, bro...
> dave
> >-----Original Message-----
> >hi dave,
> >
> >make sure no-one else is connected to the database,
> including you.
> >
> >you can try:
> >use master
> >go
> >exec sp_renamedb .............
> >--or (if sql 2000) you can try
> >
> >alter database old_Database_name modify name =
> new_database_name
> >
> >--if, still you get errors you can run following
> command,to disconnect other
> >users:
> >--note:it will rollback existing transaction
> >
> >alter database <db_name> set single_user with rollback
> IMMEDIATE
> >
> >--
> >Vishal Parkar
> >vgparkar@yahoo.co.in | vgparkar@hotmail.com
> >
> >
> >.
> >
- Previous message: dave: "Re: renaming database"
- In reply to: dave: "Re: renaming database"
- Next in thread: Vishal Parkar: "Re: renaming database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
