Relative Content

Tag Archive for ssms

SSMS script to “Edit Top 200 Rows” for same table across multiple databases

I have about 15 databases with the same table in each (structure, not data) and I have to fill in some data in each depending on what each record says. It’s for about 10 records that can differ in each database and requires human thought for each edit so I can’t automate the process. Is there any way in SSMS or any extensions that offer a way to open the “Edit Top 200 Rows” window via a script that I can run on each database/table combination as opposed to drilling down through the Tables tree for each database?