Very IMP - PARTIAL ROLLBACK

Is partial Rollback possible
Look the below Logic

FOR 1 TO 100 RECORDS
BEGIN TRANSACTION

INSERT RECORD IN TABLE "A" - assume that we have inserted 10 records without errors in the loop
If Error occurs on the 11th record then I call procedure ERRORLOG
In the ErrorLog procedure I am inserting error description record in Error table

ROLLBACK TRANSACTION - Records should not be inserted in table "A" but inserted in ErrorLog table as there is an error
END
END FOR

Please tell me how is this possible. Is there a seperate block which can commit the transaction only for that block. It is possible in Oracle but I dont know for SQL Server

Try looking in the SQL Server Books Online. And try posting in an appropriate forum, I see nothing about ASP here.

Is this the SQLServer forum or not? It looks like it to me. I realise this website is called aspfree but there is a SQLServer forum. Are you telling people not to post in it, cos there's about 47 pages of posts in here that don't relate to asp?????? Very confused!

This question was originally posted in the ASP Development area.
It was moved to the correct forum area by a moderator.

Aha, I see! Now it makes sense.