Post reply

Migrating MSDB stored procedures

  • June 15, 2009 at 9:26 am

    #206019

    Hi,

    I am doing migration from SQL Server 2000 to 2005.

    Could anyone please tell me whether I should migrate the MSDB stored procedures that are outside the folder “System Stored Procedures “like r_iRTblClassDefs, r_iRTblClassExtension, r_iRTblDBMProps etc..,

    Actually,these stored procedures are present in every SQL Server 2000 instance we have. I am not sure whether these are user created or system created.

    Thank You,

    Yours

    SQLBuddy

  • June 15, 2009 at 9:52 am

    #1009741

    Should or should not... that is not a question for others to answer.

    The real question is do you need the SPs now or they are no longer needed... if so just script them out and save/archive them someplace. In case if you'll need them again.

    Also... I would find a copy of "bare bone" sql 2000 msdb and run RedGate SQL Compare between two. This way you may find some other stored procedures that somebody before you modified or added to msdb.

    cheers

    ~Leon

  • June 15, 2009 at 10:40 am

    #1009767

    Hi Leon,

    Thank you very much for your reply. I really appreciate your help.

    Yours

    SQLBuddy

Viewing 3 posts - 1 through 2 (of 2 total)

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