How to look at "Set Up" options in somebody else's DB connctions?

Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CWIf you can run Profiler, then trace the 'existing connection' event and you
should see all the SET options for a given connection, uin the TextData
column.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Chai" <chai@.trs.state.il.us> wrote in message
news:uWvDh2U2DHA.1720@.TK2MSFTNGP10.phx.gbl...
Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CWsql

How to look at "Set Up" options in somebody else's DB connctions?

Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her) :)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CWIf you can run Profiler, then trace the 'existing connection' event and you
should see all the SET options for a given connection, uin the TextData
column.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Chai" <chai@.trs.state.il.us> wrote in message
news:uWvDh2U2DHA.1720@.TK2MSFTNGP10.phx.gbl...
Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her) :)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CW