General information
Forum:
Microsoft SQL Server
Title:
Can I step out of a transaction
hi
I have an importing process that is loading members into a SQL table.
There are several other tables that I also have to create entries in for address, subscription etc.
I've wrapped everything in a transaction so if one item fails I can rollback nothing gets added and that all works ok.
Is there any way I can update a file outside the transaction while its running. I don't want one particular thing to be based on the transaction at all.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only