Browse the archive

SQL Tooling

Azure Data Studio - Intellisense does not detect tables, yet queries work

August 23, 20212 min read

Question I’m breaking some new ground and trying to get into Azure Data Studio. I’m having a problem with intellisense that seems to be a bug with Azure Data Studio but I’m not sure. I have issues with basic queries. Foreign keys, select statements and insert …

DBA Stack Exchange SQL Tooling

Why is sql_text "select @@trancount" in open but sleeping transaction?

August 12, 20162 min read

Question Using SQL Server Management Studio, open a query window and execute BEGIN TRAN In another window execute select [text], from sys.sysprocesses cross apply sys.dm_exec_sql_text(sql_handle) where status = 'sleeping' and open_tran = 1 I see select …