is there a query to list database user access and related source IPs on SQL Server 2000 and 2005? Please note that reporting service is not installed.
Thank you all for help.
Sql-server – SQL Server 2000/2005 query list user access
sql serversql-server-2005
Best Answer
sp_who or sp_who2 should give you what you need. They won't list the ip address but they will list the hostname. sp_who2 will give you more information than sp_who.