All Questions
Tagged with sql-server-2017 ssms
34 questions
0
votes
0
answers
50
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
1
answer
195
views
Is there a way to customize SQL Server Performance Dashboard?
The report in SQL Server Management Studio presents System CPU Utilization broken out by a minute. Is there a way to specify the interval - perhaps by 10 seconds?
- 1,951
0
votes
0
answers
159
views
SSMS: Dragging vertical tab group divider and nothing happens
I've searched Google for "ssms vertical drag divider nothing happens" but can't find anything. Am I the only one experiencing this?
I'm using both SSMS 17 and 18, as some servers I work with ...
- 101
1
vote
3
answers
7k
views
Backup sqlserver 2019 and restore to Sqlserver 2017
I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server.
To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
0
votes
1
answer
116
views
Setting Up Multi-Server Administration---SQL Server Account
I am trying to set up Multi Server Administration so that I can easily update multiple instances of the same database across our network with ease. Where I am getting lost is how to set up the SQL ...
- 93
0
votes
0
answers
74
views
Failing to connect to Integration Service with SSMS on one VDI but on another it works fine
I have two VDIs with the exact same version of SSMS installed. On one, I can log into the standalone Integration Service of a remote server running SQL Server 2017, on the other I cannot.
Every ...
- 1
0
votes
1
answer
930
views
Storage accounts not showing up when creating Azure Storage Credential
I'm trying to setup a Back Up Database Task in a Maintenance Plan on SQL Server 2017 (Web Edition) using SSMS 18.6 and when I get to the step to create an Azure credential I select my management ...
- 103
0
votes
0
answers
32
views
How to troubleshoot slow connection issues from SSMS? [duplicate]
I right click on a server in the Registered Servers pane and select New Query. Sometimes (like 1 out of 3), it will just hang for 5-15 seconds with the Connect dialog (below). Other times, it ...
- 1,951
0
votes
1
answer
612
views
How to Capture Job Exit Code?
I'm essentially trying to find a better way to determine if my job has completed successfully before moving on to another call of the same job. I have multiple jobs which run through a parsing process ...
1
vote
2
answers
859
views
Copy database removed source - Cannot acces mdf file
I attempted to copy a database, using Microsoft SQL Server Management Studio (SSMS), but right-clicking and following the wizard. I wanted to target server to be the same as the source, so I added "...
12
votes
2
answers
2k
views
Prevent SSMS from seeing the server's file system
I have several users who share an MS SQL server 2017 under my administration. They should not see (or even be aware) of the other users and their data on that server. Each user has his own database. ...
- 335
2
votes
1
answer
3k
views
SQL Server Configuration Manager is not showing SQL Services
I have newly installed following things on my system
- Microsoft SQL Server Management Studio 2014
- SQL Server 2017
- Visual Studio 2015
When I tried to open SSMS for the first ...
- 21
2
votes
1
answer
97
views
SQL Server seems to be ignoring specified backup file extension
I have created a maintenance plan using the Wizard and this is the SQL produced, per SSMS:
BACKUP DATABASE [FOO] TO DISK = N'C:\SQLBAKS\FOO\FOO_backup_2019_08_09_161656_6414445.diff'
WITH ...
- 545
-2
votes
1
answer
350
views
Migrate data from Express Edition to Developer Edition [closed]
How can I migrate a database from SQL Server Express Edition to a newly created instance of SQL Server Developer Edition if I do not have a backup file?
I do have the .mdf (data file) and .ldf (log ...
- 105
2
votes
1
answer
482
views
Graphical Actual Execution Plan - Estimated vs Actual number of rows
I am using:
SQL Server Management Studio v18.1
SQL Server 2017 CU9
AdventureWorks restored from here
Test query:
USE [AdventureWorks];
GO
SELECT TOP (13) *
FROM Sales.SalesOrderHeader AS s
...
- 13.6k
0
votes
0
answers
144
views
SQL AlwaysOn Dashboard Not Showing Green Circles
I have a SQL server 2017 with SSMS 18.1 and SAO dashboard shows gray circles instead of the green check marks. It does not matter if it is secondary or primary it always shows grey circles. The server ...
- 247
2
votes
1
answer
806
views
Call Powershell command string from Sql Query Publish profile script
Is there a way to call powershell in SSMS Sql query window? I know Command prompt can be invoked with xp_cmdshell. Does similar method for powershell exist ? (Note, I know about powershell window , ...
user180724
0
votes
1
answer
255
views
Incorrect GrantedQueryMemory(KB) Value in SSMS Dashboard report
Just checking by to see if someone else has witnessed the same and tried a fix or has been fixed:
Issue:
I ran below query on stackoverflow2013 database
select
ParentId as [Post Link],
count(...
- 794
2
votes
2
answers
2k
views
SSMS 2017: Open SQL Files in existing SSMS app with raised admin permissions?
I realise this is an old chestnut, but does anyone have a definitive solution?
When SSMS (2017) is 'run as administrator', double clicking a SQL file in explorer will open another new instance of ...
- 175
2
votes
1
answer
947
views
Connecting to SQL Express Server 2017 with SQL Server Authentication Remotely
I have two systems that are on the same network. I am able to ping back and forth between these systems with their IP address and with their system names. I have enabled the TCP port 1433 inbound and ...
- 21
1
vote
1
answer
166
views
SSMS closes after installing visual studio
Good Morning.
I have a problem, first I made the installation of SQL Server Express, followed by SSMS and finally Visual Studio Community.
Before installing visual studio, SMMS worked perfectly, when ...
- 11
1
vote
1
answer
2k
views
Why do LocalTemp table showing with lengthy underscore under Temporary Tables of tempdb in SSMS 2017 Express Edition? [duplicate]
In my Microsoft SQL Server 2017 Express Edition, I have created a local temp table using below create statement,
create table #localtemptable
(tempid int,tempname varchar(20) )
After creating #table,...
1
vote
3
answers
21k
views
List all users on SQL Server for auditing
I'm using SQL Server Management Studio 17 and I'm trying to list all the users for auditing in an organized way with mentioning their database name.
I tried the query below but it's showing the ...
- 11
2
votes
2
answers
5k
views
Active Directory not working through SQL server Management studio
I have created a Group in SQL Server and add an Active Directory group to it with which contains users.
When I try to login through Windows authentication, it gives me the following error:
Login ...
- 299
0
votes
1
answer
228
views
Microsoft Key Storage Provider for Always Encrypted Master Key
Hoping someone can help-
I've been experimenting with Always Encrypted columns and have generated a certificate in the "Microsoft Software Key Storage Provider" -
How can I remove the "...
- 111
1
vote
4
answers
8k
views
Transfer data from Excel to table
How can I transfer information from an Excel file to a table in a SQL server database through SSMS?
Excel file Consists of five columns and a thousand rows.
I followed the steps as explained here,at ...
- 119
0
votes
1
answer
512
views
How to have folders in the SSMS 2017 project? [closed]
I am using SSMS 2017 and SQL server 2017, I have many companies and each company has many databases.
For example. I have five companies:
Company1, Company2, Company3, Company4, Company5
Every ...
- 119
1
vote
1
answer
115
views
SSMS 10.5 alongside 17.7
To set the scene, I maintain 4 local SQL Server 2008 R2 instances.
At some point in the near future, 3 of these will be upgraded to SQL Server 2017 and migrated to azure.
I am currently using SSMS ...
- 173
1
vote
1
answer
957
views
On Insert Trigger To Create Email
I am wanting to send an email through the SQL Server Agent once an insert has been made to a specific table. I tried the syntax below, but the email is not being sent, nor queued to send.
ALTER ...
- 960
10
votes
2
answers
2k
views
Select TOP N Rows missing from SSMS temporal table
I am using temporal tables within my database and when I right click on my table in Management Studio 2017 (v17.4 14.0.17213.0) I do not see the Select Top 1000 Rows in the context menu (there is no ...
- 103
9
votes
2
answers
3k
views
SMO, SSMS are slow for management of SQL Server in Docker when connecting to localhost
TL;DR: When connecting to my SQL Server Docker container via a name that resolves to the IPv6 loopback (::1), SMO calls are really slow. When using 127.0.0.1, they're fast.
I am trying to learn how ...
- 785
4
votes
1
answer
145
views
Does SSMS v17 allow user input in Python scripts?
With the introduction of Python feature shipped with SQL Server 2017, I would like to know if anyone has been able to use SSMS v17.x and run a python script that requires a user input. Here is a ...
- 530
8
votes
2
answers
4k
views
Sql server ssd slow performance
I'm out of ideas, so I'm asking for your help.
I have a weird problem which I cannot find a cause for no matter how much I search on the internet.
Thing is, I have two laptops:
l1 : HDD and a ...
- 121
1
vote
0
answers
12k
views
Microsoft SQL Server 2017 remove all instances
I installed Microsoft SQL Server 2017 for like 4-5 with some failures. I can't manage to have a clean re-install. I think there are some residual files or configurations.
I tired uninstall & ...
- 143