OK, you just use the EXEC statement like that:

EXEC pMyStoredProc

If you want to use parameters or have a little error handling, your call would look more like something like that:

DECLARE...

What you could do to avoid redundancy and improve maintainability is putting your code in a stored proc and calling that SP from your 3 triggers. That way if you...

The code for stored procedures is stored in the syscomments system table, the following script should do the trick:

--USE YourDatabase

--GO

SELECT

o.name, c.text

FROM

syscomments c

...

Like I said in my last post, I like to order columns in a business logical order, but primarily I had 100 tables that I needed to use with replication,...

ok, guys, it's just that I needed to do add a column in the first position for like 100 tables, so I would have liked to be able to generate...