May 20, 2009 at 12:58 pm
Hi got kind of situation,
we have one sql user on the database now we need to figureout who is actually using it because we plan to delete it but not known exactly who is using it from application end. what is the best way to do it or trace it out using profiler or any other way to figureout it.
I Need to know which applications are using it actively
May 20, 2009 at 1:09 pm
U can use sp_who2 or SELECT * FROM SYS.sysprocesses WHERE SPID > 50 (For SQL 2005) to know all active/passive connections connected to your Sql server.
May 20, 2009 at 1:16 pm
If the user is currently not logged in you can use a LOGON trigger and write the HOST_NAME() and APP_NAME() information into a table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply