Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-22 : 08:45:24
|
| Amit writes "we can perform transaction in sql server........ with four isolation levels ........ and also the frontend tools like vb.net gives us a chance to write transaction using ado.net.... my doubt is what happens in the scenerio where my frontend system has issued a command with an isolation level but ....the sql serever stored procedure it called have a different isolation level ? How'zattt !!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-22 : 08:47:38
|
| You can remove all doubt by NEVER using application-level transactions. All database transactions should be handled entirely in the database, preferably through a stored procedure that encapsulates the entire data process. The only time an app should control a data transaction is when an external process, like credit card validation, must also occur as part of the transaction. Even then, it is better to perform as much of the external functions separately from the data transactions. |
 |
|
|
|
|
|
Transactions