Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

3
votes
0answers
38 views

Slow Connection to Azure SQL Database using SQL Server Authentication

In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish. Once connected, ...
3
votes
0answers
112 views

Data Synchronization from Remote MS SQL Server

I have a client server on which my user has limited permissions (i.e. SELECT only for example). I need to select some data from that server and insert into my local database. This has to be a ...
3
votes
0answers
479 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 SQL ...
3
votes
0answers
2k 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 ...
3
votes
0answers
268 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 ...
3
votes
0answers
272 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 ...
2
votes
0answers
51 views

How to prevent SQL files opening new instances of SSMS 17.9.1?

Synopsis This is not a new problem and there are several solutions floating around on Internet. Problem When you double click on a .sql file, a new instance of SSMS is opened. I did not have this ...
2
votes
0answers
44 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 ...
2
votes
0answers
285 views

Elegantly handling 'enum-like' magic numbers in T-SQL code

We run Dynamics GP, and anybody that's dealt with GP will be familiar with all of its "magic number" columns representing the various enum values inside the application. For example, a reporting query ...
2
votes
0answers
199 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!
2
votes
0answers
17 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 ...
2
votes
0answers
529 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 ...
2
votes
0answers
49 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: ...
2
votes
0answers
211 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 ...
2
votes
0answers
329 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 ...
2
votes
0answers
252 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 ...
2
votes
0answers
338 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 ...
2
votes
0answers
414 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 ...
2
votes
0answers
257 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 ...
2
votes
0answers
58 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' ...
2
votes
0answers
4k 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....
2
votes
0answers
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 ...
2
votes
0answers
841 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 ...
2
votes
0answers
470 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 ...
2
votes
0answers
736 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 ...
2
votes
0answers
1k 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 ...
2
votes
0answers
79 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 ...
2
votes
0answers
3k 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: ...
2
votes
0answers
230 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 ...
2
votes
0answers
475 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 ...
2
votes
0answers
91 views

How to safely take an SQL job out of the schedule?

There is a table | jobID | status | startTime | endTime | and a job, that is scheduled to run every X seconds, it will take the first undone job ID, put it in stored proc and run it. Stored proc takes ...
2
votes
0answers
88 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 ...
1
vote
0answers
333 views

Error cs1567 while installing ms-sql on windows 8.1

I tried to install sql server 2008 and 2012 on my windows 8.1 laptop but at both times i faced with the same error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following ...
1
vote
0answers
136 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 ...
1
vote
0answers
143 views

SSIS job runs successfully but doesn't load data

I am running a job from SQL Server Agent and the job runs successfully. However it doesn't load any data (in my case Excel files from a local folder). I created a new Proxy Account to run this job but ...
1
vote
0answers
36 views

Batching a query from a linked Oracle database in MS SQL

Working to compare and older Oracle database with a newer updated version to check that all documents have migrated correctly. 1=1 and 2=2. The database is very large ~25,000,000 rows. So I want to be ...
1
vote
0answers
19 views

Problem about listing network instances on SSMS

I have a problem about listing network instances on SSMS. When I look at the Network Instances on SSMS, it shows only local server instances. By the way, it shows all the instances on the network ...
1
vote
0answers
261 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 ...
1
vote
0answers
545 views

Yet Another “Connection Timeout Expired pre-handshake acknowledgement” problem

This is SQL Server 2012SP4 on Windows 2012R2, with .NET Framework 4.7.02053. I've RDPed into the database VM and open SSMS. It times out with this error the first time I try to connect. If I try ...
1
vote
0answers
36 views

SQL Management Studio 2012 not loading

I have installed SQL Server 2012 R2 on my Windows 10 machine, but when i launch SQL Management Studio, the splash screen shows for a minute but then the tool never comes up. The computer is pretty ...
1
vote
0answers
404 views

Error while importing flat file (CSV) in SSMS 17.5

I'm not sure if this is a bug or not, but when trying to import a CSV file (with no headers and text qualified (")) using the new "Import Flat File" in SSMS, I get this error: "A column named foo ...
1
vote
0answers
6k 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 & ...
1
vote
0answers
34 views

Hide tables from SSMS Intellisense

Is it possible to hide tables or other objects from popping up on SSMS' IntelliSense? For example, I have the following tables Patient Patient_history Patient_daily I would like to only see ...
1
vote
0answers
42 views

How to save SSMS 2012 Object Explorer Scripting Settings?

I'm generating a bunch of object creation scripts in SSMS 2012, using the Object Explorer context menu. The default options for these generated scripts are not to my liking (for example, I want the ...
1
vote
0answers
1k views

SSMS 2012 - Cannot execute script - Object reference not set to an instance of an object.(Microsoft.SqlServer.Smo)

I get this error while trying to debug a very simple script: =================================== Cannot execute script. =================================== Object reference not set to an instance ...
1
vote
0answers
185 views

Why does Bitlocker intermittently require SQL service restart after sleep?

I have a development machine that has two drives: C:\ - Operating system (Win 10 Ent) and SQL Server 2012 Standard installation D:\ - SQL Server databases, backups, logs I recently activated ...
1
vote
0answers
430 views

User-Defined Table Type script with constraints (SSMS 2016)

How can one script a User-Defined Table Type with default constraints in SQL Server Management Studio (SSMS) 2016? I can generate a script, but it does not include these constraints. One cannot ...
1
vote
0answers
509 views

SQL Server opendatasource reading a password protected Excel file

I would like to read a password protected Excel workbook and I'm not sure what the syntax is to enter this parameter. I found only passwords for the connection, which is not needed due to login. I ...
1
vote
0answers
151 views

How to investigate non-specific Generate and Publish Scripts Wizard errors

I am trying to use the Generate and Publish Scripts wizard in SSMS 2012 against a 2012 SQL instance and am getting errors. Trying to generate a schema-only script of the tables and schemas. I allowed ...
1
vote
0answers
182 views

How does one export/import registered servers with passwords?

I have a pretty extensive collection of registered servers on SQL Server Management Studio 2016 on my box. However, I got a new box and want to move the entire collection there. So I right-clicked ...