Sql Tip: Update Fields on Tables across several Databases, at once
There was a good thread on the
SqlAdvice.com Stored Procedure list today which included several solutions for this problem. The latest and ostensibly best one so far can be found in
the sql archives here. That list, and the other lists on SqlAdvice, are great places to ask questions about anything database and SQL related.