By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,970 Members | 1,668 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,970 IT Pros & Developers. It's quick & easy.

trigger simple question

P: n/a
I am looking at a table in Microsoft SQL Server. I went to the
dependencies of this table and it says TRIG_customer. so i am
thinking there is a trigger that affects the table but how do i see
what is the code that resides within this trigger. I looked among the
stored procedures but i couldnt find this trigger.

are all the triggers listed together somewhere. where is this trigger
named TRIG_customer?

thanks in advance

Dec 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try:

sp_helptext TRIG_Customer

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"anonymowho" <do*********@verizon-dot-net.no-spam.invalid> wrote in message
news:kZ********************@giganews.com...
I am looking at a table in Microsoft SQL Server. I went to the
dependencies of this table and it says TRIG_customer. so i am
thinking there is a trigger that affects the table but how do i see
what is the code that resides within this trigger. I looked among the
stored procedures but i couldnt find this trigger.

are all the triggers listed together somewhere. where is this trigger
named TRIG_customer?

thanks in advance

Dec 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.