TSQL Debugger from a workstation

Question

Post reply

TSQL Debugger from a workstation

Tim OPry

SSCrazy

Points: 2988
More actions
April 21, 2004 at 11:19 am

#359428

Trying to use the TSQL debugger in Query Analyzer on a workstation on the local LAN.
Environment: SQL 2000 under W2K Server and the WS is XP/Pro
If I log into the server under my user account, the TSQL Debugger works properly. However if I attempt to run the debugger from my workstation, same user account I cannot step through the stored procedure. The sproc executes to completion, but none of the Step ... buttons are enabled and break points, while they can be set - are never triggered. The sproc executes, I simply cannot step through it.
No error messages and no event log entries on the ws or server.
I've checked BOL - check the dcom settings on the server, searched google etc to no avail.
Suggestions?

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

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

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

Loca LAN, same domain?

Shamless self promotion - read my blog http://sirsql.net

Tim OPry SSCrazy Points: 2988 More actions · Answer 2

Yes - single domain and the account I am testing with has Domain Admin priv.

jaredsimi SSCrazy Points: 2420 More actions · Answer 3

look at the following

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp

Tim OPry SSCrazy Points: 2988 More actions · Answer 4

Thanks, but as I mentioned I have verified the dcom settings and am not getting any DCOM errors.

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 5

How about the MDAC version? Both 2.8?

Shamless self promotion - read my blog http://sirsql.net

Tim OPry SSCrazy Points: 2988 More actions · Answer 6

Both using 2.7 - however, this would appear more DCOM related - in that it works properly when run on the server, just not locally. The lack of any DCOM errors however is a little surprising.