SP_Helpdb error

SP_HELPDB not running properly –

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

Advertisements

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

Script all jobs on SQL 2005 and 2008 Server

In SQL Server 2000, there is an option to script out all jobs in an instance. That option disappeared in SQL Server 2005.

You can still do it. Continue reading

New T-SQL Functionality in SQL Server 2008

We need to take a closer look at some of the smaller additions, but additions that are likely to pack a big punch in terms of efficiency. There are few of the new features offered in T-SQL in SQL Server 2008.  Continue reading

SQL SERVER – Data Insertion

 

There are two different ways to implement inserting data from one table to another table. I strongly suggest to use either of the method over cursor. Performance of following two methods is far superior over cursor. I prefer to use Method 1 always as I works in all the case. Continue reading