I have one question rlated to SQL-Transaction, I have 4 tables in the database and primary key of first table should aapear as an attribute in all three tables, here I'm using SQL-transaction to insert the data in all four tables. I have inserted data in first table and taken the last inserted value (primary key value) using @@identity and now I'm trying to insert the data in all three tables along with first table's primary key value but while inserting the data in thired table there is error has accured...now I want to rollback all inserted data from first and second tables. for that I have rollback it in cache block...the question is here,yet commit statement has not executed so I want to know whether data in first and second tables physically inserted or logically , if physically then rollback action internally delete the data and delete the log as well...is it true?? and if logically then what will be the internal process in that case..??.where data will stored logically...??
Submit an article or tip