Post reply

Debugging an SP

  • November 13, 2007 at 8:38 am

    #750722

    Jeff,

    I don't believe you need to have SA privileges because I have used the debugger without having them in SQL Server 2000 Query Analyzer.

    vaidyanathan_kalyanasundaram

    I had the same problem as you are having with the debugger skipping over my breakpoints and just running the proc. So, what I did was update the service packs of my client tools. I don't recall if they had to match the exact service pack of the server though.

    The links VAIYDEYANATHAN.V.S posted are a good source. I definitely used the 15seconds.com one.

  • November 13, 2007 at 10:56 pm

    #750934

    How do i determine which service pack is installed on the client??

    On the server however i can determine that by using

    select serverproperty('productlevel') as ServicePackLevel

    Again, the Remote server runs an enterprise edition of SS ...

Viewing 2 posts - 16 through 16 (of 16 total)

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