SQL Server Performance

run store procs

Discussion in 'SQL Server 2005 General Developer Questions' started by Reddy, Jul 18, 2007.

  1. Reddy New Member

    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"

  2. dineshasanka Moderator

    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/
  3. Reddy New Member

    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"

  4. satya Moderator

    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.

Share This Page