hi Beng,
[quoted text, click to view]

to debug a stored procedure in Query Analyzer, you have to open the "Object
Browser", select the procedure you want to debug, right click on it and
select the "Debug" context menu item..
in addition, please have a look at
http://www.google.it/groups?hl=it&lr=&ie=UTF-8&oe=UTF-8&selm=uScZAO5NAHA.96%40cppssbbsa02.microsoft.com&rnum=4
and http://support.microsoft.com/default.aspx?scid=kb;en-us;328151
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Hi ,

I am using SQL Standard Edition , can i use the debugging tools in QA ?
if so how can i bring out the debugging toolbars ( have tried but cannot)

appreciate ur advise

tks & rdgs
Beng Tiong

--

tks Andrea ..

[quoted text, click to view]

--
Message posted via SQLMonster.com

hi,
[quoted text, click to view]

you can not directly debug a trigger, but you can debug a stroed procedure
executing DML statements involving a trigger to be fired... you have to set
a break in the procedure and go on stepping through... the trigger, when
fired, should be step through as well..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Hi ,

Can i actually debug a trigger ? what i found out was when i right clicked
an SP the debug is enabled but not for a trigger

from one of ur link i have executed the following statement --> Exec
sp_sdidebug 'legacy_on' but anyway i am on SP3 so it's by default enabled as
per the article from microsoft.

i am running on MSDE2000 from my notebook

appreciate ur advice

tks & rdgs

[quoted text, click to view]

--
Message posted via SQLMonster.com

i c tk u very much

[quoted text, click to view]

--