Does not work during debugging

[mediterano]

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

[FilipDeVos]

Hi, I just noticed this issue right now. Very sorry for that.

Could you let me know the version of SQL Server/SSMS you are using? I haven't really used this proc in the last years so I will need to verify it on newer version of SQL Server.

[mediterano]

Hi Filip, I used it on MSSQL 2016 SP1

Get Outlook for Androidhttps://aka.ms/ghei36

From: Filip De Vos Sent: Tuesday, October 9, 4:54 PM Subject: Re: [FilipDeVos/sp_select] Does not work during debugging (#5) To: FilipDeVos/sp_select Cc: Erdöl Biramen, Author

Hi, I just noticed this issue right now. Very sorry for that. Could you let me know the version of SQL Server/SSMS you are using? I haven't really used this proc in the last years so I will need to verify it on newer version of SQL Server. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/FilipDeVos/sp_select/issues/5#issuecomment-428224276, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AK-iggfZE8THZiXXOli9Pvdm4lLBEieNks5ujLiSgaJpZM4UP-PX.

[danellisuk]

Same issue here using MSSQL 2016 SP2 with SSMS 17.9.1

Edit: The issue turned out to be an outer transaction blocking access.