Use this tag for questions specifically about SQL Server Management Studio 19, which added support for SQL Server 2022 and was released along side it.
Questions tagged [ssms-19]
6 questions
1
vote
0 answers
(Extension development) ObjectExplorerService is null in SSMS v19
I am making an extension for SQL Server Management Studio, and it is working fine for SSMS 18.x, but when I run the extension for SSMS 19 attempting to get the Object Explorer Service always returns null.
This is the code for the package:
…
Wonk
- 11
- 3
0
votes
0 answers
SSMS 19 prompts for login when already connected to MI
I'm connected to an Azure Managed Instance in SSMS 19 and am navigating stored procs. If I right-click a sproc and select modify, I'm prompted for my credentials. This ONLY happens in SSMS 19; SSMS 18 doesn't prompt me when I've already connected…
Andre
- 11
- 3
0
votes
0 answers
How to run query up to batch separator command in SSMS v19
I work with SQL Server and Oracle. For Oracle, use SQLDeveloper and to run the query, just place the cursor on the line where the execution is done up to where the "/" or ";" appears. And in SSMS v19, is there any add-in or native option?
I tried to…
eduardo
- 1
0
votes
2 answers
WHERE clause with '=' operator doesn't return exact match
I tried a SELECT with a WHERE clause searching for a wrong string but the result showed the right string, which further testing showed the WHERE clause with the = operator doesn't return the exact match.
I have tried to search for solutions but…
Lazy Student
- 3
- 2
0
votes
1 answer
Multi-level hierarchy data display in SQL Server Management Studio
I want to fetch a multi-level hierarchy in a sequential manner. I have a table BOMHierarchy in which I have this sample data:
Parent
Child
Parent1
Child1
Parent1
child2
Child1
Child3
Child1
Child4
Child3
Child5
Child3
Child6
I…
Kantarkatax
- 13
- 2
0
votes
0 answers
Can one run postgres SQL queries in SSMS 19 (Preview)
In Azure Data Studio one can download extension of multiple SQL clients and run SQL Queries, but wanted to check if in latest version of SSMS if we can do same things. Reason being one has to deal with multiple clients for running queries across…
P Kernel
- 217
- 4
- 13