Step Through Stored Procedure

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?
paulmcneilAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
afaik nope.  You'll need to open the SP, comment out the 'create proc' line, enter the parameter values as you're calling it, execute, and debug the old fashioned way.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.