Using SMO to call Database.ExecuteNonQuery() concurrently?
- by JimDaniel
I have been banging my head against the wall trying to figure out how I can run update scripts concurrently against multiple databases in a single SQL Server instance using SMO. Our environments have an ever-increasing number of databases which need updating, and iterating through one at a time is becoming a problem (too slow).
From what I…