Re: renaming database

From: dave (anonymous_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Thu, 8 Jul 2004 21:29:12 -0700

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
>
>
>.
>

Relevant Pages

  • RE: Automated Import Newbee needs help
    ... use Office Access 2007 to replicate a database that was created in an earlier ... Dave Hargis, Microsoft Access MVP ... "terry" wrote: ...
    (microsoft.public.access.externaldata)
  • RE: PLEASE HELP!!!! License information for this component not fou
    ... "Dave" wrote: ... "Klatuu" wrote: ... can't refresh the links it has to another database file. ... equivalent version Access Run Time license. ...
    (microsoft.public.access.gettingstarted)
  • Re: Can a Confimration Field Value be used is asp coding?
    ... "Dave" wrote in message ... >> flexibility and thereby eliminate most of the FP database component ... >> ClassID is a unique number which I am using to drive other pages ... >> The problem is the confirmation page. ...
    (microsoft.public.frontpage.client)
  • Re: Subject: Re: OT: Dont create tables owned by informix -
    ... >> own and administer the database. ... >> There are going to be times when this is impossible - and Dave may be ... In a small shop, the same small group of people end up with all roles, so ... Using sudo is a sensible and reasonable mechanism - and it is largely safe. ...
    (comp.databases.informix)
  • Re: Database Editor Returns No Results
    ... Dave wrote: ... >> of the records in your database table. ... >> Microsoft FrontPage MVP ... >> Spider Web Woman Designs ...
    (microsoft.public.frontpage.client)