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
Showing posts with label Management Studio. Show all posts
Showing posts with label Management Studio. Show all posts
Wednesday, November 25, 2009
Subscribe to:
Posts (Atom)