SQL Command for Process control and error fixing

sp_who2 will show all the existing processes with statuses and in the Blkby column we will see if is bloking any other process or if is waiting ofr any process to finish.

sp_who will give info about more processes.

Kill “Process PID” will kill any process. Make sure you run this command on the correct DB.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s