January 25, 2006 at 10:56 am
I upgraded to SQL 2005 using a full backup of SQL 2000 but I don't see my triggers on SQL 2005. I right clicked on the table but there is no option for triggers. I also looked under triggers in management studio but could not find it. Are they lost or they are at a different place and I just cannot find them.
This is the first thing I noticed; does the upgrade remove something else also.
Thanks for your help.
January 25, 2006 at 2:38 pm
Expand the + in-front of a table that should have a trigger; you should see a folder called triggers under the table.
Tim S
January 25, 2006 at 3:30 pm
Thanks a lot. I see it now. I was trying to right click on the table based SQL 2000 experience. I also checked database triggers under programmability but it seems they are for something else.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply