Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. how to export stored procedures from local sql server 2000 to microsoft sql server

how to export stored procedures from local sql server 2000 to microsoft sql server

Scheduled Pinned Locked Moved ASP.NET
databasesql-serversysadmintutorial
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    somasekhara777
    wrote on last edited by
    #1

    how to export stored procedures from local sql server 2000 to microsoft sql server, i am sending but that is failed to copy. so plz send me the details. somasekhar

    j somasekhar

    A H 2 Replies Last reply
    0
    • S somasekhara777

      how to export stored procedures from local sql server 2000 to microsoft sql server, i am sending but that is failed to copy. so plz send me the details. somasekhar

      j somasekhar

      A Offline
      A Offline
      Abhijit Jana
      wrote on last edited by
      #2

      somasekhara777 wrote:

      how to export stored procedures from local sql server 2000 to microsoft sql server,

      You want to mean that, you want to export SQL Server 200 SP to SQL Server 2005 or what?

      somasekhara777 wrote:

      i am sending but that is failed to copy..

      How ?

      cheers, Abhijit CodeProject MVP

      1 Reply Last reply
      0
      • S somasekhara777

        how to export stored procedures from local sql server 2000 to microsoft sql server, i am sending but that is failed to copy. so plz send me the details. somasekhar

        j somasekhar

        H Offline
        H Offline
        Herman T Instance
        wrote on last edited by
        #3

        You can script each SP in Sql 2000 with the right mousebuttonclick on the SP name. If you combine all scripts into 1 large script....run that script on your new database

        In Word you can only store 2 bytes. That is why I use Writer.

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups