In SQL Server Management Studio, start the execution with the green arrow (Debug) or ALT+F5. if you have the rights to do debugging at all, you can then step through the code with F10 (step over) and F11 (step into). Haven't used SQL Server Express in quite awhile, but there probably is no debugger available there.
Microsoft used to have a developers version of SQL Server management Studio available for cheap ($49?) and if you have MSDN access, it's included, just need to download it. Fred On Wed, Nov 23, 2011 at 10:49 AM, Rafael Copquin <[email protected]>wrote: > I would like to follow a stored procedure behaviour line by line, as one > can do in VFP with the debugger. > I need to know what is the value of the parameters received by the SP > as they are passed from VFP via SPT, to determine why the heck the SP is > not working > > What are the commands in TSQL or the way to do it in SQL Server? > I mean, is there a menu option to check to start the debugger in SQL > Server Express or there is no such thing? > > TIA > > Rafael Copquin > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbkso9pch+kgo7plyv1jyqf9t7t_njth2rdaerzhotqfp...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
