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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
7 views

Creating a server audit specification through SSMS: what is the correlation between Audit Action Type and other columns?

Having gone through https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-server-audit-specification?view=sql-server-ver15 where it explains how to ...
Betty Liv's user avatar
0 votes
1 answer
26 views

MSSQL Linked server login timeout

I have SQL running on several servers and I want to create DB links between the main server "A" and several other "child" servers (each one with their own SQL instance). I've ...
Daniel's user avatar
  • 11
1 vote
1 answer
81 views

SSMS 20 - Query Store - Configure tracked queries broken?

Tracking a query in the Query Store is stuck in SSMS 20 on Avg duration via the Configure option. It shows a red line around it, but it ignores the selected Metric and Statistic Any way to solve it? ...
Firat Aygur's user avatar
0 votes
0 answers
29 views

SSMS How to set alternate row colors in Grid Results - Same as Oracle SQL Developer

How can I set alternating row colors in SSMS? The ONLY answer close to what I'm looking for is here however is not for SSMS: Make Oracle SQL Developer act like PL/SQL Developer However, the answer is ...
Code Novice's user avatar
0 votes
1 answer
41 views

Why is Ignore Duplicate Keys not allowed on a Unique Key?

If I understand this answer correctly the difference between an Index with Is Unqiue on and a Unique Key is mainly cosmetic. In the MSSQL interface when I switch to a Unique Key the Ignore Duplicate ...
Dirk Boer's user avatar
  • 365
2 votes
1 answer
124 views

SSMS User Mapping Slow to Load, or Not Responding

I have been experiencing an issue in SSMS versions 14, 18, and 19, where loading the User Mapping of any given Login takes an age to load, sometimes up to an hour, or just never loads at all and hits ...
L.Moy's user avatar
  • 45
0 votes
0 answers
56 views

How to convert a function into a Stored Procedure in Microsoft SQL?

I have this function that takes a decimal parameter and returns a varchar CREATE FUNCTION dbo.NumberToWords(@Number DECIMAL(18, 2)) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @Words NVARCHAR(MAX) SELECT ...
Luis Avalos's user avatar
-2 votes
2 answers
59 views

Replace "INSERT" by "UPDATE"

I'm working with some tables in an SQL-Server database, and I'm doing some crucial modifications. In order not to loose everything when I mess up, I decided to do a "Generate script" (data ...
Dominique's user avatar
  • 521
1 vote
0 answers
42 views

Modified_extent_page_count shows 0 extents modified on a 1.7TB database, but running a differential takes takes 4-5 hours and generates a 50GB file

As per the title - modified_extent_page_count shows 0 extents modified on a 1.7TB database, but running a differential takes takes 4-5 hours and generates a 50GB file. I wondered if anyone has come ...
MattT's user avatar
  • 11
-4 votes
2 answers
128 views

How does SSMS grab the name of my server?

In the bottom-right hand side of SSMS's main screen and to the left of where it shows my user-name and the name of the database that I'm in, it gives the name of the server that I'm on. This string is ...
J. Mini's user avatar
  • 139
0 votes
1 answer
92 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 [...
Jeff.Clark's user avatar
0 votes
1 answer
117 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 ...
user avatar
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 ...
HardCode's user avatar
  • 276
1 vote
0 answers
61 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 > ...
Doug Kimzey's user avatar
0 votes
1 answer
60 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=...
Luis Avalos's user avatar
0 votes
0 answers
98 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 ...
Ahmad Imran's user avatar
0 votes
0 answers
20 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 ...
Jamie GF's user avatar
0 votes
1 answer
216 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 [...
Immortal's user avatar
  • 101
0 votes
1 answer
817 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 ...
jsp's user avatar
  • 1
0 votes
1 answer
51 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 ...
lit's user avatar
  • 231
0 votes
0 answers
21 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 ...
Manngo's user avatar
  • 2,819
0 votes
0 answers
79 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....
Marvin's user avatar
  • 1
0 votes
1 answer
128 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 ...
David Thielen's user avatar
0 votes
1 answer
118 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?
David Thielen's user avatar
0 votes
1 answer
39 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 ...
Joe's user avatar
  • 103
0 votes
0 answers
23 views

I need to create a SQL Server 2019 Express database from a SQL Server 2022 database [duplicate]

I have developed a database in SQL Server 2022 (and have SSMS), I need to recreate and include all data from that database on a different server which contains SQL Server 2019 Express. When in SSMS, I ...
mchapman13's user avatar
0 votes
0 answers
18 views

prerequisite functionality for which validation for Circular dependency needed

I am working on a training module where I need to add a prerequisite functionality for which everything is done except for the validation for Circular Dependency( for example training1 is required for ...
Nick2410's user avatar
0 votes
0 answers
49 views

Issue with SQL Server 2019 SSMS connection

I have a SQL Server 2019 Express installation. It was acting weird in that even though I had set it to mixed mode auth, I could not change the sa password (I know we shouldn't use this, but it's a ...
user avatar
0 votes
0 answers
22 views

Ho to stop SSMS from reverting font settings

(Is this the correct forum for this question?) I teach Microsoft SQL for a training organisation. For teaching purposes, we’re using SQL Server Express and SSMS. I don’t like some of the defaults in ...
Manngo's user avatar
  • 2,819
0 votes
1 answer
41 views

How to compose a SQL Server command for doing and un-doing compressions

The difference between simple and detailed WITH clauses: In YouTube tutorial SQL Server Tutorial 20: Table, Index and Row Compression, the example at time 5:43 contains a simple WITH clause of the ...
James's user avatar
  • 149
-1 votes
1 answer
64 views

For row-level or page-level, how to undo a compression in SQL Server? With SQL command and/or GUI Management Studio

We want to compress a table, using SQL statements like the samples below. And, just in case any issue happened after the compression, and we need to roll back to the last good point. How do we do it? ...
James's user avatar
  • 149
0 votes
1 answer
379 views

"Fatal scripting error" when parsing SQLCMD query

Similar issue seen here. I am trying to run the following command from SSMS running in SQLCMD mode. :r C:\dev\test scripts\sample.sql But I get the following error: A fatal scripting error occurred. ...
mft25's user avatar
  • 101
0 votes
0 answers
710 views

SSMS Find matching parenthesis Highlighting Feature aka Brace Matching Half Broken - How to Fix

SSMS version 19.1 This feature also takes on the name of Automatic Matching of Syntax Pairs. Refer to this link. This feature for me however is failing to function as expected. I used to be able to ...
Code Novice's user avatar
0 votes
0 answers
261 views

Display result rows vertically in MS Sql Server Management Studio (SSMS)

Using DBeaver, a GUI database client, i can press tab in the results window to switch to a vertical display mode focused on a single row. How do i do the same in SSMS?
dan carter's user avatar
0 votes
1 answer
194 views

command line client included in "SQL Server Management Studio 19"

With a web search I found that sqlcmd is included in SQL Server. Is there a command line client included in "SQL Server Management Studio 19"? I wish to run some SQL scripts in an automated ...
Sybil's user avatar
  • 2,498
0 votes
0 answers
290 views

Error in Login securables - SQL Server

I am using SQL Server 2017 and the latest SSMS version. When I click securables of login in SSMS, I see this error: Object reference not set to an instance of an object. (SqlMgmt) Program Location: ...
Farid Zahidov's user avatar
1 vote
1 answer
1k views

No connection possible after TrustServerCertificate=True => The certificate chain was issued by an authority that is not trusted

I have a machine which could connect to an MS SQL Server in the past. I have SSMS installed and the connection was possible when I activated TrustServerCertificate checkbox in SSMS. I could connect ...
Sebastian Siemens's user avatar
0 votes
0 answers
85 views

User unable to login into SSMS or their excel spreadsheets that are connected to a DB

This is a strange issue. I have a user (let's call them A), that needs to 'refresh data' on an Excel spreadsheet. The user is able to log into Excel using their domain credentials. They can input and ...
zanzibar's user avatar
1 vote
1 answer
2k views

How to connect from MS SSMS to PostgreSQL database?

Can someone tell me what the provider string looks like when trying to connect from MS SSMS to PostgreSQL database via linked server?
Hrvoje T's user avatar
  • 163
0 votes
1 answer
237 views

How to optimize the SQL query which uses cte, group by and run for 23 hours?

I have a query which first performs joins inside cte and then based on cte join with other table and perform group by with some aggregations and get the top 15 records. This query is taking 23 hours ...
Python coder's user avatar
-1 votes
2 answers
175 views

Data retrieving is taking more than 4hrs to fetch 400K records

I have a table with 15 million rows, it's a parent table with 12 child tables. Even for a simple count query, it is taking hour's to complete. select count(1) from table where col_filter >= 'number'...
Python coder's user avatar
0 votes
1 answer
26 views

SQL Server database migration to Azure SQL Database

We are currently in the process of setting this up, but my boss has asked whether a restore of any of the 13 databases will affect the local publications/ Subscriptions which have been set on the ...
delmc18's user avatar
  • 11
1 vote
1 answer
5k views

Unable connect to SQL Server on SSMS and Got error 10054

I have an issue with connecting to a server on SSMS SQL Server. I got this error 10054 when i tried to connect : SQL Server error 10054 =================================== Cannot connect to <IP>...
Davin's user avatar
  • 11
0 votes
2 answers
29 views

Error Selecting XLSX Files Attached to a Solution in SSMS

I want to link Excel files to a solution in SSMS to have the handy for reference. Adding them works just fine. They show up under Miscellaneous. SSMS recognizes that they are Excel files by putting ...
StoneGiant's user avatar
2 votes
3 answers
132 views

Find "naked" varchars

It is clear that omitting the length from a varchar is a bad thing. Unfortunately I am now working with a code base where this has happened. Extensively. I would like to correct this. The first step ...
Michael Green's user avatar
0 votes
2 answers
315 views

SQL Server Profiler trace only contains my user's activity - Want to trace other users

I have what is probably a basic question, but I'm not getting anywhere searching/trying it on my own. What I'm trying to accomplish: run a trace against a SQL DB used by Dynamics NAV and get a ...
Hungry Giraffe's user avatar
0 votes
2 answers
214 views

How to refresh messages pane in SSMS

I need to refresh Messages pane in SSMS more often, is there a way to achieve that without GO statements? My query is: DECLARE @Deleted_Rows INT @Deleted_Rows = 1; DECLARE @Deleted_Rows_Total bigINT ...
Vojtěch Dohnal's user avatar
0 votes
1 answer
68 views

Keeping track of client logged-in OS user when connecting to a database server

We are implementing a monitoring solution that keeps track of logins to SQL Server. We need to capture the following event: a user logs in to a Windows client and from there logins to a remote SQL ...
Andrea's user avatar
  • 210
-1 votes
1 answer
465 views

What does the question mark on availability group replica mean in SQL Server Management Studio?

I'm doing some testing with availability group in SQL Server. When I'm on the primary replica, I can see all replica nodes have a refresh icon on them. But when I check on a secondary replica, all ...
Fajela Tajkiya's user avatar
0 votes
0 answers
54 views

My SSMS does't see the directory with db files

I did nothing and my SSMS does not see db directories with files. When I'm trying attach db ssmms can't find this way. But when I create db the files put there As I understood there is the problem ...
Andrei Yankavets's user avatar

1
2 3 4 5
26