Post reply

T-SQL Debugger?

  • September 19, 2008 at 9:25 am

    #212896

    HI all,

    Can any one tells me how to use t-sql debugger. I have seen that you can right click on stored procedure and it will give you option of Debug. But i cant see that option. If i dont have permission then it should be disable.

    Any suggestion please?

    I have seen it on this website.

    http://www.15seconds.com/Issue/050106.htm

    thanks.

  • September 19, 2008 at 11:55 am

    #874396

    The only one way that works is to conver stored procedure into a script and use print commands everywhere you need to retrieve a value..

  • September 19, 2008 at 5:19 pm

    #874505

    Your posted reference refers to SQL 2000 and you have posted your question to a SQL 2005 forum. There are many debugging tools available for specific functions in SQL 2005, such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Analysis Services since SSAS uses CLR (Common Language Runtime) modules or COM libraries (normally dlls). But for general T-SQL a debugger such as that available in SQL 2000 just does not exist.

    For what debugging services are available and specific instructions on how to use the feature refer to Books On Line (BOL)

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply