I want to update a table in each db on server

I have a config table with same fields开发者_如何学C "SMTP_Server". I want to update the fields with new value in each database on the server.

sp_foreachdb updates last table (in last database). Why?

please help

---

This sp doesn't seem to be "officially" supported and sometimes has problems...

See: Making a more reliable and flexible sp_msforeachdb at http://www.mssqltips.com/tip.asp?tip=2201&home

...I have discovered instances where, under heavy load and/or with a large number of databases, the procedure can actually skip multiple catalogs with no error or warning message. Since this situation is not easily reproducible, and since Microsoft typically has no interest in fixing unsupported objects, this may be happening in your environment right now. ...