[dba-SQLServer] TRIGGER question

I'm using SQL 2K.

Create your test SP, something like...

create procedure dbo.testTrigger
as
insert into TestTable
values('a','b')

Open QA, find your new SP, right click on it in the object browser,
select debug.  You SHOULD be able to step
through using F11 IIRC

cheers

Michael M 


Um... How would I do that?

Susan H. 

Michael -- that's pretty cool. Thanks!

Susan H. 


BTW you can use QA to debug triggers by creating an sp that will trigger
the trigger and when you debug the sp it will step into the trigger...
HTH

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com