Solved

Unable to debug SP or TSQL statements in SQL 2008 R2

Posted on 2013-01-16
7
410 Views
Last Modified: 2013-02-06
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
0
Comment
Question by:Easwaran Paramasivam
  • 3
  • 2
  • 2
7 Comments
 
LVL 15

Expert Comment

by:Anuj
ID: 38782204
You can do this from visual studio also.
0
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 38782209
0
 
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 400 total points
ID: 38782212
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 400 total points
ID: 38782215
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 38782340
@anujnb: How to do from VS
0
 
LVL 15

Expert Comment

by:Anuj
ID: 38782351
check this KB
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 38799966
In production I won't have VS. Hence it is not possible. My intention is to debug in production.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now