Questions tagged [ssms]
SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.
1,276
questions
0
votes
1
answer
129
views
Unique Index on NULLable field isn't creating a Unique Constraint so I can make it a FK on another table?
I'm in MS SQL 2016. I'm a bit confused. I have a field that I have put a unique index on. The DocID is not a primary key, but it will be unique (and is NULLable):
CREATE UNIQUE INDEX [...
0
votes
1
answer
323
views
How can I access table with Always Encrypted in SQL Server Authentication?
Working on Azure SQL Server
I approached Key Vault with Azure AD and generated a column master key and column encryption key to apply Always Encrypted to a specific table
Therefore, if login the ...
6
votes
2
answers
2k
views
When is the Query "Done"?
Scenario
I run a long, complex query that returns 30+ fields and 77,000+ rows in SSMS. The results are to grid. The results are all text-heavy. The SSMS grid starts populating with results after a few ...
1
vote
0
answers
62
views
Is there a file that can be deleted to force SSMS to manually rebuild Intellisense?
I have a case where intellisense has stopped working completely.
I have tried Ctrl-Shift-R and waited a few minutes. This has no effect.
I changed the Maximum script size in 'Tools | Options > ...
0
votes
1
answer
109
views
How to use sp_execute_external_script to fetch USD Rate from an API and update a table?
I have this code that gives this error
-- Set the API URL
SET @url = 'https://www.banxico.org.mx/SieAPIRest/service/v1/series/SF43718/dato/oportuno?token=...
0
votes
0
answers
162
views
SQL Server Network Configuration Tab is missing. Can't enable TP/IP Protocols
I am using SQL Server 2022 and the "SQL Server configuration manager" is not visible.
Further more I opened "Services and Applications" and in computer management and SQL Server is ...
0
votes
0
answers
24
views
SSMS. Anyway to connect via AWS session-manager to an mssql instance?
I have a sqlserver (express) instance running on an ubuntu server ec2 instance. This is on an AWS private subnet so I cannot just open port 1433 for sql access. We use AWS session manager to connect ...
0
votes
1
answer
448
views
Cannot drop the database encryption key because it is currently in use
I want to create a backup of my sql managed instance database to blob storage. However am encountering the below error after trying to turn off encryption key as follows:
use master
ALTER DATABASE [...
0
votes
1
answer
1k
views
Cannot Connect (Internal connection fatal error. Error state: 15, Token : 23 (Microsoft.Data.SqlClient)
I had SQL Server 2019 Developer Edition installed and working correctly. Could access via SSMS without issue. About a month ago, I lost connection. Tried checking everything I could find online, no ...
0
votes
1
answer
56
views
Is there a keyboard shortcut to open a registered server?
Getting to the Registered Servers pane is easy enough with Ctrl-Alt-G.
Navigating thorugh the tree is easy enough with arrow keys.
Once the desired instance is found, is there a keyboard action that ...
0
votes
0
answers
29
views
SSMS Syntax Error Highlight
In SSMS, a syntax error is highlighted with a red squiggly line. So is the Invalid Object Name error. In my mind, they’re two different things — the second can sometimes be rectified with Refresh ...
0
votes
0
answers
101
views
Stored Procedure Error: an exception occurred while executing a transact-sql statement or batch , invalid object name 'sys.all_objects'
Am trying to expand the Store Procedure in SQL Server 2012 x64 but there is a error prompts. Any Help? Thank you.
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request....
0
votes
1
answer
200
views
How can I copy a database schema from my local Sql Server to Azure SQL Database
I figured the way to do this was to go to my existing database (Sql Server 16.0.1105.1 developer edition) in SSMS and run Tasks | Generate Scripts...
This includes a FullTextTable. So I then got the ...
0
votes
1
answer
504
views
How do I change the password for a login on Azure SQL Database via SSMS
I'm in SSMS connected to my SQL Database on Azure
I right clicked on the login - no properties choice in the menu
How can I change the password for a login?
0
votes
1
answer
47
views
Problem connecting two instances of the same RDB table via an intermediary table
I have also asked this question on Stack Overflow (apologies if this is a breach of protocol).
I am migrating an MS Access database to MS SQL Server where I will maintain it using SQL Server ...