Tuesday, March 2, 2010

USefull commands in sql server query

Command to check who are using databases with which users ids and more

sp_who2

To Kill the specific process for the Actice Connection use below command

kill 59


To take The back up for the Database

backup database test to disk='foldername'

No comments:

Post a Comment