Click here to Skip to main content
15,920,031 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL and the growing log file Pin
Mekong River26-Aug-04 3:41
Mekong River26-Aug-04 3:41 
GeneralRe: SQL and the growing log file Pin
totig26-Aug-04 3:47
totig26-Aug-04 3:47 
GeneralRe: SQL and the growing log file Pin
Rocky Moore31-Aug-04 20:18
Rocky Moore31-Aug-04 20:18 
GeneralNested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 14:29
Sanjeev Kumar25-Aug-04 14:29 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
S Sansanwal25-Aug-04 16:33
S Sansanwal25-Aug-04 16:33 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 16:46
Sanjeev Kumar25-Aug-04 16:46 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay25-Aug-04 22:34
Colin Angus Mackay25-Aug-04 22:34 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 7:07
Sanjeev Kumar26-Aug-04 7:07 
Thanks Colin,
I have written an application just as proof of concept and it works fine. But, my boss think its not safe to do like this and he refering to Online Book Which say :-
----------------------
Specifying Transaction Boundaries
You can identify when SQL Server transactions start and end with Transact-SQL statements or API functions and methods.

Transact-SQL statements

Use the BEGIN TRANSACTION, COMMIT TRANSACTION, COMMIT WORK, ROLLBACK TRANSACTION, ROLLBACK WORK, and SET IMPLICIT_TRANSACTIONS statements to delineate transactions. These are primarily used in DB-Library applications and in Transact-SQL scripts, such as the scripts that are run using the osql command prompt utility.

API functions and methods

Database APIs such as ODBC, OLE DB, and ADO contain functions or methods used to delineate transactions. These are the primary mechanisms used to control transactions in a SQL Server application.

Each transaction must be managed by only one of these methods. Using both methods on the same transaction can lead to undefined results. For example, you should not start a transaction using the ODBC API functions, and then use the Transact-SQL COMMIT statement to complete the transaction. This would not notify the SQL Server ODBC driver that the transaction was committed. In this case, use the ODBC SQLEndTran function to end the transaction.
--------------

As per this document I am not suppose to mix transaction between ADO.NET and T-SQL. And I am not mixing transactions instead, I am nesting it.
Is there is any published article or document online which can help me explaning to my BOSS?


Thanks
Sanjeev
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay26-Aug-04 8:45
Colin Angus Mackay26-Aug-04 8:45 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 13:59
Sanjeev Kumar26-Aug-04 13:59 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay27-Aug-04 6:07
Colin Angus Mackay27-Aug-04 6:07 
GeneralParse sql query without executing Pin
tocheng00525-Aug-04 11:42
susstocheng00525-Aug-04 11:42 
GeneralRe: Parse sql query without executing Pin
S Sansanwal25-Aug-04 16:31
S Sansanwal25-Aug-04 16:31 
GeneralRe: Parse sql query without executing Pin
tocheng00526-Aug-04 12:07
susstocheng00526-Aug-04 12:07 
GeneralDataSet with GUIDs Pin
mikasa25-Aug-04 11:21
mikasa25-Aug-04 11:21 
GeneralRe: DataSet with GUIDs Pin
mikasa27-Aug-04 3:05
mikasa27-Aug-04 3:05 
GeneralDealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 10:36
david@mindplay.com25-Aug-04 10:36 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay25-Aug-04 11:13
Colin Angus Mackay25-Aug-04 11:13 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 11:28
david@mindplay.com25-Aug-04 11:28 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay25-Aug-04 12:22
Colin Angus Mackay25-Aug-04 12:22 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa25-Aug-04 11:24
mikasa25-Aug-04 11:24 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 11:51
david@mindplay.com25-Aug-04 11:51 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 12:13
david@mindplay.com25-Aug-04 12:13 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa26-Aug-04 3:38
mikasa26-Aug-04 3:38 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay26-Aug-04 12:01
Colin Angus Mackay26-Aug-04 12:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.