Database access question 1

[OldSkoolSkater]

Morning all

Can anyone tell me if there's a way to see who is currently accessing an SQL 7 database?
I tried to restore a database today, and an error occurred stating that it was in use and that the d/b needed to be locked.
Ideas??

 

[RickCole]

From a Query Analyser window you can run the following:

exec sp_who

Alternatively from Enterprise Manager go to the Management folder and then look at processes within Current Activity

Rick.