We’re rewarding the question askers & reputations are being recalculated! Read more.

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
-3
votes
0answers
28 views

RegisteredServers via C# code are not visible in SSMS [on hold]

Based on SO Post, I added multiple servers to Local Server Groups but I can not see them. I just see the server which I added via SSMS but I cannot see registered servers from C#: As you can see I ...
2
votes
0answers
25 views

Imported SSIS package fails if imported with SSMS on the SQL server, but works when imported from a remote PC

I am facing a strange issue on SQL Server 2017 Enterprise edition running in AWS on EC2. When we are on the SQL server and we import an SSIS package using the locally installed SSMS connected to ...
1
vote
1answer
23 views

Login failed for user when trying to connect to Azure Postgre database from MSSMS [on hold]

I created a database on Azure but can't log to it with MSSMS. I always have the Error 18456 even if I followed this tutorial. TITLE: Connect to Server ------------------------------ Cannot connect ...
1
vote
1answer
23 views

Cannot take backup into NAS storage at specific time

I have a job which runs every 30 minute and takes t-log backup of the database suing Ola's script. Every Thursday and Friday at 22:45 I get an error: 11/07/2019 22:45:00,Backup,Unknown,Error: 3041<...
0
votes
1answer
20 views

SSMS.exe Access Denied

have a new Win10 pc and need run MSSQL Management Studio as a different user. However when I do so I get error: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe ...
-1
votes
1answer
30 views

data compression does not show when scripting index on ssms

when I right click on SSMS and choose to script the create index: I get this script, without the data_compression: USE [APCore] GO /****** Object: Index [i_agencyId] Script Date: 07/11/2019 12:...
1
vote
0answers
34 views

How many connections does Object Explorer use in SSMS?

I recently enabled DAC and noticed this error when first trying to connect with object explorer in SSMS: Cannot connect to admin:servername Dedicated administrator connections are not ...
1
vote
1answer
35 views

SQL Server Extended Events purging

How do we purge events older than a day in Extended Events in SQL Server 2012. Stopping and Starting the session is not helping. Target : asynchronous_file_target Trying to create a job which will ...
1
vote
0answers
26 views

SSMS Connect to remote SQL instance with Windows Authentication

I have a remote SQL instance (Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
3
votes
1answer
48 views

Inconsistency between object explorer and available database dropdown

I am working with SQL Server 2008R2. I am able to see a database in the "available database" drop down, but not in the object explorer. I am able to query it, for example select * from ...
3
votes
2answers
34 views

SSMS cannot connect remote server by IP through Windows authentication

I'm trying to connect a remote server by IP,port via Windows authentication. It will end out with the following error Connection Timeout Expired. The timeout period elapsed while attempting to ...
3
votes
0answers
45 views

Extremely long import times from Excel File to SQL Server Management Studio using Import Wizard

I have been importing an excel file with approximately 250,000 rows of data and 40 columns to SSMS on a weekly basis through the Import Wizard. Unfortunately, the import times take around 45 minutes, ...
0
votes
1answer
31 views

I'm not understanding the concept of login/user on Azure [closed]

So as a SQL Server DBA, I can normally create a user, then inside the database U just create a login pointing to that login and then I give the necessary privileges. I'm trying to understand the ...
1
vote
0answers
27 views

Is the table designer not supported for memory optimized tables?

If I right click a table, I get the normal designer option: But if I right click a memory optimized table, the designer is missing: The server is 2016 and I've tried it in SSMS 16, 17, and 18.3. Is ...
0
votes
0answers
11 views

Is there a vsix installer for SSMS 2014?

Is there any way to install extension from vsix into SSMS 2014 without breaking the pkgdef from both sides? Because everytime I copy paste one of the extension directory from Visual Studio 2010 to ...
1
vote
0answers
26 views

How to force SQL Studio not to use copy-only backups to build database restore script?

How to force SQL Studio not to use copy-only backups to build database restore script? I want to ommit copy-only backup (because it's not longer available) and force studio to use last full backup (I ...
0
votes
0answers
45 views

Unable to access SQL Server from SSMS 2014

I'm unable to access the server after I installed Visual Studio Isolated Shell. No matter how I try to access the server, the result will always be the same (image below). How can I access it back ...
0
votes
0answers
21 views

How do I manage SQL Server Management Studio (SSMS) Add-In?

A variety of vendors provide SQL Server Management Studio (SSMS) Add-Ins, such as Red Gate's SQL Prompt and the SSMS Tools Pack. Is there a way in SSMS to control or configure these add-ins (enable/...
0
votes
0answers
79 views

Should I move ORDER BY to app?

I noticed this discussion on NOT using ORDER BY in SQL query unless really necessary. https://www.brentozar.com/archive/2019/10/how-to-think-like-the-sql-server-engine-adding-an-order-by/amp/ The ...
0
votes
0answers
22 views

Setting an Authorization [duplicate]

How can I set a user's authorization to see only the database that the user got access to, when accessing database via MS Management Studio? Is that even possible?
0
votes
1answer
45 views

SQL Server can't see already mapped network drives

I'm trying to backup databases through SSMS and cannot see any already-mapped network drives. The SQL Server service account is what I'm using to log in, and it has permissions to the network share, ...
0
votes
0answers
38 views

launch database mirroring monitor grayed out in SQL server 2014

I have 2 servers configured with mirroring each other. Both the servers are principal & Mirror servers each other. From the 2nd Server launch database mirroring monitor is working fine but from ...
0
votes
0answers
22 views

Internet-facing loadbalancer for encrypted connections to DB

I am trying to get my head around a problem; Background: Host1 is running SQL-Server 2017 on an EC2 in a private subnet in AWS. Problem: In order to have it accessible for an external service we put ...
-1
votes
2answers
45 views

In SSMS I can hover over a column name and it gives me the Type. Is there also a simple way to get its source table/query?

In SSMS when I am in a script, I can hover over a column name and it will give me the column's type and if it is Null/Non Null. Is there a similar simple way to get which table/query in the From ...
0
votes
1answer
35 views

Activity Monitor Blocked by Firewall. Set Static Port?

We are seeing an issue with not being able to open Activity monitor for remote SQL servers. The Activity Monitor is unable to execute queries against server . Activity Monitor for this instance will ...
0
votes
0answers
22 views

How to change the whole theme of SQL Server 2014 Management Studio to black theme? [duplicate]

This is different with the text editor theme. What I want is a theme that is implemented through the whole windows. I found it strange that the theme I wanted to use through an extension called ...
0
votes
0answers
20 views

How to connect to a database in SQL Sever Management Studio (SSMS) using Microsoft OLE DB Provider for SQL Server

After asking this question, I realized that the true slowness comes from SQL Server Engine, and I used tons of things and still no success. However, I created a connection.udl file on desktop and ...
0
votes
2answers
29 views

Connecting to local database on Azure VM

Using DBforge to try and connect to a local MSSQL database on an Azure Ubuntu 18 VM, I am getting this error: A network-related or instance-specific error occurred while establishing a connection to ...
0
votes
0answers
89 views

SQL Server Management Studio (SSMS) is way too slow in its GUI

I know this question has been asked before here and here. But none of them could sovle my problem. I have this environment: Windows 10, build 1903 (freshly installed) Microsoft SQL Server 2016 (SP2) (...
0
votes
0answers
18 views

SSMS cannot determine if remote computer is connected to domain

I've recently set up a new server with an SQL instance running on it (2017), I am able to connect to the server remotely using SSMS, but when I try to add a new login, I receive the attached error. ...
1
vote
1answer
87 views

Cannot choose Storage option on a table in SSMS for standard edition

I am looking into partitioning of tables for SQL Server on two different machines. One machine runs Microsoft SQL Server (RTM) 2016 Developer Edition, and the other is running Microsoft SQL Server ...
0
votes
1answer
159 views

User guest does not have permission to run DBCC checkprimaryfile (SMSS)

I am trying to attach an mdf file to a sql server using SMSS, and I got a message that says: User guest does not have permission to run DBCC checkprimaryfile Any clues about how can I solve that ...
1
vote
1answer
48 views

attaching locally stored mdf to SSMS

Sorry if this question does not make sense, I have no experience with databases, I just stumbled upon this task. I need to attach an mdf to a database. I have the mdf file stored in my local computer....
2
votes
3answers
83 views

What is SQL Server doing in the background once a Backup/Restore is complete?

When I run a backup or restore through the SSMS GUI, the dialog shows Executing with 20% increments rather than every 1% tick. To get round this, we can use DMV's. Thing is, when the query shows 100% ...
1
vote
0answers
54 views

SQL Server “Locate backup file” change to include diff

In SSMS, when using the GUI to select backup files to restore, the .diff are excluded (First image) and you need to change to show all files (second image). .diff is the file extension I am using for ...
0
votes
1answer
32 views

How to grant xp_delete_file to non-sysadmin login?

I want to delete old backups from shared folder, which are located on separate NAS storage, using newly created SQL login. Is there any workaround to execute xp_delete_file using another account which ...
0
votes
1answer
30 views

Replacing the removed database diagrams feature [closed]

I have a SQL Server database and want to create an ER diagram for it, to analyze tables and relationships. The option to create a diagram is no longer present in SSMS 18. Is there any free tool ...
3
votes
0answers
174 views

No backupset selected to restore

I have 2 cloud SQL Servers, one in Azure, one in AWS (I don't think the cloud platforms matter here but including them just to be thorough). I'm unable to restore a database from the Azure server to ...
0
votes
0answers
27 views

Encryption procedure other than Always Encrypted

I would like to ask if there are other encryption method in MS SQL other than always encrypted?
9
votes
2answers
184 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. ...
0
votes
2answers
37 views

How can I update the roles for all logins using T-SQL?

I need to update the roles for all database logins, but without using SQL Server Management Studio. I can update a single user with the following example SQL. EXECUTE sys.sp_addsrvrolemember @...
0
votes
1answer
30 views

Does Data Migration Advisor migrate system databases?

I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.
0
votes
0answers
27 views

Data Loss issue while migrating data from Source(Oracle) to Data Warehouse Staging Database(SQL Server)

Project Overview Loading data from Oracle Database to Datawarehouse Staging Database(SQL Server). Using ETL process we are loading data from Oracle to SQL Server. Staging Database in SQL server is an ...
3
votes
1answer
37 views

How to Parse a query in Azure Data Studio?

In Sql Server Management Studio, we can click a "Parse" button (or Ctrl+F5) to verify that a SQL statement is syntactically correct (without executing it). How can I do it the same in Azure Data ...
1
vote
1answer
35 views

When are statistics created?

I know that when we create an index then statistics are automatically created. My question is: Is it the only case when statistics are created? I remember that once I found on the internet that we ...
0
votes
0answers
24 views

Using CONVERT on Always Encrypted varbinary column

I have an encrypted varbinary column that contains data that I wish to convert to varchar using the CONVERT() function. I am using Always Encrypted = ON and Column Encryption Setting = Enabled for my ...
2
votes
1answer
42 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 ...
0
votes
0answers
28 views

Import folder with Multiple CSV's into SSMS w/ out SSIS

I am wondering what's the best and most effective way to import csv's stored in a local folder into DB w/ in SSMS. Folder path- C:\Users\ngutierrez\Desktop\Open_Air_Tables Folder contains about 30 ...
19
votes
2answers
2k views

How to disable “Completion time:…” in SQL Server Messages window

Every query I run in SSMS append the annoying message: "Completion time:...". How can I disable that text?
2
votes
1answer
27 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 ...