Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Nested stored procedure Transactions

Home
Forums
General

Nested stored procedure Transactions

margam chakri

5yAsked Apr 17, 2021, 12:36 PM743General

Hi,

If i use transactions in nested stored procedures ,how can i find out particular sp getting error ?

and i dont want to rollback all transactions commit transaction before where i am getting error.

Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Hiesh Kidecha5y ago
Please refere this link : https://www.codemag.com/article/0305111/handling-sql-server-errors-in-nested-procedures
Jignesh Kumar5y ago
Hi, Please refer this thread which will help you, https://www.mssqltips.com/sqlservertip/5356/handling-sql-server-transactions-in-nested-stored-procedures-using-savepoints/#:~:text=The%20idea%20is%20that%20the,to%20be%20set%20to%200.