cannot execute the following sql query because of permission

Question

What level of rights would i need to execute the following query ?

SELECT S.*
FROM sys.dm_exec_requests R
INNER JOIN sys.dm_exec_sessions S
ON S.session_id = R.blocking_session_id

sys.dm_exec_sessions is a Dynamic Management view

i am getting an error saying that it cant start debugger;

It isn't that we don't have a sense of humor, or that we want you to type a lot. But we discourage chatspeak because it is already difficult enough for people whose native language is not English to understand what we are saying here. Slang just makes it harder. — DOK
– DOK, Commented Jun 1, 2011 at 12:39

DOK · Accepted Answer · 2011-06-01 12:06:11Z

4

According to this very helpful article:

These DM Views are secured, since they might show information you'd rather not have available to everyone.

Grant the VIEW SERVER STATE permission for server-level and VIEW DATABASE STATE permissions for database-level Dynamic Management Views and Functions. It's usually best to create a Role and then grant the permissions to that.

GRANT VIEW SERVER STATE TO <<login name>>

answered Jun 1, 2011 at 12:06

DOK

32.8k8 gold badges64 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gbn · Accepted Answer · 2011-06-01 11:59:49Z

1

VIEW SERVER STATE

As per the relevant MSDN pages for the Dynamic Management Views: One, Two

answered Jun 1, 2011 at 11:59

gbn

434k84 gold badges602 silver badges690 bronze badges

Comments

Navaneethan · Accepted Answer · 2011-06-01 11:56:42Z

-1

i hope you are using Debug instead of Execute(F5).

answered Jun 1, 2011 at 11:56

Navaneethan

2,2556 gold badges24 silver badges32 bronze badges

1 Comment

gbn Over a year ago

How is this answer relevant please?

Collectives™ on Stack Overflow

cannot execute the following sql query because of permission

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related