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,274
questions
0
votes
1
answer
29
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.
- 1
0
votes
0
answers
40
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 ...
-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 ...
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 ...
- 103
0
votes
1
answer
79
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 ...
- 99
-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 ...
-5
votes
0
answers
51
views
.BAK file is not restoring [closed]
I am trying to restore a .bak file using SSMS. But SSMS is raising an error about insufficient memory in drive C. But my c drive have 132 gb of free space. I do not have drive D. What should I do?
&...
- 1
0
votes
1
answer
53
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 ...
0
votes
0
answers
38
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 (...
- 11
5
votes
1
answer
519
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 ...
- 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 ...
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/...
- 11
0
votes
3
answers
165
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 ...
- 11
0
votes
1
answer
53
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,'...
- 11
0
votes
1
answer
24
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 ...
- 1