Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    10

    Unanswered: Newbie question: Debugegr for SQL Server 2000 (e.g. through Visual Basic???)

    I am using the SQL Server 2000 query analyser to write stored procedures for an SQL Server 2000 database.

    I would like to find a debugger to help me "look into" my stored procedures as they are executed (e.g. to watch a Cursor fill a table row by row, see the contents of temporary tables as a stored procedure progresses, etc.)

    Could anybody, please, direct me to-

    * Any debugger that does this
    OR
    * Simple instructions how to run stored procedures from Visual Basic. I suspect :) that VB's debugger may be able to look into the SQL as it is being executed, but I don't actually know how to use VB itself.

    Thanks very much,

    Angelos

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    SQL Query Analyzer comes equipped with a Transact-SQL debugger that allows you to control and monitor the execution of stored procedures. The debugger supports traditional functionality such as setting breakpoints, defining watch expressions, and single stepping through procedures. This functionality is available when the SQL Server service uses a domain user account.

    It is not advisable to use the Transact-SQL debugger on a production server. While in step execution mode, the debugger can lock certain system resources that are needed by other processes.



    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2004
    Posts
    10

    Visual Studio .NET

    Visual Studio .NET has a T-SQL Debugger written into it.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The Enterprise Edition of VB (and also VC) have a Transact-SQL debugger too.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •