Solved

Unable to debug SP or TSQL statements in SQL 2008 R2

Posted on 2013-01-16
7
416 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adding items to a C# list incrementally 5 58
sql2016-WIn10: standard,for SQL servc-account.. 51 42
c#, case, if 4 17
ComboBox to String Not Working 5 14
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore 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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

735 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