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.

200 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
10 votes
1 answer
831 views

SSMS 2014 (and 2012) CTRL+TAB requires pressing enter

Sometime last week my CTRL+TAB behavior changed. I used to hit CTRL+TAB, release, then I would be in my previous document tab. Now I hit CTRL+TAB, release, and the nav window is still open requiring ...
Jay Otterbein's user avatar
5 votes
0 answers
2k views

Where is the reference to explain the SSMS Object Explorer icons?

(This is not the same as the two questions asking about a blue circle with white question mark). The Object Explorer in SQL Server Management Studio can show many different kinds of icons. Where on ...
youcantryreachingme's user avatar
4 votes
1 answer
142 views

T-SQL: Iteration vs. Set-Based Operations When Independence of Ancillary Data is Needed

BACKGROUND I am using Microsoft SQL Server Management Studio v18.9.1 on Windows 10. I've created a database to store test results of our company's widget (not yet being produced). I am working on a ...
Dave's user avatar
  • 197
4 votes
0 answers
1k views

Is there any way to set the default data source for the SQL Server Import and Export Wizard?

When I launch the SQL Server Import and Export Wizard for SQL Server 2014, the selection in the Data source drop-down defaults to .Net Framework Data Provider for ODBC. This happens regardless of ...
Bob C's user avatar
  • 179
3 votes
0 answers
1k 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, ...
user194041's user avatar
3 votes
0 answers
3k 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 ...
MadSkeletor's user avatar
3 votes
0 answers
2k views

How do I grant permissions for a SQL Server Management Studio user to access system.views in an Azure Managed Instance?

I am connecting to an Azure SQL managed instance with Active Directory through SQL Server Management Studio. I'm trying to access system views, like: SELECT * FROM sys.dm_db_missing_index_details ...
Tim Westover's user avatar
3 votes
0 answers
360 views

Disable or Remove Edit top 200 Rows option from SSMS

I have already done some R&D on the same but don't have the real solution. Is there a way to obsolete the right click option "Edit Top 200 Rows" from SSMS? The goal is to prevent developers from ...
iamraviraj's user avatar
3 votes
0 answers
531 views

SQL Agent parsing actually executes instead of just validating

I'm seeing some really odd behavior with SSMS 2014/2016 that I stumbled accross by pure accident. This was run on SQL2014 SP1+CU6 (the fixed one) in a non-prod environment. Here's the backstory. I ...
Kris Gruttemeyer's user avatar
3 votes
0 answers
690 views

SQL Server Management Studio creates 18456 login error using registered server group

I have been using "Local Server Groups" registration for quite a while now with SQL Server 2008 Management Studio. I have created a group with 5 registered servers. They are registered using ...
Magier's user avatar
  • 4,787
3 votes
0 answers
3k views

SSMS Client Error: Internal connection fatal error

I am running SSMS 11.0.5646.0 on a Windows 7.0 Pro desktop connected by UTP directly to same network switch as my development server (Windows 2008R2 Standard, SQL 2008R2 SE with SP3). All within the ...
Ray's user avatar
  • 31
3 votes
0 answers
464 views

SQL Job Step created via wizard does not correctly set server & database_name values

I've recently been tasked with migrating a database from SQL Server 2005 to 2008R2. This has all been accomplished without any issues, but one part of the system requires a Snapshot Replication to be ...
Sam Banks's user avatar
3 votes
0 answers
426 views

Using Import Wizard with Access - No null values

I am trying to import a table from Access to SSMS using the Import Wizard but when I do the resulting table has a lot of empty strings instead of the NULL values that I am expecting. How do I make ...
MuppetBrown's user avatar
3 votes
1 answer
1k views

Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012

I have two local SQL Server instances running on my local machine. The first is SQL Server 2008 R2 Enterprise Edition (named MSSQLSERVER) and the 2nd is SQL Server 2012 Business Intelligence Edition. ...
Ibrahim Mezouar's user avatar
2 votes
1 answer
700 views

Installing SSIS package outside of SSIDB catalog

I'm trying to simplify deployment of a SSIS package to a remote server. At the moment, I have Local Visual Studio SSDT and SSIS package that has 4 connection managers - DEV environment Remote server ...
Anonymous's user avatar
  • 143
2 votes
1 answer
3k views

SSMS Not showing Status and Scheduled Jobs Not Running

Recently in SSMS, I have started getting a blue question mark next to the database and SQL Server Agent, when previously all was showing running. At the same time my scheduled jobs have stopped ...
C. K. Miller's user avatar
2 votes
2 answers
3k views

Why Sql Server management studio use English regional settings instead my local Windows settings?

Scenario: I have a Sql Server instance on English Windows Server. But I also have my own ITALIAN client with Sql Server Management Studio and SSMS regional settings set to Italian. So when I extract ...
stighy's user avatar
  • 131
2 votes
0 answers
186 views

Cannot connect to server with SSMS 18

I'm having an issue all of a sudden with SSMS 18. Today, the authentication method is grayed out and I cannot get it to connect to a server. I've rebooted, reinstalled 18.6, uninstalled and ...
jradich1234's user avatar
2 votes
0 answers
904 views

Data-tier .bacpac import keeps failing

Within a container, I have SqlServer running in a docker container. It was created like so: docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=$1" -p 1433:1433 --name sql1 -v sql1-sqlvolume:/var/opt/...
Eric's user avatar
  • 121
2 votes
0 answers
1k views

connection to remote Analysis Services from SSMS

On my company local SQL Server instance I was able to add a linked server to a remote AS instance (in Management Studio > Server Objects). I was also able to connect using Data Tools, as well with ...
matt's user avatar
  • 21
2 votes
0 answers
1k views

C# Windows Service task fails due to a SP timeout, but works fine after executing the SP in SSMS

I have a Windows Service app running and sometimes a task which has a method call to a stored procedure (with a Select operation) is keep failing due to a timeout. But when I execute that SP with ...
Aki T's user avatar
  • 213
2 votes
0 answers
452 views

In SSMS "SQL Server Agent" sub folders are appearing twice

I have SSMS 17 installed on my system, after I connected to database instance, I found sub folders of SQL Server Agent are repeating. Thanks!
Rajesh Ranjan's user avatar
2 votes
0 answers
24 views

How to reconnect to network file

How do I reconnect the open files in SSMS to their network locations for change tracking? After disconnecting my laptop from my network at work and then reconnecting through a VPN the sql script ...
TheDean's user avatar
  • 21
2 votes
0 answers
2k views

Attempt at SSIS Execution Throws Invalid object name 'SSISDB.catalog.customized_logging_levels'

I can run the SSIS package in SSMS 2014 if I set the build to SQL Server 2012, but attempting to run in SSMS 2017 v17.4 upgraded from 17.3x (didn't work there either) SQL Server version 13.0.4451.0 ...
Ray Koren's user avatar
  • 121
2 votes
1 answer
225 views

How to order databases by size? (For use in full backups)

Recently, I've been trying to make our company's full backup process more efficient. In order to do this, my team has decided that instructing the backup job to tackle the full backups starting with ...
hemuxin's user avatar
  • 21
2 votes
0 answers
72 views

SQL Server Extended Events Sessions on VIEWs

I'm trying to monitor when Views are being called in SQL Server. Using Extended Events, I've created a Session and included event "sql_statement_completed". Then I've added 1x filters on this: ...
glass_kites's user avatar
2 votes
0 answers
582 views

How to Clean Sensitive Data from SQL Server Dump Files

How do I clean a SQL Server dump file of confidential/PII/PHI information so I can prepare it for third party analysis? What am I looking for in the dump files and are there any automated tools to ...
DBADon's user avatar
  • 325
2 votes
0 answers
566 views

Slow SSMS connecting to AWS EC2 instance

I have an AlwaysOn availability group in AWS EC2. 2 nodes, multisubnet, with 1 DC in one subnet, the other DC in a separate (3rd) subnet. All in the same VPC. When anyone connects to either of the ...
Peter's user avatar
  • 1,490
2 votes
0 answers
596 views

Export SQL View to CSV flat file. SSIS job stuck

I created a database view with the desired data and format. I used SQL Server Import and Export wizard to create a flat file export procedure and saved it to SSIS package. The data exports correctly ...
Sarge's user avatar
  • 153
2 votes
1 answer
278 views

My SSMS is bringing wrong object in "Script Stored Procedure as" > "CREATE To" > "New Query Editor Window"

When I go to Object Explorer and expand down to Stored Procedures (or Tables), right-click on one of them and choose "Script Stored Procedure / Table as" > "CREATE To" > "New Query Editor Window", it ...
Alexandre's user avatar
  • 165
2 votes
0 answers
830 views

Unable to use select top N shortcut on Azure SQL Database via SSMS

Yesterday morning I was able to query my Azure databases via SSMS and the Select Top N menu shortcut. That afternoon I received a couple of alerts that my web applications couldn't connect to the ...
Erik's user avatar
  • 4,771
2 votes
0 answers
528 views

Change default value for Job Activity Monitor

Is there a way for me to programmatically (some configuration setting in a table / registry entry etc, I'm hoping) change the default value in the Auto Refresh setting to 5 seconds instead of 60, and ...
Raj More's user avatar
  • 325
2 votes
0 answers
114 views

SQL Server - Debugging - How to show parametervalues as HEX

I am writing a script which sets Parameters in the Registry for SQL Server. The following works on some of my servers but not all. DECLARE @Parameters AS VARCHAR(MAX) SET @Parameters = '-T1118' ...
Bengelnatz's user avatar
2 votes
0 answers
7k views

Change Root Directory on server properties page in SQL Server 2014 SSMS

We did in inplace upgrade from SQL 2012 to SQL 2014 (I know it wasn't the best choice, and it won't happen again, so no need to beat that horse). I have both the MSSQL11.MSSQLSERVER and MSSQL12....
Demian McLellan's user avatar
2 votes
0 answers
4k views

SQL Server does not exist or access denied" after installing SSMS

I recently installed SQL Server Management Studio (which also installed SQL Server 2016 to my local machine), and now am unable to connect to SQL Server from applications on my machine. It will come ...
Jordan Johnson's user avatar
2 votes
0 answers
887 views

Using :Connect I keep getting msg 911 - database [dbname] does not exist

I have a two part T-SQL script, the first part runs against a database on a different server, the second part is supposed to run on the local PC. I'm using SQLCMD mode and the :Connect keyword but ...
Michael Fields's user avatar
2 votes
0 answers
1k views

SQL Server Management Studio with Multi subnet HADR cluster

We are starting to deploy Multi-Subnet HADR AlwaysOn clusters for our environment. Using MultiSubnetFailover=True in application connection strings works. However, SSMS connections require manual ...
Jeremy Dearduff's user avatar
2 votes
0 answers
2k views

Full-Text Index menu option not appearing in SQL Server Management Studio AND error when right clicking a table

I am using SQL Server Management Studio Version 11.0.3128.0 and SQL Server 2014 12.0.2361 Web Edition. I have successfully created a Full Text Catalog following these instructions: Cannot use a ...
Termato's user avatar
  • 123
2 votes
0 answers
122 views

Replication stopped working, no errors

I have a TOP server (SQL Server 2012) with a merge replication to around 4 other servers. When I subscribe to the publication, everything is downloaded fine to the subscriber. The insert of one of ...
irco's user avatar
  • 121
2 votes
0 answers
4k views

how can I track down the source of "Internal connection fatal error"?

I'm working on a 6-700 line SQL script today. I'm running it from SSMS. Pointing at a SQL 11.0 db. About half the time I run it, I get: An error occurred while executing batch. Error message is: ...
jcollum's user avatar
  • 207
2 votes
0 answers
244 views

Change version number of maintenance plan package

We have a Maintenance Plan on SQL 2012 that has been running fine. I made a change to it yesterday using SSMS 2014. When the plan ran last night I got the following error: The version number in the ...
Greg's user avatar
  • 3,252
2 votes
0 answers
74 views

SQL Server 2008 upgrade and clean

After upgrading a SQL Server 2008 instance to SQL Server 2012 (in-place upgrade), there appears to be numerous 2008 instance components (namely the 2008 SSMS in start menu, in add/remove programs ...
tubgirl's user avatar
  • 51
2 votes
0 answers
653 views

SSMS causing Event ID 4674: SeTakeOwnershipPrivilege

Somewhat of a strange one. Recently my user id's been showing up in a number of Audit Success records in the Security event log of one of our production database servers with the below content (or ...
JohnLBevan's user avatar
2 votes
0 answers
102 views

How to display differential backup date in SSMS Object Explorer Details

SQL Server Management Studio exposes the Object Explorer Details (selectable from the View menu option) and its context menu that allows adding fields to the default display. Full and Transaction Log ...
EngineeringSQL's user avatar
2 votes
2 answers
13k 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 ...
SqlRyan's user avatar
  • 1,228
1 vote
0 answers
75 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
1 vote
0 answers
41 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 ...
MattT's user avatar
  • 11
1 vote
0 answers
60 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
1 vote
1 answer
980 views

No connection possible after TrustServerCertificate=True => The certificate chain was issued by an authority that is not trusted

I have a machine which could connect to an MS SQL Server in the past. I have SSMS installed and the connection was possible when I activated TrustServerCertificate checkbox in SSMS. I could connect ...
Sebastian Siemens's user avatar
1 vote
0 answers
509 views

SQL Server Management Studio compatible with Windows 10 32 bit

I'm running a VM with Windows 10 32 bit OS and I need to install SQL Server Management Studio. The OS on my VM OS Name: Microsoft Windows 10 Pro OS Version: 10.0.19044 ...
sergiom's user avatar
  • 159