November 4, 2005 at 12:51 pm
First, my background ...I have worked with SQL-Server® (SS) in various aspects but mostly via ODBC and MS-Access. In the last 1-1/2 years, I have had the privilege of using SS Enterprise Manager and its tools including Query Analyzer (QA).
Recently, I have been using QA to design User Defined Functions (UDF's) and Stored Procedures (SPROCs). Unlike the VBA editor, in QA, there doesn't seem to be any way to step through the execution sequence and test the values of variables. Also, I haven't found a way to set breakpoints. I have been trying to use PRINT statements to test the values, but in the case of some constructs (SPROC's), it will not let me even put those inline with the code.
I have been searching through the "Books Online" (BOL) trying to find something useful. I read about a "debugging" feature in QA but was never able to find anything that told how to invoke it! It wasn't until I read a 3rd party SS tech manual, that I found out it is invoked via the Object Browser (OB) and right-clicking on the UDF or SPROC you want to debug.
Here is the problem. When I right-click, I get a menu and can see "debug", but, it is "grayed out"! It will not let me invoke it.
Would anyone have an idea of how to solve this problem?
Thanks in advance!
November 5, 2005 at 6:21 am
Sure you are right-clicking on a stored procedure since the menu is context-sensitive?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply