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. Database & SysAdmin
  3. Database
  4. Writing Stored Procedures

Writing Stored Procedures

Scheduled Pinned Locked Moved Database
databasesql-serversysadmintoolsquestion
6 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.
  • M Offline
    M Offline
    Michael P Butler
    wrote on last edited by
    #1

    I'm currently thrust back into the world of SQL Server Development after being away for quiet a while. I'm using the SQL Enterprise Manager to edit stored procedures. What does everybody else use? Are there some better tools out there than SQL Enterprise Manager for creating and updating stored procedures? Michael :-)

    M A 2 Replies Last reply
    0
    • M Michael P Butler

      I'm currently thrust back into the world of SQL Server Development after being away for quiet a while. I'm using the SQL Enterprise Manager to edit stored procedures. What does everybody else use? Are there some better tools out there than SQL Enterprise Manager for creating and updating stored procedures? Michael :-)

      M Offline
      M Offline
      Mazdak
      wrote on last edited by
      #2

      Michael P Butler wrote: What does everybody else use? I use the same thing and I don't have any problem with that.;) :) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
      Wish You Were Here-Pink Floyd-1975

      M 1 Reply Last reply
      0
      • M Mazdak

        Michael P Butler wrote: What does everybody else use? I use the same thing and I don't have any problem with that.;) :) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
        Wish You Were Here-Pink Floyd-1975

        M Offline
        M Offline
        Michael P Butler
        wrote on last edited by
        #3

        It is useable but it lacks the qualities of a decent IDE. I've taken to writing the procedure in the VC++ IDE and pasting them into Enterprise Manager. However this method isn't much use for making changes. I was hoping I'd overlooked a cool Microsoft SQL development tool somewhere and somebody could point it out to me and then laugh at me for being a dumb ass for still using Enterprise Manager :-D Michael :-)

        M 1 Reply Last reply
        0
        • M Michael P Butler

          I'm currently thrust back into the world of SQL Server Development after being away for quiet a while. I'm using the SQL Enterprise Manager to edit stored procedures. What does everybody else use? Are there some better tools out there than SQL Enterprise Manager for creating and updating stored procedures? Michael :-)

          A Offline
          A Offline
          AndyG
          wrote on last edited by
          #4

          I use Query Analyzer and like it a lot better than Enterprise Manager. Andy Gaskell, MCSD MCDBA

          M 1 Reply Last reply
          0
          • M Michael P Butler

            It is useable but it lacks the qualities of a decent IDE. I've taken to writing the procedure in the VC++ IDE and pasting them into Enterprise Manager. However this method isn't much use for making changes. I was hoping I'd overlooked a cool Microsoft SQL development tool somewhere and somebody could point it out to me and then laugh at me for being a dumb ass for still using Enterprise Manager :-D Michael :-)

            M Offline
            M Offline
            Mazdak
            wrote on last edited by
            #5

            It seems that I'm out of date.:-D (I hope I use correct word,my english is not very good.)I have to do something for myself.;) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
            Wish You Were Here-Pink Floyd-1975

            1 Reply Last reply
            0
            • A AndyG

              I use Query Analyzer and like it a lot better than Enterprise Manager. Andy Gaskell, MCSD MCDBA

              M Offline
              M Offline
              Michael P Butler
              wrote on last edited by
              #6

              Doh. I've been using it with the object browser window hidden. I am a dumbass. Thanks for pointing it out, that is much better for editing stored procedures. Michael :-)

              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