Thursday, 19 September 2013

trigger upgrade from sql server 2005 to sql server 2012

trigger upgrade from sql server 2005 to sql server 2012

I have a serious problem. I have about 200 sql server 2005 databases and
every database has at least 30-40 tables, each with about 10 triggers.
Now the problem is that we have upgraded from sql server 2005 to 2012 and
the triggers are syntactically incorrect now.
How do I change the syntax for so many triggers? Or better still, how do I
make them work in sql server 2012?
Any help would be highly appreciated!! Thanks in advance!
Please help.

No comments:

Post a Comment