Re: renaming database

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 07/09/04

  • Next message: KK: "How can I show a graph instead of table of data using English query?"
    Date: Sat, 10 Jul 2004 00:33:34 +0530
    
    

    all you can do is restart the sql server service, which will clear out all
    the connection to the db, and run

    use master
    go
    exec sp_renamedb ---
    --or (if sql 2000) you can try

    alter database old_Database_name modify name = new_database_name

    -- 
    Vishal Parkar
    vgparkar@yahoo.co.in | vgparkar@hotmail.com
    

  • Next message: KK: "How can I show a graph instead of table of data using English query?"

    Relevant Pages

    • Re: Server Service not start
      ... Did you detach/attach the master db? ... account that starts the SQL Server Service? ... www.experts-exchange.com - experts compete for points to answer your ...
      (microsoft.public.sqlserver.connect)
    • Re: Problems with connection management
      ... operation against the data base verifies that the connection is valid. ... In order to test it I stop SQL server service and restart it. ... ''The conn variable is global ...
      (comp.lang.basic.visual.misc)
    • Problems with connection management
      ... operation against the data base verifies that the connection is valid. ... ''The conn variable is global ... The code works fine if I don't stop and restart the sql Server service. ...
      (comp.lang.basic.visual.misc)
    • Newbie Q setting up MSDE
      ... I've installed MSDE, ... and it says 'Not Connected' when I mouseover the icon in the system tray. ... opened the SQL Server service manager, and there are two empty fields- ... connection string would I use with MSDE. ...
      (microsoft.public.sqlserver.msde)
    • Newbie setting up MSDE
      ... I've installed MSDE, ... and it says 'Not Connected' when I mouseover the icon in the system tray. ... opened the SQL Server service manager, and there are two empty fields- ... connection string would I use with MSDE. ...
      (microsoft.public.sqlserver.msde)