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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-06 : 10:06:54
|
| Jack writes ""I've created a trigger and want to change it a little. I could delete it and create another one. But I'd rather just fix it. Is the creation script for a trigger stored somewhere? I'm thinking it would be something like a stored procedure, where I've changed the script, hit 'apply' and the sp is changed.Can I do this with a trigger? How? Where is it stored?TIAWindows and MS SQL 2k"" |
|
|
shankarc
Starting Member
37 Posts |
Posted - 2001-12-06 : 10:33:27
|
| Go to Enterprise Manager. Select the Table for which you want to modify the trigger, right click, Select Alltasks followed by Manage Triggers. Here goes the trigger script thru which you can modify and save the trigger script. |
 |
|
|
Jack
Starting Member
1 Post |
Posted - 2001-12-06 : 10:44:32
|
| Thanks, I found it with your help.-Jack |
|
|
|
|
|
|
Finding and adjusting triggers