SQL Server Architecture – Are you ready ?

Explaining SQL Server Architecture in one diagram or Image is very difficult.

Even if we get the same from any blog or website, it is not so easy to understand.
Many of us till date did not even know, what are different engines and their use. Continue reading

Advertisements

How to fix Orphaned Users in database

FIX : Error 15023: User already exists in current database

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

Continue reading

SP_recompile

SP_recompile needs a single parameter which is the table name after it.

ie: sp_recompile table_name 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