TSQL-Debug in SQL 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: TSQL-Debug in SQL 2000

  1. #1
    Werner Guest

    TSQL-Debug in SQL 2000


    One of my kindest and oldest dreams: being able to debug stored procedures
    in a similar way I debug a VB-Program.....


    What I can do

    - SQL Query Anayzer, rightclick SP
    - Select Debug, then Execute to open T-SQL Debugger
    - Set Breakpoints


    What I cannot do (what I would like to do most of all)

    - Step into, step out, run to cursor ...
    - The respective buttons, rightclick-menue-point are grayed.

    Can you tell me why (would be worth a second copy of your book ;-) )!!



    Kindly yours


    Werner
    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: TSQL-Debug in SQL 2000

    Hi Werner,

    What account is the SQL Server Service running under? The symptoms you are
    telling me about are one of many symptoms that I've seen when running SQL
    Server using the local system account. In a nutshell, the SQL Debugger
    doesn't work well when SQL Server is using the local system account. If you
    run it under a normal NT user account, then I suspect you'll see your
    problems go away.

    --
    Rob Vieira
    Visit www.ProfessionalSQL.com Today. It's new and improved!

    "Werner" <wzoller@mbbm.de> wrote in message news:3a6ee6d3$1@news.devx.com...
    >
    > One of my kindest and oldest dreams: being able to debug stored procedures
    > in a similar way I debug a VB-Program.....
    >
    >
    > What I can do
    >
    > - SQL Query Anayzer, rightclick SP
    > - Select Debug, then Execute to open T-SQL Debugger
    > - Set Breakpoints
    >
    >
    > What I cannot do (what I would like to do most of all)
    >
    > - Step into, step out, run to cursor ...
    > - The respective buttons, rightclick-menue-point are grayed.
    >
    > Can you tell me why (would be worth a second copy of your book ;-) )!!
    >
    >
    >
    > Kindly yours
    >
    >
    > Werner



    Share on Google+

  3. #3
    Werner Guest

    Re: TSQL-Debug in SQL 2000


    >What account is the SQL Server Service running under? The symptoms you are


    I have two instances of SQL2k: one is running under a local account (not
    system) and the other under a domain account

    Are there an particular rights or permissions, it must have?

    >run it under a normal NT user account, then I suspect you'll see your problems

    go away.

    Unfortunately: No!


    Werner

    Share on Google+

  4. #4
    Rob Vieira Guest

    Re: TSQL-Debug in SQL 2000

    I shouldn't have put it as "normal" NT user account - the SQL Server Service
    account must actually have admin rights to the box you're debugging on.

    Note that I consider it very important that you limit the notion of using an
    administrator account for the SQL Server Service to development systems
    only.


    --
    Rob Vieira
    Visit www.ProfessionalSQL.com Today. It's new and improved!

    "Werner" <wzoller@remove.nospam.mbbm.de> wrote in message
    news:3a712a00$1@news.devx.com...
    >
    > >What account is the SQL Server Service running under? The symptoms you

    are
    >
    > I have two instances of SQL2k: one is running under a local account (not
    > system) and the other under a domain account
    >
    > Are there an particular rights or permissions, it must have?
    >
    > >run it under a normal NT user account, then I suspect you'll see your

    problems
    > go away.
    >
    > Unfortunately: No!
    >
    >
    > Werner
    >



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center