Hello Mr. Randal,

Finally got a response from premier support below is their final statements.

Cause

As per our research this is a known issue only occurs on SQL SERVER 2012 Instances when...

Mr. Randal,

MSFT called back to inform us that we may have a TEMPDB corruption. However, I told them running the consistency checker displays no corruption, therefore, their corruption team will...

Hello Mr. Randal,

Thanks for replying so quickly. We are in the process of opening a case.

Hello. I know this is an old post, however, I just experienced this same issue with Microsoft SQL Server 2012 (SP1) - 11.0.3381.0 (X64) Standard Edition. I am still digging...

the query is just an single update statement. There are four update triggers on this table, with nested stored procedures, not to mention all the FK references.

We cannot script...

We are running SQL SERVER 2008 R2 STD 10.50.4295 which is the most recent build and we can duplicate this issue on demand. the only workaround we have found is...

My pleasure, I am glad I can give back to the SQL Server community. As I mentioned earlier, I will keep this post updated with our progress.

Hello,

EMC mentioned that Networker and it’s SQL module are not going away or being replaced with Avamar. However, we have put together a list of requirments this module must meet....

Do you have any documentation that you would consider sharing with your issues/concerns?

Thanks again, much appreciated. I pinged our internal storage team, they mentioned that EMC is not deprecating Networker SQL module with Avamar. However, they have a meeting with EMC’s Backup...

Hello,

Thanks for the information, great to know. Strangely, our internal storage team has not mentioned that EMC is doing away with this module.

currently looking at getting this information. We have to simulate this in a test environment, which requires us to build a few servers.

We had to include the SET statements because the trigger was failing without them. We first attempted to place the SET statement outside the procedure which did not work. Therefore,...

There is heavy insert and update activity being performed against the temporary table, also with an active explicit transaction. however, the background process being blocked is causing the login trigger...

3) have you tried sp_whoisactive to see if you can get details about what each spid is actually doing? awesome freebie from Adam Machanic

Reply: have the procedure. We know what...