troubleshooting Question

Update column in all databases

Avatar of Stef Merlijn
Stef MerlijnFlag for Netherlands asked on
Microsoft SQL Server
4 Comments2 Solutions18 ViewsLast Modified:
Hi,
I need to update a certain Table's Column in all user database (no Master and Reporting databases) in SQL Server.
The value set in the Column is for all databases the same.
Basically the query (or SP)  would do something simple like this, but automatically over all database.
Update <database>.dbo.<Tablename> SET <Column> = 'my value'
How can this be done?
ASKER CERTIFIED SOLUTION
Pavel Celba
All in One

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros