Wednesday, November 25, 2009

How to give access to SQL 2005 Activity Monitor

To view the Activity Monitor the user needs VIEW SERVER STATE permission on a SQL Server 2005 server.

Permission to KILL a process default to the members of the sysadmin and processadmin fixed database roles, and are not transferable.

References: http://msdn.microsoft.com/en-us/library/ms175518(SQL.90,printer).aspx

No comments:

Post a Comment