We found that statements in our code which was inside an ASP Transaction object where failing. Getting some sort of permissions error. When we removed the Transaction object code and just ran our SQL updates sequentially the errors went away. Obviously this is not the preferred way to update our database. Is there anything we need to configure differently to allow our ASP code to use the Transaction object? Regards, James Post Edited (jibbercan) : 4/13/2008 3:05:53 PM GMT
ASP.NET Transaction is not supported due to certain technical reasons. You can, however, still use native SQL transaction. Bruce DiscountASP.NET www.DiscountASP.NET