Home All Groups Group Topic Archive Search About

T-SQL does not support breakpoint Conditions

Author
30 Dec 2005 9:00 PM
LvBohemian
When attempting to select the breakpoint condition from within the VS05 RTM
IDE I get the following error message:
"T-SQL does not support breakpoint Conditions"
What's up with that?

Also, why the heck would you not be able to debug TSQL from "SQL Server
Management Studio" ?

This is bogus...

Author
30 Dec 2005 10:42 PM
Erland Sommarskog
LvBohemian (LvBohem***@discussions.microsoft.com) writes:
> When attempting to select the breakpoint condition from within the VS05
> RTM
>  IDE I get the following error message:
>  "T-SQL does not support breakpoint Conditions"
>  What's up with that?

Breakpoint condition? You mean "Only break here if @x = 12?"

If it says that it is not supported, I guess that it is not supported.

>  Also, why the heck would you not be able to debug TSQL from "SQL Server
>  Management Studio" ?

You can always cast your vote on
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=c
b5678d4-2dab-4375-a806-f50123f6d235

Personally, I think it's funny how much functionality from Query Analyzer
that did not make it to Mgmt Studio, and the debugger is one of them. But
I will have to confess that I have about given up using the debugger in
SQL 2000. There is just too much red tape to get it to work, when the
server is on another machine. And since you cannot view tables from it,
it's of limited use anyway. Debug SELECTS are better. (Of course, if you
run a lot of loops, then it might be useful. But loops is something
you should not do very often in SQL programming.)


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button