Thursday, April 15, 2010

"Transaction context in use by another session" and linked server

if you use linked server and loopback server then call SPs using the linked server, this scenario is not supported.

you will need to modify the code to call the SP directly.

Disable Microsoft Defender for Cloud for Visual Studio Subscription (MSDN)

I use a visual studio pro subscription which comes with $150 azure cloud credit, for some reason Microsoft Defender for Cloud was turned on ...