Post reply

copy stored procedure object

  • August 25, 2009 at 12:14 am

    #214295

    Hi,

    I'm facing a problem and unfortunatly can't find my way out of this maze.

    I try to write a script that copies a bunch of stored procedures from one database to another one created earlier in the job. This new DB is sort of a snapshot of the source one at the time the job is run. So I don't want to script the SP in the job, but I need to copy the SP "objects" between the DBs.

    I hope this makes sense ...

    Any help will be much appreciated.

    Thanks

    🙂

  • August 25, 2009 at 1:07 am

    #1044009

    Hi,

    I might have found a work around ... Is there a way to create a SP with a system stored procedure?

    Thx

    EDIT: got it : sp_executesql but work around doesn't work yet

  • September 25, 2009 at 4:40 pm

    #1058694

    Is this resolved?

    MJ

  • October 5, 2009 at 9:04 am

    #1061801

    No, not yet, but I propose to close this thread as it's not accute anymore ... for the moment

    how can I close it?

  • October 5, 2009 at 9:08 am

    #1061808

    rot-717018 (10/5/2009)

    No, not yet, but I propose to close this thread as it's not accute anymore ... for the moment

    how can I close it?

    You are not allowed to close the thread, but you can add to it later on, or just create a new topic

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 5, 2009 at 9:11 am

    #1061810

    ok, thanks ...

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply