>>Occurs to me you could also put all your sps in a drop and create script, always keep your changes there, then have a script that runs that script against each DB in a list.
What would the script that ran the drop and create script look like, Charles?
I have the same problem, on a smaller scale at several clients, and I have one script that I run from the query window against each DB.
I make a lot of changes, so if I had to do it with 12 I'd go batty.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.