Unable to debug SP or TSQL statements in SQL 2008 R2

Unable to debug SP or TSQL statements in SQL 2008 R2. I get error as shown in the attachment. How to resolve this issue? Please do help.

Other than built-in debugging option what are the other ways I could debug SPs and T-SQL statements?

Please do help.
SP-Debug.jpg
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?
 
AnujSQL Server DBACommented:
You can do this from visual studio also.
0
 
Pratima PharandeCommented:
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Easwaran ParamasivamAuthor Commented:
@anujnb: How to do from VS
0
 
AnujSQL Server DBACommented:
check this KB
0
 
Easwaran ParamasivamAuthor Commented:
In production I won't have VS. Hence it is not possible. My intention is to debug in production.
0
All Courses

From novice to tech pro — start learning today.