ShortCut to Start Sql Server Management Studio

Goto Run (WindowsKey+R) type ssmsee        — for (Express Edition) type ssms             – for (Full Version) Also Try: ssmsee -nosplash      [opening without splash screen wizard]

Restore Database Query

RESTORE DATABASE dbXyz FROM DISK = ‘C:\dbBackuXyz.bak’ WITH REPLACE

Sql Query To Display ColumnName, Datatype of a table

SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM  INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘myTableName’

Changing the Default Database in Sql using query

USE [master] GO ALTER LOGIN [LoginUserName] WITH DEFAULT_DATABASE=[YourDbName] GO

SQL: Rename table

here is the syntax for renaming table in sql server EXEC sp_rename ‘old_name_of_table’, ‘new_name_of_table ‘

How to configure SQL Server 2005 to allow remote connections

Go to  http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277