To view the Activity Monitor in SQL Server 2005, a user must have VIEW SERVER STATE permission.

To view the Activity Monitor on a SQL Server 2000 server, a user must have SELECT permission to the sysprocesses and syslocks tables in the master database. Permission to view these tables is granted by default to the public database role.

To KILL a process, a user must be a member of the sysadmin or processadmin fixed server roles.

If the issue still persists, please give the exact error you are facing...

Bye...

0

xmouserAuthor Commented: 2008-11-11

Please check it under Management after you login to SQL Server.
*Don't see that

To view the Activity Monitor in SQL Server 2005, a user must have VIEW SERVER STATE permission.
*I have that permission

If the issue still persists, please give the exact error you are facing...
*No error message, I just can't find activity monitor

0

xmouserAuthor Commented: 2008-11-11

JagdishDevaku:

Found it under Management.
Thanks

0

Featured Post

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!