?
Solved

Stored Procedure Automatic SQL Transaction

Posted on 2009-04-23
3
Medium Priority
?
266 Views
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.
0
Comment
Question by:rcvalentinis
  • 2
3 Comments
 
LVL 31

Expert Comment

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

http://www.4guysfromrolla.com/webtech/080305-1.shtml
0
 

Author Comment

by:rcvalentinis
ID: 24215161
When you write a SP, is it automaticaly part of a SQL transaction without specifing a transaction.
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 2000 total points
ID: 24215174
no, it will not.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
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.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 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