I use SQL Express Profiler, is open source. https://sites.google.com/site/sqlprofiler/
Start a New Trace, set the necessary login information and in the Events Panel make sure only these check-boxes rows are selected, to avoid too much noise: RPCCompleted SQLBatchCompleted SQLFullTextQuery Then select Run. Execute your VFP query vs SQL-Server and your query will be logged with the exact code sent to SQL-Server. Happy debugging! ;) Gianni On Wed, 23 Nov 2011 14:49:57 -0300, Rafael Copquin <rcopq...@fibertel.com.ar> 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: ProFox@leafe.com 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/7ldqc7dkk0u066rcjl9pf8rdjqj59m2...@4ax.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.
