Need to retrieve SQL Express procedure definition

Discussion in 'General Computer Support' started by irishrose0312, Apr 30, 2010.

  1. irishrose0312

    irishrose0312

    Joined:
    Apr 30, 2010
    Messages:
    1
    HI,

    I am currently working on a program that will be a versioning tool for our databases. As we go from VB to VB.net we are also changing from MS Access to SQL Express 2008. I need to make this versioning tool work with both Access and SQL Express. To do this, I am using System.Data.OLeDb. In Access I can get the procedure definitions without any problems by using
    oTable = oConn.GetOleDbScehemaTable (OleDbSchemaGuid.Procedures, New Object() (Nothing, Nothing, Nothing)). However, this does not work in SQL Express. How can I get the procedure definition from SQL Express doing a similar thing in code?

    Thanks for any help you can provide.

    Lora
     
    irishrose0312, Apr 30, 2010
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian Whiting
    Replies:
    2
    Views:
    747
    Brian Whiting
    Dec 29, 2005
  2. Richard Miller

    Retrieve a message in outlook express

    Richard Miller, Nov 3, 2003, in forum: Computer Support
    Replies:
    2
    Views:
    690
    Trent C
    Nov 3, 2003
  3. Tommy
    Replies:
    1
    Views:
    1,850
    Mr. Arnold
    Nov 29, 2007
  4. Vicky
    Replies:
    0
    Views:
    694
    Vicky
    Apr 6, 2007
  5. Darrilgibson@gmail.com

    MCITP SQL Server 2005 or SQL Server 2008

    Darrilgibson@gmail.com, Dec 19, 2007, in forum: MCITP
    Replies:
    0
    Views:
    1,479
    Darrilgibson@gmail.com
    Dec 19, 2007
Loading...

Share This Page