Instead of manually counting nested level, check the value of @@nestlevel

If this is happening after the connection is established, please ensure that connection is not broken before reading from table. Check connection.state property value. Also check the connection.connectionTimeout value. If...

Do your table have any indexes? or what columns? what type of indexes? how many records are retrieved by the query? how much time it takes now? is table statistics...

Man, I got you !!!

The problem is with the following lines:

select @newStatus = (select activ from Inserted)

select @theId = (select departmentunit_id from Inserted)

B'coz u are assigning a whole...