Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    sheffield, uk
    Posts
    14

    Unanswered: Moving Stored Procedures

    CAN ANYONE TEL ME THE BEST WAY TO MOVE STORED PROCEDURES FROM THE master DATABASE ON ONE SERVER TO THE master DATABASE ON ANOTHER SERVER ?

    ARE THERE ANY SPECIAL CONSIDERATIONS TO BEAR IN MIND WITH IT BEING THE master DATABASE ?

    THANKS FOR YOUR HELP
    Mark Davies
    itsmarkdavies@hotmail.com

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    This sounds familiar - you wouldn't be posting on multiple sites would you?

    When you install sql server all the system stored procedures should be created.
    If you have place user stored procedures in master then maybe you should consider whether it is a good ideas.

    Moving is same as any other dtabase - just script them off and apply the script to the destination. Easy if you keep the scripts in SourceSafe which I would recommend.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •