Changing The Name of the Server.

-----Changing the Name of the Server.But it wont Drop the Server.
SP_DROPSERVER 'BHI-207\SQLEXPRESS'--Present serverName
GO
SP_ADDSERVER 'RAMESH MAMILLAPALLI',LOCAL--After running the Query Stop and Restart the Services.
GO
SELECT @@SERVERNAME

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server