Can conditional breakpoints be set while debugging in SSMS?
I've just begun using breakpoints to debug a T-SQL stored procedure in Management Studio (SQL Server 2008). I notice that the breakpoints window has a condition column:
But I can't find any way to actually specify a condition on a breakpoint, not via the Debug menu, not via a context menu on the breakpoint or within the breakpoint window, etc.
Is there a way to use conditional breakpoints in SSMS, or does that column exist for some future version?
Solution
No, they can't. From this site, you can see some of the other limitations also.
Here's the relevant quote:
The T-SQL debugger does not support the Microsoft Visual Studio features of setting breakpoint conditions or hit counts.
- Query to check whether a column is nullable
- A connection was successfully established with the server, but then an error occurred during the pre-login handshake
- Executing SQL Server Agent Job from a stored procedure and returning job result
- SQL Unit Testing Stored Procedures
- How to find which column is violating Constraints?
- SSIS set result set from data flow to variable
- Convert varchar into datetime in SQL Server
- How can I get the last 12 months from the current date PLUS extra days till 1st of the last month retrieved
- How does alter table switch work on SQL Server?
- Do clustered indexes have to be unique?
- How to find which OLE provider is available for SQL Server?
- Find Physical Location of Filegroup on SQL 2008 using TSQL
- SQL Server 2008 problem with Authentication
- INSERT INTO vs SELECT INTO
- Issue with bulk insert
- Conditional split based on array variable
- How to rollback or commit a transaction in SQL Server
- Using RegEx in SQL Server
- How to print VARCHAR(MAX) using Print Statement?
- An attempt to login using SQL authentication failed
- SQL Server Varbinary(max): select a subset of bytes from the varbinary field
- T-SQL - Projecting multiple records into one row for each key
- Pros & Cons of TRUNCATE vs DELETE FROM
- How to disconnect all users in sql server except sa?
- How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
- SQL Server add auto increment primary key to existing table
- Selecting all with a length of less than 8 characters, and not null, and not empty
- SQL date format conversion to MMDDYYYY
- How can I query how much time a SQL server database restore takes?
- To find the next work day