How to Change Server Name in SQL server

How to use ‘SP_addserver’ and ‘SP_dropserver’

We often use to change server name for SQL server 2000, 2005 or 2008 instance when we migrate sql instance from one place to another or while changing the name of the computer running the SQL Server.

We have to perform following steps to ensure that SQL Server also uses the new updated servername. Continue reading

Advertisements

General Error Messages (Volume 2)

SP_HELPDB error, it is not running properly –

The exact error that you may see is something like the following:

Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot insert the value NULL into column ”, table ”; column does not allow nulls. INSERT fails.The statement has been terminated.

Cause : This is caused by missing owner of a database. Continue reading

SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution

Fix/Solution/WorkAround:

There is no real solution for this error. This error happens due to server is very busy and it can be resolved itself when server load is reduced to acceptable level. There is no way to know what is acceptable level of load for server.