7,636 questions
-1 votes
0 answers
49 views
Getting error while connecting SSIS service from remote server
When we are trying to connect the SSIS (Integration Services) from remote Server, we are getting below error. The SQL Server version is 2019. We are able to connect with SSMS 18 version from remotely ...
0 votes
1 answer
59 views
Azure Managed Instance Displaying Querying Transaction County each time a query is executed
Unless the query result displays in pretty much less than a second then I get this pop-up notification every single time I execute a query. Is there any way to disable this? I found under Tools -> ...
0 votes
0 answers
103 views
Remove Tabs Studio from SQL Server Management Studio 21
I want to remove this plugins, Tabs Studio from SQL Server Management Studio 21. I have uninstalled it but it is always there and always show some annoying dialog. Please tell me how to remove this ...
4 votes
2 answers
1k views
How to install a Visual Studio 2022 extension / plugin into SSMS 21
I have developed a Visual Studio 2022 extension / plugin (SQLinForm SQL Formatter / SQL Beautifier) that works perfectly inside VS 2022. Now I would like to use the same extension in SQL Server ...
1 vote
1 answer
131 views
"Invalid use of a side-effecting operator 'DELETE' within a function" for the constructed result?
I have code that removes the records in the table variable @small_tab from another table variable @large_tab: DELETE t1 FROM @large_tab AS t1 JOIN @small_tab AS t2 ON t1.[DBR Addition Cust Disc Group] ...
7 votes
3 answers
2k views
Open .sql files in SSMS 21 with double click
After upgrading to SSMS 21, whenever I double-click a .sql file, it opens in a new instance of SSMS instead of using the one that's already running. I've seen several posts about this issue on older ...
5 votes
1 answer
3k views
Upgraded SSMS from SSMS 20 to SSMS 21 - now the "Integration Services Catalogs" is not visible anymore
After upgrading from SQL Server Management Studio (SSMS) v20 to SSMS v21, the "Integration Services Catalogs" is no longer visible. Steps to reproduce Upgrade SSMS from version 20 to ...
0 votes
0 answers
127 views
Can't connect to Dockerized SQL Server 2022 from SSMS on Windows 11 — Error 18456 Login failed for user 'sa'
I'm running SQL Server 2022 inside a Docker container on Windows 11 (WSL2 backend), and I'm trying to connect to it using SQL Server Management Studio (SSMS) but keep getting: Login failed for user '...
1 vote
1 answer
488 views
How to connect to SQL instance on Container App in Azure, deployed from Aspire
I have a SQL Server instance running in an Azure Container App, created using .NET Aspire, and I'm trying to connect to it using SQL Server Management Studio (SSMS). Here are the details of my setup: ...
0 votes
0 answers
72 views
Trying to Paste into SSMS via 'edit top 200 rows' - think I have a driver issue?
I am taking a course that requires us to copy 600 entries into a table in ssms that we have created using 'edit top 200 rows.' When I attempt to copy into the columns (that line up perfectly) it is ...
1 vote
0 answers
55 views
How do I change the default "Save Results As" folder in SQL Server?
In SQL Server Management Studio 20.2, when I run a query, right click the results, and select "Save Results As...", the default save location is my Documents folder. I would like to change ...
0 votes
1 answer
45 views
In SSMS Alt+F is not working as other menu (Alt+) options
I am using SSMS 19.1.56.0. When I press ALT+F 'File' is selected, but the menu does not open as with other 'ALT+' combinations. I have checked for other shortcuts being assigned to that key ...
1 vote
1 answer
290 views
onPrem sql server connection using jdbc driver in databricks workspace
I am connecting a ssms instance present on my personal computer with databricks using jdbc. here is my code: database_host = "192.168.xxxxx.xxxxx" database_port = "1433" # update ...
1 vote
0 answers
84 views
Can I configure SSMS intellisense to prefer autocomplete to aliases?
I'm not sure whether I inadvertently changed the behaviour of Intellisense in SQL Server Management Studio, but it has started to behave in a way that, to me, is infuriatingly annoying. I'm using SSMS ...
0 votes
0 answers
25 views
Export From the SSMS as a Dynamic excel sheet?
I am have to extract data from SSMS regularly from the same tables. Is there a Dynamic way to do this? So that I do not have to keep creating new sheets each week?