Replication General Errors

Msg 2560, Level 16, State 9, Procedure sp_MSremoveidrangesupport, Line 88
Parameter 1 is incorrect for this DBCC statement.
Msg 20025, Level 16, State 1, Procedure sp_dropmergepullsubscription, Line 339
The publication name must be unique. The specified publication name ‘MainSync’ has already been used.
Msg 14056, Level 16, State 1, Procedure sp_dropmergepullsubscription, Line 426
The subscription could not be dropped at this time

Solution : Continue reading


Moving System Databases – SQL Server 2005

Here I have tried to explain how we can move system databases from one place to another step by step from my experience.

Please follow the below Tasks for moving system databases:

Continue reading

How to fix Orphaned Users in database

FIX : Error 15023: User already exists in current database

Orphan user is a user in a SQL Server database that is not associated with a SQL Server login..

Continue reading

Lock pages in memory – SQL Server

This security setting determines which accounts can use a process to keep data in physical memory, which prevents the system from paging the data to virtual memory on disk. Exercising this privilege could significantly affect system performance by decreasing the amount of available random access memory (RAM). Continue reading

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

Report Services instance could not be found

If you are getting this error message when trying to connect to Reporting Services from Management Studio.

“The Report Services Instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)”
Continue reading