Skip to main content

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
-1 votes
1 answer
30 views

SQL Server Management Studio "Key cannot be null" error when giving a specific user permissions on Stored Procedures

I'm attempting to give a specific user execute permissions on a Stored Procedure. When I attempt to do so, I get an error: Key cannot be null. Parameter name: key (System)" When I attempt to ...
LYNITS's user avatar
  • 1
0 votes
0 answers
37 views

Use cases for APPLYs

Which is the most common use cases of CROSS APPLY and OUTER APPLY? I've read about these so much but every use cases and example queries looks like that can also be done by regular JOINs. I know that ...
Manohara N's user avatar
0 votes
1 answer
25 views

.DTSX package is there a way to wrap a workflow into a transaction

I have a dtsx package that imports data from a csv into a table, it truncates the table before it loads the data into the table. The problem is that sometimes for a reason or another the package fails,...
Axeltherabbit's user avatar
0 votes
1 answer
41 views

import extended properties of sql server database from xls file

I have a list of extended properties for all databases in an excel file. How can I import that into extended properties of each database in sql server.
Ramon's user avatar
  • 1
0 votes
0 answers
45 views

Unable to select "other data source" when creating linked server

I am unable to select the option for Other data source when creating a linked server in SSMS, because the option is completely grayed out. I have installed Microsoft OLE DB Driver (MSOLEDBSQL) for SQL ...
Travis Dean's user avatar
-1 votes
0 answers
36 views

SSMS doesn't list freshly installed instance of SQL Server, only previous deleted/uninstalled version

I uninstalled both SQL Server and SSMS on a Windows Server 2019 machine. I reinstalled SQL Server 2019 and created the default database MSSQL and installed SSMS 20. When I open SSMS, it only lists ...
Mr. Geologist's user avatar
0 votes
1 answer
30 views

Microsoft SQL Server Import Export Wizard on Remote SQL Server

Is it possible to run the SQL Server Import/Export Wizard purely on a remote server (e.g., from one database to another on the same remote server)? If I setup the source/destination connections in the ...
Phil C's user avatar
  • 103
0 votes
1 answer
80 views

Connection string for a successful SSMS connection

In SSMS v19 I can successfully connect/login to a SQL server that is listening on the default port 1433 Server : server.env.domain.com,1433 Authentication : SQL Auth And I can query any of the ...
BaltoStar's user avatar
-2 votes
1 answer
35 views

How to modify filepath of a database file that is inside a file group [duplicate]

How do you modify filepath of a database file that is inside a filegroup? Just the normal and direct way? Alter database [] Modify file (name='', newfilepath='') Or Alter database [] Modify filegroup ...
Michelle Urbano's user avatar
0 votes
1 answer
55 views

No logins showing under SQL Instance as admin and SA

I have an issue where when I log into SSMS I am not seeing any logins. I am running as an administrator and logging in with SA. It does not matter which account I log in with. I only ever see the two ...
Brandon Oisten's user avatar
0 votes
0 answers
39 views

SQL Server Authentication failing when running SSMS using runas \netonly

I use the runas \netonly command to launch SSMS as another Windows user that has elevated database permissions. This is so I can retain access to the local drives / directories that my normal user (...
AC123's user avatar
  • 11
5 votes
1 answer
522 views

Why does SQL-Server Management Studio change "Execute Query" into "Save Results"?

I'm a regular user of SQL-Server Management Studio but now I have a totally weird situation: when I press F5 or when I click on "Execute", SQL-Server Management Studio does not execute my ...
Dominique's user avatar
  • 581
0 votes
0 answers
35 views

Accessing this server via SQL Management Objects (SMO) or Distributed Management Objects (DMO) is currently not permitted

When I run this, EXEC SP_CONFIGURE 'show advanced options', 1 EXEC SP_CONFIGURE 'SMO and DMO XPs', 0 SQL Server management studio unable to connect with error, Accessing this server via SQL ...
Imran Qadir Baksh - Baloch's user avatar
0 votes
0 answers
87 views

How to set execution timeout in SSMS for SQL Server Programmatically

This is a follow up to my previous question How to set execution timeout in SSMS I want to set the execution timeout in SSMS Connection properties on the 'Connect to Server' page programmatically/...
RD Seeker's user avatar
0 votes
3 answers
174 views

How to set execution timeout in SSMS

I want to stop all the query that exceeds the given execution timeout value of an instance in SSMS. I tried to set the execution timeout in SSMS using multiple methods. Initially, I tried changing the ...
RD Seeker's user avatar
0 votes
1 answer
54 views

How to upsert in Sql using Merge statement with where clause

CREATE TABLE SourceProducts( ProductID INT, ProductName VARCHAR(50), Price DECIMAL(9,2) ) GO INSERT INTO SourceProducts(ProductID,ProductName, Price) VALUES(1,'...
amit agarwal's user avatar
0 votes
1 answer
26 views

SQL Server management Studio does not show Index recommendation

I have installed SQL Server management studio version 20 (and also tried with 19 and 18) and surprisingly unable to see the Missing Index Hints while explaining a SQL Query. Whenever i receive a SQL ...
Parth's user avatar
  • 1
0 votes
1 answer
89 views

SSMS Won't Show Databases in the Explorer Tree for a Specific SQL Server Account

When logging in as a specific SQL Server user, I was unable to view all the databases in the SSMS Explorer tree. Originally, I thought this was a SQL Server user account problem. I examined the Login ...
Yossi Geretz's user avatar
0 votes
1 answer
33 views

Get the statistics_stream on SQL server using SSMS

I have generated statistics for a few columns of a table using the following SQL command: CREATE STATISTICS [STAT_NAME] on [TABLE_NAME] (COLUMN_NAME) WITH FULLSCAN The generated statistics are ...
Mohammad Mosiur's user avatar
1 vote
1 answer
302 views

Error: unable to find network path in Microsoft SQL Server Management Studio

I am having problems with the connection in Microsoft SQL Server Management Studio. When I enter server name, login account name and pass, I keep getting the error in the attached image. the data I ...
giuliao's user avatar
  • 11
0 votes
1 answer
34 views

History of a manual database shrink event

I performed a manual database shrink in SQL Server Management Studio, and I need to check how long it took to complete (running duration). Is there a specific log, system tables/views that I can check ...
DS_Tn's user avatar
  • 3
0 votes
0 answers
21 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
62 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
98 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
82 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
71 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
155 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
-2 votes
2 answers
71 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
  • 581
1 vote
0 answers
52 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 ...
DB-Ay's user avatar
  • 11
-4 votes
2 answers
142 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
  • 535
0 votes
1 answer
124 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
307 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
  • 288
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 > ...
Doug Kimzey's user avatar
0 votes
1 answer
105 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
156 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
23 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
429 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
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 ...
jsp's user avatar
  • 1
0 votes
1 answer
55 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
28 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,849
0 votes
0 answers
97 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
194 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
463 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
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 ...
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
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 ...
Nick2410's user avatar
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 ...
user avatar
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 ...
Manngo's user avatar
  • 2,849
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 ...
James's user avatar
  • 149

1
2 3 4 5
26