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

Unable to install SQL Server Management Studio (SSMS) on server

We are experiencing persistent errors when attempting to install SSMS on one of our development database servers. We have tried the installers for versions 17.4 and 17.9.1, but the error messages are ...
1
vote
1answer
38 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 ...
2
votes
3answers
64 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% ...
0
votes
1answer
24 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
44 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....
19
votes
4answers
37k views

How to clone a user in SQL Server 2008 R2?

Is there a way to clone users' security and permissions in Microsoft SQL Server, preferably using the SQL Server Management Studio GUI?
1
vote
0answers
45 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
0answers
17 views

What are drawbacks of running CmdExec job step?

Is there any risk of running CmdExe job step in SQL Server? Which one is more secure, running powershell script via task manager (windows) or that of via SQL Server agent (CmdExec)?
23
votes
4answers
31k views

SQL Server Management studio slow connection or timeout when using Windows Authentication

I'm getting extremely long delays (10~30 seconds) in SQL Server Management Studio 2014 when attempting to connect to a SQL Server 2012 instance over TCP using Windows Authentication. This happens when ...
5
votes
2answers
3k views

Maintenance Plan Wizard generates invalid script?

I've used the Maintenance Plan Wizard to create a plan. When I execute the plan, the "Maintenance Cleaup Task" fails with this error message: Executing the query "EXECUTE master.dbo.xp_delete_file ...
0
votes
1answer
23 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 ...
-2
votes
2answers
62 views

get data from express edition db to developer edition [closed]

How to get database in new created SSMS sql server developer edition but I don't have back up of database but mdf file and ldf file are available.
3
votes
0answers
63 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
1answer
29 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 ...
0
votes
0answers
23 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
140 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
1answer
124 views

SQL BCP Utility Writing to SSMS Insead of .csv File

I have a stored procedure in SSMS call sp_testInventoryIssues as follows: USE [ADMIN] GO /****** Object: StoredProcedure [dbo].[sp_testInventoryIssues] Script Date: 06/19/2015 16:02:29 ******/ ...
0
votes
2answers
20 views

Is it possible to configure backup filename conventions for Maintenance Plan Wizard in SSMS

Is there a way to configure SSMS so that the backup file names for differential backups (created using the Maintenance Plan Wizard) would have the string "DIFF" in the name?
0
votes
1answer
28 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
2answers
35 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
0answers
24 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 ...
1
vote
0answers
17 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
0answers
16 views

Is there a way Azure data studio to find and add local databases under a list automatically?

When I create a database locally in SSMS it does not show up automatically in ADS. I have to add it as a connection each time. Generally I use SSMS but am trying to switch away (or just try for fun) ...
0
votes
2answers
211 views

Granting a SQL Server database only user execute on xp_instance_regread fails

So I'm not finding an answer to my specific issue. SQL Server 2012 database SSMS 17 admin tool Log on as a database (not domain) user foo. Receive sys.xp_instance_regread no permission errors. In ...
1
vote
1answer
32 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
1answer
101 views

Issue: Why Restore database wizard/GUI for SQL Server 2014 loading old backup set to restore

I am using SQL server 2014 to restore backups using the GUI, however, the back sets to restore are from old backups that are no longer available along with transaction logs that span months ago. How ...
0
votes
0answers
14 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
33 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 ...
38
votes
4answers
74k views

Formatting T-SQL in SSMS 2012

According to this Microsoft document: http://msdn.microsoft.com/en-us/library/ms174205.aspx I am supposed to be able to use ctrl+K then ctrl+D to format my SQL documents in SQL Server Management ...
0
votes
0answers
21 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 ...
13
votes
1answer
1k 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?
0
votes
2answers
112 views

Accessing Registered Servers over Excel

With DBs in different countries, different servers but same structure, I have created registered server to access them when running certain queries for reports on SSMS. Thus far this is ok. However, I ...
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 ...
0
votes
1answer
43 views

Connecting to database engine again when a new query or running view

When I connect to a server via SSMS, I can connect fine albeit a slow. When I click on a new query or try to run a view in a database on this server, the same prompt comes up but with everything ...
0
votes
1answer
22 views

“Cannot open user default database. Login failed” after altering MDF and LDF locations and bringing DB offline

I was attempting to move my database to a separate hard drive on the server, so I ran the following commands in the following order (I was following this question : How to change location of SQL ...
0
votes
2answers
452 views

SQL Management Studio 2016 account disabled

I have 2 instances, sqlexpress and mssqlserver. I made fool mistake, I disabled the login account that I used it all of the time to login in mssqlserver using windows authentication. And I don't ...
0
votes
1answer
40 views

SSMS 2014 does not launch Graphical Execution Plan from clicking hyper-linked query plan - ShowPlanXML

I am working with an older version of Microsoft SQL Server Management Studio 2014. I run the following query: SELECT TOP 10 Q.* FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_query_plan( qs....
0
votes
1answer
27 views

Azure SQL - Setting up permissions for users

I'm busy playing around within Azure SQL and have setup replication from my on-prem DB to the Azure DB for some reporting. I would like to ensure as part of this we setup the security correctly. In ...
0
votes
1answer
43 views

How to run update queries saved in a permanent table?

Permanent Table Name: PermaTable1 Values: Question is how to execute all update commands inside the table PermaTable1? This is my query but it does not execute the update command. DECLARE @Query1 ...
1
vote
2answers
3k views

“Untrusted Domain” error when connecting to SQL Server localhost and specifying port

I have two SQL Server 2016 instances running on localhost, and I can connect to both with no issues (localhost and localhost\test) using windows authentication. However, if I specify the port ...
104
votes
6answers
52k views

SQL Server Management Studio 18 won't open (only splash screen pops up)

I just installed SSMS 18 GA on a computer with only VS2019 installed, and when I try to open SSMS the splash screen will come up, but then the process exits. Running ssms with the -log parameter ...
4
votes
3answers
3k views

SSMS 2016 takes forever to bring up context menu for an index

Go to a random table in the Object Explorer Expand it down to indexes Right-click on an index - it takes around 10 seconds to come up If I attempt to create a DROP & CREATE INDEX script off the ...
1
vote
2answers
206 views

How to restrict SSMS to list the database of a particular user (Windows 2012 + Plesk)

We are using windows 2012 R2 server with Plesk and provide shared hosting for our customers. Version Details: MSSQL server 2012 and SSMS 11.0.2100.60 In SSMS if we login with particular user, it is ...
0
votes
2answers
314 views

MSSQL Instance Alias - how does it work

Ok I'm trying to understand how a MSSQL Alias works but documentation is lacking to say the best. Most blogs/videos/documents I can find state that all you need to do is go to SQL Server ...
1
vote
1answer
4k views

Two SQL Server databases setup with same .mdf and .ldf files

In a SQL Server 2008 R2 instance two databases (the second one being a restore/copy of the first one) have been setup against the same .mdf and .ldf files. How would I go about either deleting the ...
12
votes
4answers
9k views

Restore Database wizard won't open in SSMS 2014

On a dev machine running Windows Server 2012 R2, I just upgraded SQL Server from 2012 to 2014. Using SQL Server Management Studio 2014, when I right-click a database and go to Tasks -> Restore -&...
0
votes
0answers
15 views

How to remove the red squiggly line from IntelliSense for Queues

I know you can force SQL Server Management Studio to update the IntelliSense cache, but the red squiggly line for Service Broker Queues does not go away by updating the cache. It's not a big deal, but ...
0
votes
1answer
206 views

SQL SERVER Checking for Compatibility of the Database File Locations on the Server Instance that Hosts Secondary Replica

I am using SQL Server 2017 and SSMS 18.0 Version. During creation of availability group at validation step at primary Server (DBN1), i am facing that error i.e. the following required directories do ...
2
votes
2answers
3k views

SQL Server 2014 “syspolicy_purge_history” job keeps failing

I am using SQL Server 2014 and the job "syspolicy_purge_history" keeps failing at step 3 "Erase Phantom System Health Records" and its driving me crazy as I don't know what is causing the failure. ...
0
votes
1answer
346 views

I'm trying to enable SQL Filestream on Windows Server 2012 and SQL Server 2016 64 bit, Management Studio 2017

The machine config is Windows Server 2012, 64 Bit SQL Server 2016, and SQL Server Management Studio 2017. When I use SQL Server Configuration Manager to enable filestream, it gives me an error that I ...