That would be an option, although we manage many of our customers' access to our dbs via windows auth as well, and security restrictions prevent us from configuring domain trusts...

Thanks for the reply.

Yes, the stats have been updated fully several times for these tables.

Interesting to note: I can force both a hash join and a loop join on...

So, to answer my original question...

I've created a script that takes any list of sprocs, triggers or views based on any given criteria, makes any find\replace modifications to the code,...

In our testing envrionments, we have more than one "system" on a given instance.  A "system" is comprised of up to 5 databases, and the sprocs in question reference a...