DBCC USEROPTIONS (for another connection) 1

[Lekar]

Hi

I want to check out the options for any connection.
I've used DBCC USEROPTIONS, however this command only applies to the current conection.

When I run sp_Who I see some spids and I want to know the options of the conection of the spid x.

Can I do that?

 

[Jamfool]

Have a look at:

http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp

DBCC PSS

This command shows info about processes currently connected to the server.

Syntax:

DBCC pss(suid, spid, printopt = { 1 | 0 }) 

where: 

suid - server user ID 

spid - server process ID 

printopt - print option (0 standard output, 1 all open DES's and current sequence tree)

This is an example:

DBCC TRACEON (3604)
DBCC pss

 

[Lekar]

Thanks Jamfool:
The DBCC pss statement displays the isolation_level of any connection with the values 1 to 4 identifying the READ COMMITTED, READ UNCOMMITTED, REPEATABLE READ, SERIALIZABLE.