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