Had an issue on our server where there are a number of processes locking the server. When I have used the
DBCC INPUTBUFFER TO SEE WHAT T-SQL is causing the lock I get the following SQL:
SET NO_BROWSETABLE ON
Googled it but haven't found any meaningful explanation and to what it is. Can anyone tell me what this is ?