SS2K, view trigger code from inside QA

[SteveDingle]

Heya All,

I use ApexSQL EDIT as my interface in SQL Server so always forget how to do things in QA or EM (and I'm now spending more time on client pc)

Is there a command I can use in QA which allow me to view the code for a trigger and/or SP's

Thanks


Toodles,
Steve Dingle

http://www.dsbusinesssolutions.co.uk

D&S Business Solutions Ltd

 

[vongrunt]

try sp_helptext <sprocname|triggername>

Or use Script Object to New Window As... Alter option in QA.

------
chemistry - the only natural science that can be broken down into the categories a) making drugs and b) blowing stuff up

 

[ESquared]

And when you use sp_helptext turn on the results-in-text option (ctrl-t). You'll find line breaks and tabs and things are more accurate to the original. Press ctrl-d to get back to results-in-grid.

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

_{The best part about anything that has cheese is the cheese.}[/color]