Thanks for all of the input. I would like to add that we are labeling our releases. I just forgot to mention it in the scenario.

Once again, thanks....

Thanks alot for the advice. I am going to start breaking this up into more manageable pieces and do as you said and spread the process across multiple servers...

Thanks for the post. I now have the files.

Keith

I do have all of the scripts backed up. The script was lost before my time as DBA at my company.

The scripts for this process are unavailable. Would anyone happen to know where I might find them?

Aside from the benefit of address reuse, are there any performance issues regarding the first model.  It would definitely be easier to maintain having all addresses in one table.  Also,...

Try this:

' + CASE WHEN IsNull(@TermID, 0) = 0 THEN '''' ELSE '

Since you are checking a string, it may be necessary to convert phrase to a string like this:

'...

Wound up going with Schleep's suggestion.  I was a able to create query to actually create the OSQL commands for me then I just executed the OSQL commands.  This worked great.  I...

How can I get around the fact that sp_msforeachdb will only accept 2000 characters.  My trigger script contains more characters than that.  Also, what do I do about constant data...

One other issue that is cropping up with using multiple dbs is that all of the sql for the application must be dynamic to include the db name.  This makes...

Why??????  If the report used the clientid as a parameter, why can you not control it?

Kevin G is correct.  All client dbs would have the exact same schema.  In fact that is how we create a new client.  We have a client model database that...