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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 web browser and sql server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-14 : 08:47:16
deepak writes "i want to know what will happen
when i m running a long transaction(1000's of insert statements) that i have submitted through a web browser. now in the middle of transaction i closed my web browser.
is there will be any dirty records in database.
if yes how it can be avoided
i m using asp.net and sql server2000"

nr
SQLTeam MVY

12543 Posts

Posted - 2005-01-14 : 20:41:49
Ifthey are in a transaction then the transaction will be rolled back.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -