SQL Server Performance Forum – Threads Archive
Transactional Handling at Database LevelHi, Please provide me input when to use Transaction handline at Database Level or at Application Level. I am trying to find which is best in which all condition. If anyone you have any input please add your comments. Thansk and Regards
Hi Ravi, it depends on whether your application puts all statements for a single transaction into a single SQL call. This would be preferred for ease of maintenance and performance (esp if stored procs are used) Cheers
What kind of application is using this SQL server database?
Are you looking for performance based solution or a simple data consistency based approach? http://www.sqlteam.com/Item.asp?ItemID=11828
http://www.4guysfromrolla.com/webtech/080305-1.shtml Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.