I want to know that at a particular time how many user/clients have registered my SQL SERVER2000, What is their user IDs/computers name. Is there any log file maintained by SQL SERVER or other things.Please Help me with the answer.

Thanks and Regards Satendra Singh,NOIDA

I want to change the Master databse from existing user mode into single user mode. but I am not able to find the way to do so. Could you please help me out.

-- Anonymous, February 17, 2005

Answers

Satendra,

By "registered" I am assuming you mean using SQL Enterprise Manager with your server registered.

You can use the Transact SQL command sp_who2. In the ProgramName column you will see "MS SQLEM" for SQL Enterprise Manager connections. You can read their User ID in the Login column and their computer name in the HostName column.

Hope this helps,

Eric

-- Anonymous, February 17, 2005