http://goo.gl/EmKxy0

Home > ASE, Developement, Start Sybase, Sybase ASE/REP Interview Questions > How to know what are the spids using given database

How to know what are the spids using given database

Use below command

 

dbcc dbreboot(‘report’,’dbname’)

go

It will give you all spids which are using given database.

Check the Sybase Wiki @ sybasewiki.com
  1. No comments yet.
  1. No trackbacks yet.