Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Unable to debug SP or TSQL statements in SQL 2008 R2

Posted on 2013-01-16
7
Medium Priority
?
428 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 1200 total points
ID: 38782212
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 1200 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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

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.
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

824 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