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

Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

How can we insert data from one table to another table without using import/export wizard?

How will you create one table (new table) from another table (source table). The new table should be empty after creation?
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

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

Continue reading

SQL Server Practice Test – Online

Folks,

I have found a very good link of SQL Server Practice Test which is an online test….

I thought why not to share, Please follow the below link..

http://www.sql-server-helper.com/free-test/default.aspx

Thanks

How to Unlock SQL user account

A. Unlocking a login
To unlock a SQL Server login, execute the following statement, replacing **** with the desired account password.

ALTER LOGIN [Mary5] WITH PASSWORD = ‘****’ UNLOCK ;
GO
To unlock a login without changing the password, turn the check policy off and then on again.

ALTER LOGIN [Mary5] WITH CHECK_POLICY = OFF;
ALTER LOGIN [Mary5] WITH CHECK_POLICY = ON;
GO

Continue reading