My sql server ont over 50 Database, and they got one standard and samme Store Procedure
Now, I need to update this SP.
for my old method. I place the SP content into SQL analyzer and choose each Database and then press "run"
For 50 databases , I need to choose 50 times and press 50 times.

Any simple method ?
such as I write a program and pass the database name to that program.
program A -> call program B
program A got selected database list --> program B "contains updated SP"
Thanks