This is now only possible (by my knowledge) in visual studio, with the SSDT (sql server data tools) extension installed. https://learn.microsoft.com/en-us/sql/ssdt/debugger/transact-sql-debugger?view=sql-server-ver16