October 14, 2004 at 4:31 am
Is there a way of finding out a connections SET options? I can run DBCC USEROPTIONS
to get my options, but I want to find out how out in house application is connecting. So DBCC USEROPTIONS(55) where 55 is the SPID would be great. But it doesn't work. Anyone know how I can find this out?
Dave
PS. I suspect ArithAbort is NOT on, but I need to be sure...
October 14, 2004 at 7:40 am
The only way I know of right off is thru a trace. Using Profiler look at the event unde TSQL "SQLStmt:Starting" and if using SQL 2000 you can filter the TextData with like "Set" to watch only for that.
October 14, 2004 at 10:25 am
I think Profiler is the best way if you suspect a problem. If you are trying to troubleshoot, get the user to open another connection and see what comes through.
October 14, 2004 at 10:39 am
Thanks for the input. I will give it a go tomorrow as everyone is logging in...
Dave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply