Stored Procedure Automatic SQL Transaction

Posted on 2009-04-23
Last Modified: 2012-05-06
When you have a Stored Procedure on SQL Server 2005, by virtue of the SP is everything in the SP considered to be in a transaction.  This means that a transaction is not specified in the SP.  In the SP you will have several inserts, deletes and updates.
Question by:rcvalentinis
    LVL 31

    Expert Comment

    I don't understand your question clearly, even have a look at below link which has used Transaction in SP.

    Author Comment

    When you write a SP, is it automaticaly part of a SQL transaction without specifing a transaction.
    LVL 31

    Accepted Solution

    no, it will not.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    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 sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now