<div>
Also, the above requires doing it in SQL Server. &nbsp;It is not possible in Access to open up a SQL Server SP, let alone troubleshoot it.
</div>


Also, the above requires doing it in SQL Server.  It is not possible in Access to open up a SQL Server SP, let alone troubleshoot it.

<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim<br />
<br />
btw This gives me an idea ... perhaps I should write an article in EE about SQL Server SP troubleshooting tips. &nbsp;If I do I'll post you a link.
</div>


Thanks for the grade.  Good luck with your project.  -Jim

btw This gives me an idea ... perhaps I should write an article in EE about SQL Server SP troubleshooting tips.  If I do I'll post you a link.

<div>
<div class="content wysiwyg-content">
I use the following sql in an MS Access 2003 pass-through query to run a SQL Server 2008 stored procedure:<br />
<br />
[dbo].[sp_PS_Load_tblDiscr<wbr />epanciesLe<wbr />vel123Tmp]<wbr /> 52,'pgLevel123',36<br />
<br />
Is there a way to step through the sp code so I can debug it?
</div>
</div>


I use the following sql in an MS Access 2003 pass-through query to run a SQL Server 2008 stored procedure:

[dbo].[sp_PS_Load_tblDiscrepanciesLevel123Tmp] 52,'pgLevel123',36

Is there a way to step through the sp code so I can debug it?

Step Through Stored Procedure

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.