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.
203
questions with no upvoted or accepted answers
10
votes
1
answer
841
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 ...
- 201
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 ...
- 1,635
4
votes
1
answer
148
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 ...
- 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 ...
- 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, ...
- 31
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 ...
- 31
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
...
- 293
3
votes
0
answers
380
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 ...
- 31
3
votes
0
answers
542
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 ...
- 3,844
3
votes
0
answers
694
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 ...
- 4,797
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 ...
- 31
3
votes
0
answers
479
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 ...
- 31
3
votes
0
answers
430
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 ...
- 31
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.
...
- 139
2
votes
1
answer
738
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 ...
- 143