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. General Programming
  3. Visual Basic
  4. SQL Server 7.0

SQL Server 7.0

Scheduled Pinned Locked Moved Visual Basic
databasesql-serversysadminhelp
5 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.
  • P Offline
    P Offline
    prubyholl
    wrote on last edited by
    #1

    I just joined a company that uses SQL 7.0,which am not that much used too. i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS and can view triggers and other objects with 'sysobjects' i want to view the code for the triggers in a particular table... PLEASE HELP ME...THANKS

    M 1 Reply Last reply
    0
    • P prubyholl

      I just joined a company that uses SQL 7.0,which am not that much used too. i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS and can view triggers and other objects with 'sysobjects' i want to view the code for the triggers in a particular table... PLEASE HELP ME...THANKS

      M Offline
      M Offline
      Mycroft Holmes
      wrote on last edited by
      #2

      the tool is called Query Analyser and is installed with SQL client.

      Never underestimate the power of human stupidity RAH

      P 1 Reply Last reply
      0
      • M Mycroft Holmes

        the tool is called Query Analyser and is installed with SQL client.

        Never underestimate the power of human stupidity RAH

        P Offline
        P Offline
        prubyholl
        wrote on last edited by
        #3

        PLZ WHAT SQL COMMAND DOU TYPE THERE TO VIEW THE TRIGGERS AND THEIR CODES

        M D 2 Replies Last reply
        0
        • P prubyholl

          PLZ WHAT SQL COMMAND DOU TYPE THERE TO VIEW THE TRIGGERS AND THEIR CODES

          M Offline
          M Offline
          Mycroft Holmes
          wrote on last edited by
          #4

          Mate you have more problems than I am going to be able to help you with. SQL server 7 is so old it is no longer supported by MS, if you have QA you are just going to have to find your way around it. Most here have not seen SQL 7 for 8 YEARS or more. I'm really sorry if you have to work with SW so old and truly hope you get the opportunity to upgrade because you are going to find very limited support for SW so far out of date.

          Never underestimate the power of human stupidity RAH

          1 Reply Last reply
          0
          • P prubyholl

            PLZ WHAT SQL COMMAND DOU TYPE THERE TO VIEW THE TRIGGERS AND THEIR CODES

            D Offline
            D Offline
            Dave Kreskowiak
            wrote on last edited by
            #5

            You might want to stop YELLING and then ask this question in the SQL Forum since it has nothing to do with VB or VB.NET.

            A guide to posting questions on CodeProject[^]
            Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
                 2006, 2007, 2008

            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