SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Monitoring all Database-Connections
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

35 Posts

Posted - 02/19/2014 :  05:31:08  Show Profile  Reply with Quote
i have do replace a sql-server 2005 with 2008/R2. We do not know which client have access to which database, as this has not been documented. Is there a way, for a period of time to monitor all connection activities?
-which User or IP have access to
-what database
-maybe other information like time, table, view, SP ...

Thank you

Flowing Fount of Yak Knowledge

United Kingdom
2155 Posts

Posted - 02/20/2014 :  01:45:26  Show Profile  Visit jackv's Homepage  Reply with Quote
You could regularly monitor the •sys.dm_exec_connections and sys.dm_exec_sessions , which list all connections and sessions respectively.
You could match this up to a list of database users and their roles - http://www.sqlserver-dba.com/2012/09/sql-server-find-sql-database-users-and-find-database-roles.html

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000