Modifying Trigger

Question

Modifying Trigger

leon 23340

SSC Veteran

Points: 207
More actions
April 5, 2010 at 8:18 am

#146257

Hi,
A subcontractor has created a trigger in my database and I want to modify it. Unfortunately when I goto the trigger, in the tables section, the modify button is greyed out. How can I modify or at least view this trigger?
Cheers,
Jason

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

Did you went to tables/details pane, right-click the table on which the trigger exists, point to AllTasks, and then click ManageTriggers?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Toby White SSCertifiable Points: 6187 More actions · Answer 2

What do you get if you execute sp_helptext [triggerName]?

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 3

Are you logged in with SysAdmin privs?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

leon 23340 SSC Veteran Points: 207 More actions · Answer 4

Toby White (4/5/2010)
What do you get if you execute sp_helptext [triggerName]?

Thanks for the reply.

When I execute the above I get "The text for object '<TABLENAME>' is encrypted."

leon 23340 SSC Veteran Points: 207 More actions · Answer 5

Jeff Moden (4/5/2010)
Are you logged in with SysAdmin privs?

Correct

Toby White SSCertifiable Points: 6187 More actions · Answer 6

You will have to either get the source code from the contractor or decrypt the trigger yourself. I attached code you can use to decrypt objects, but you will have to connect in DAC mode. There are comments at the top of the code explaining how to do this.

Regards,

Toby