MSSQL MARS SPROCS

[kevin plummer]

Hi All,

Does anyone have a web app or web app/back office windows app using a combination of all above?

I have a web app using MARS and back office app using Sprocs connecting to the same MSSQL DB. I think when the sproc is run the web app crashes. With MARS off no crashing but SQL record locking problems.

Anyone have experience with the above. Any way around the prob?

Cheers,


Kevin

[kevin plummer]

To Clarify, it seems to be Sprocs with Transaction framing are the problem but still testing