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
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 ...
0
votes
0
answers
19
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 ...
0
votes
0
answers
69
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 ...
0
votes
0
answers
25
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 ...
0
votes
1
answer
42
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 ...
-1
votes
1
answer
69
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?
...
0
votes
1
answer
594
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.
...
0
votes
0
answers
1k
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 ...
0
votes
0
answers
323
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?
0
votes
1
answer
243
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 ...
0
votes
1
answer
368
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:
...
1
vote
1
answer
2k
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 ...
0
votes
0
answers
103
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 ...
1
vote
1
answer
3k
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?
0
votes
1
answer
285
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 ...