When I set a breakpoint, wait it to be hit it during debugging and then execute the below statements in another tab, it causes SSMS to hang,
exec sp_select_get_rowcount 'tempdb..#MyTempTable'
exec sp_select 'tempdb..#MyTempTable, @max_pages=1
Even the use of
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
does not help
When I set a breakpoint, wait it to be hit it during debugging and then execute the below statements in another tab, it causes SSMS to hang,
exec sp_select_get_rowcount 'tempdb..#MyTempTable'
exec sp_select 'tempdb..#MyTempTable, @max_pages=1
Even the use of
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
does not help