Permissions to see last TSQL command

Question

Permissions to see last TSQL command

Frank Kalis

SSC Guru

Points: 111183
More actions
October 7, 2003 at 7:51 am

#59450

Hi there,
which permisions do I need at least to see the last TSQL command under Current Activity->Process Info?
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

You actually call dbcc inputbuffer command to see the last TSQL command.

DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server role only, who can see any SPID. Other users can see any SPID they own. Permissions are not transferable.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Hi Allen,

quote:
You actually call dbcc inputbuffer command to see the last TSQL command.
DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server role only, who can see any SPID. Other users can see any SPID they own. Permissions are not transferable.

thanks!

Unfortunately this is not the answer I wanted to hear as we moved my db's to a central server on which I am no longer sysadmin

I guess there are no workarounds?

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

Unfortunately you can see only SPID and last statement with dbcc inputbuffer you own if you are not 'sysadmin'.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

hm...any experience with 'processadmin'?

that little that is in BOL sounds interesting

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 5

I tried, It doesn't have to permissions to see other people's processes. It can be use to kill processes.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

quote:
I tried, It doesn't have to permissions to see other people's processes. It can be use to kill processes.

Thanks again!

Would have been nice

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 7

Btw, I've been added back to sysadmins.

It pays when you keep the network admins who control the server busy with something they can't answer

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]