how to open and read a trigger text? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

how to open and read a trigger text?

Author

Topic

gsrinivas.
Yak Posting Veteran

56 Posts

Posted - 2010-03-01 : 06:43:53

hi
i have a trigger name..
how to open and read that trigger text?

plz help.

-thanks
gsrinivas.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-01 : 07:14:09

to read in query analyzer:
use your_db_name
go
sp_helptext trigger_name

to change in query analyzer
in objectcatalog:
expand your_database
expand your table
expand Trigger
right click trigger and choose edit

No, you're never too old to Yak'n'Roll if you're too young to die.

gsrinivas.
Yak Posting Veteran

56 Posts

Posted - 2010-03-02 : 00:15:31

thanks webfred.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-02 : 03:37:09

welcome

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources