Results 1 to 2 of 2
  1. #1
    emmahope206 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    5

    Help with SQL stored procedure

    Hi All,

    Hope you can help. I am an experienced Access developer but completely new to SQL Server. I have inherited a database with a pass through query which 'EXECs' a stored procedure to a backend database (SQL server I believe).

    I need to make a change to this stored procedure to add an extra (new) field to it. I have figured out how to create a new stored procedure (with google's help) but my problem is I have no idea WHAT the original stored procedure is doing (I belive it is joining several unknown (to me) tables & returning certain fields with a date parameter of >2016). I need to be able to 'read' what the original stored procedure is doing so I can recreate it with the new field.

    Please can anyone offer some advice as to how to get the actual SQL for the stored procedure via my access DB so I can do this?

    I am currently working in Access 2013.

    Thanks
    Emma

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I too am making the leap to SQL Server.

    Do you know the path to the SQL MDF (the BE)?
    Do you know what version of SQL Server you are using?
    You will need to install the version of SQL Management Studio for the version of SQL Server you have.
    Note: Any version of SQL Server after SQL Server 2008 R2 will not install/run on Win XP. (at least I can't get any to install)

    Once SQL Management Studio is installed, and you connect to the BE, you will be able to create/view/edit the stored procedure (SP).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. write stored procedure with 'if else'
    By shital in forum Access
    Replies: 9
    Last Post: 04-11-2018, 11:47 AM
  2. Replies: 33
    Last Post: 09-25-2015, 08:39 AM
  3. Stored Procedure in MS Access 2007
    By sels1987 in forum Access
    Replies: 1
    Last Post: 05-13-2012, 12:23 PM
  4. Replies: 5
    Last Post: 09-26-2011, 03:58 AM
  5. Executing Oracle Stored Procedure
    By gsurfdude in forum Programming
    Replies: 0
    Last Post: 03-01-2011, 09:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums