Database Up

• sureshmca611

  Grasshopper

  Points: 13

  More actions

  December 6, 2010 at 10:46 pm

  #243609

  LocalServer i am created one database Name Sample.This Database includes Tables,Storedprocedure .I Want to change the locaServer To Main Server How do I Change?

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  January 6, 2011 at 3:35 pm

  #1270358

  Is LocalServer the instance? If so you cannot easily rename the SQL instance after it has been installed...and it's not reccomended either

  However, I did read an article once that says you can try this (at your own risk):

  1. drop current instname (sp_dropserver)

  2. add new instance name (sp_addserver 'new name','local')

  3. stop sqlserver

  4. modify hklm\software\microsoft\microsoft sql server\

  5. modify hklm\system\currentcontrolset\services\mssql$inst"

  6. use "sc create" to add new mssql$<inst>

  7. start up with new inst_name - this should work

  Hope it helps!

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience