SQL Server Performance Forum – Threads Archive

run store procs

I have 126 store procs in a database and according to the request now I have to create 6 such databases with the same schema, what wud be the best solution to run all the store procs for different DB’s at one time.
Is that runnning a maintenance plan or anything other solution? Thanks!
"He laughs best who laughs last"

---

how about restoring them. that has less risk i guess —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

already there are 6 more databases and now i have to use one set of store procs(as they are same in all db’s) to generate report at one time from all the different databases.
My goal is to run one set of store procs which shud work for all other db’s as those store procs are repeated in the rest. Thanks!
"He laughs best who laughs last"

---

DO you need to have similar data too?
If so only restore is the best option, otherwise simply script the source database and apply as a new database creation in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>