Add/Rename SQL Server 2005 Server Name
Hi experts, I have am trying to rename and add new server name to Microsoft SQL server 2005. I as using following steps for rename step 1. select @@servername ‘ for seeing current server name step 2. sp_dropserver ‘ray’ ‘ for deleting current server step 3. sp_addserver ‘raynew’, local ‘ for adding new servername step [...]

Answer Question   |  March 31, 2012  7:33 AM
SQL Server, SQL Server 2005, SQL Server name

anybody can tell me that how to create setup which will accept database name & server name
anybody can tell me that how to create setup which will accept database name & server name trhough which i can create database in perticular server during setting up the application. i mean to say i don want create manually in sql Server, which should be created during sepup only

Answer Question   |  May 24, 2010  10:23 AM
.NET, Database name, Setup and deployment, SQL Server, SQL Server name

Changing SQL Server name and SQL Server group name
Hi, I have notice that our dev and prod SQL Server has SQL Server name and SQL Server group name that is different to the machine name. We are planning to change it to match the machine name. To do this, from what we have read, you change the SQL Server name using the sp [...]

Answer Question   |  May 20, 2009  7:18 AM
SQL Server group name, SQL Server name