Solved

Unable to debug SP or TSQL statements in SQL 2008 R2

Posted on 2013-01-16
7
420 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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 eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to set focus on a dynamic control 18 47
MSSQL 2008 R2  Check to see if a Index/Key Exist 7 23
debug user defined function in visual studio 2015 2 45
C# DateTime Help 6 46
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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

738 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