Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Cool Unanswered: moving SPs and jobs

    I need to move all the stroed procedures and jobs from a sql7 to a sql2000 server. I have looked through the system SPs and Microsoft's site and have come up empty...Has aanyone done this and how.

  2. #2
    Join Date
    Nov 2003
    Posts
    94
    Check out INFORMATION_SCHEMA.ROUTINES in BOL. The big trick is joining together the fragments of routines larger that 4000 characters long.

Posting Permissions

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