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
32 views

SSMS IntelliSense not working with sa user

In SSMS (versions 17 and 18), IntelliSense is not working with the sa user, but it is working with another user. If I connect to a SQL database with the sa user and create a query window, IntelliSense ...
2
votes
4answers
5k views

Transfer data from Excel to table

How can I transfer information from an Excel file to a table in a SQL server database through SSMS? Excel file Consists of five columns and a thousand rows. I followed the steps as explained here,at ...
1
vote
2answers
5k 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 ...
21
votes
4answers
29k views

Suppress SQL Server Management Studio auto complete

Is there a way to temporarily suppress SQL Server Management Studio's auto-complete while typing a query? I don't want to disable auto-complete completely just say hold down some key while typing in a ...
2
votes
2answers
31 views

using SQLCMD to export/extract data withot trailing spaces

I am trying to extract data from some of my tables using sqlcmd utility as SSMS does not generate appropriate csv-s for me. My issue: all csv extract includes trailing spaces according to table ...
1
vote
1answer
28 views

Execute SSIS (package) in SSMS using T-SQL and return a value

Using VS (2019) I created an Integration Services Project to code an SSIS package. The goal was to call a Web API from an SSIS package using input variables like username/password/url and so on. I ...
4
votes
1answer
118 views

Not able to restore a backup to SQL Server 2019

I am trying to a restore a SQL Server from a .bak file and always get the same error : The database was backed up on a server running version 15.00.2000. That version is incompatible with this server,...
0
votes
1answer
468 views

Unable to Create new Maintenance plan in SSMS 2017

Hi I have reinstalled SQL Server 2016 in my database server last day. I am able to connect to SQL Instance(SQL-02) using the SSMS 2017 i had earlier in the same server before reinstall. But when i ...
1
vote
1answer
91 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 ...
0
votes
3answers
49 views

I have SQL Server Management Studio 18 - Where I can find SQLServerManager / SQL Server Configuration Manager

I need to install SQL Server Configuration Manager in order to configure SQL Aliases, but I don't want to install whole SQL Server I expected it to be installed with SSMS, but I'm unable to find ...
0
votes
0answers
5k views

Databases list not showing up?

This morning when I logged into SQL Server Management Studio (v 10.0.16) I clicked on the databases node and saw all by db's (they are hosted remotely) as I have done for the last 3 years. This ...
12
votes
5answers
16k views

SQL Server 2012 is putting [brackets] around Table and Column Names

When you drag the Columns folder to editor Window, the full list of Columns are added without Brackets. If you drag columns individually they have Brackets. Is there anyway to turn that off? I'm ...
0
votes
1answer
44 views

What's the maximum number of characters you can copy from a cell

If you ctrl + c a cell how many characters do you actually copy? I'm getting 43679 I was wondering if this is the limit of ctrl c? is this configurable? the real length of the cell is around 160k ...
0
votes
0answers
546 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
2answers
33 views

Is it possible to prevent SQL Agent Job from running if related job or previous instance has not finished?

I have three SQL Agent jobs, one for each of three registries being managed. These go off on a staggered schedule every two hours (i.e. Reg 1 at 9am, 3pm; Reg 2 at 11am, 5pm; Reg 3 at 1pm, 7pm). In ...
0
votes
0answers
30 views

Missing tables in AdevntureWorksDB

Recently I found some old questions that involve querying data from AdevntureWorksDB across several operations(DML,DDL). One such question was : Create and execute a query that computes the total ...
1
vote
0answers
10 views

I manage to connect to Azure Analysis Services from SSMS, but not from SSIS

I'm new to the Microsoft Server Suite. I've downloaded SSMS and connected to Azure Analysis Services from it. I'm able to query my data using mdx without any problems. However, I actually intend to ...
3
votes
1answer
47 views

SSMS / SQL-Server delays console output (RAISEERROR WITH NOWAIT)

It is well known, that SSMS (or maybe the SQL Server, but I'd guess more the SSMS) delays PRINT messages until several lines (40) are gathered in the buffer, before they are really printed to the ...
2
votes
1answer
41 views

fulltext_stoplists to database_principals issue

When I run a DBCC check against the database, it informs me that there is an issue with the sys.fulltext_stoplists object. It appears that the principal_id in stoplists does not have a relationship ...
1
vote
1answer
165 views

Some queries not logging using RDS's SQL Server with C2 Auditing enabled

Similar to a past issue I had with audited queries not showing when using Extended Events, I'm having an issue with queries not logging when using C2 Auditing on an RDS SQL Server instance. (I would ...
-2
votes
1answer
24 views

CHECK CONSTRAINT isn't identifying breaches of a constraint but DBCC CHECKCONSTRAINTS does

I have a table full of data and I have a constraint on a field in that table that is setup to ensure the total of 2 fields equals a 3rd field. For example: ALTER TABLE [dbo].[Table1] WITH NOCHECK ADD ...
1
vote
1answer
100 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 ...
4
votes
2answers
478 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, ...
0
votes
0answers
35 views

View multiple Database Servers through single SSMS connection

Recently I've been handed the keys to an environment with several servers, each running multiple instances of SQL server. These span many version of SQL server over the years. I have documentation I'm ...
14
votes
3answers
22k views

Stuck task in management studio, how do you handle them?

After clicking on "Take database offline" in management studio this message stays hang and won't close if you click on close. What's a good way to deal with stuck jobs like these in management studio ...
0
votes
1answer
21 views

Is there a way to optimize the process of uninstalling and installing SSMS?

in terms of patching sql server 2016 to the latest cumulative patches, I found out that stopping the services helps avoiding lots of inconveniences, specially if there is log shipping and replication ...
0
votes
0answers
25 views

How to troubleshoot slow connection issues from SSMS? [duplicate]

I right click on a server in the Registered Servers pane and select New Query. Sometimes (like 1 out of 3), it will just hang for 5-15 seconds with the Connect dialog (below). Other times, it ...
0
votes
2answers
182 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 ...
6
votes
3answers
4k views

SSMS Restore Database wizard slow to respond

I've just noticed this recently on one of the SQL Server 2012 SP3 instances that I oversee. When I try to restore a database using SSMS 2012 (by right-clicking on the database,and choosing Tasks>...
1
vote
2answers
50 views

I can not navigate through the objects in sql server managemente studio - lock never goes away

Whenever I try to navigate through the objects in sql server management studio object explorer I get the error message Lock request time out period exceeded. (Microsoft SQL Server, error: 1222). It ...
5
votes
1answer
2k views

Howto avoid textdata of trace gets truncated?

I have a trace file including the TEXTDATA column created by a server-side tracing. Some of the traced queries are very long. If I re-open the trace file on Profiler, the relevant long query is ...
0
votes
1answer
25 views

Remove/suppress dashes from “Results to Text” output in SSMS?

(This is just a "reproducer", not the real code, because that's long and complicated.) The output of SET NOCOUNT ON select @@SERVICENAME select @@version is: ---------------------------------------...
0
votes
1answer
31 views

MS SQL Server: Import Flat File with auto-increment ID

So I've downloaded a sample database. It originally didn't have an ID column so I inserted one in through Excel. Anyways, I went through DatabaseName > Tasks > Import Flat File and the usual ...
1
vote
1answer
823 views

Renaming a column with sp_rename hangs SQL Server 2012

I was attempting to remove a column from a table within SQL Server 2012 for one of our developers. As a precaution, before dropping the column, we rename them to make sure that everything continues ...
1
vote
1answer
30 views

Is there some plugin that would reconnect query tabs to original DB's in SSMS?

It's a minor thing, but annoying one. I'm currently working on about 5 different databases, and every time I restore db's from snapshots or run my restore from backup scripts, all of the queries get ...
0
votes
1answer
17 views

How to Capture Job Exit Code?

I'm essentially trying to find a better way to determine if my job has completed successfully before moving on to another call of the same job. I have multiple jobs which run through a parsing process ...
2
votes
1answer
393 views

SQL Server managed backup missing in ssms [closed]

Trying to configure Sql Managed backup to azure, and it seems that "Managed backup" is missing from the GUI under Management in SSMS 17.2 All guides I see kind of implies that it's already there. But ...
2
votes
4answers
15k views

How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?

I have two databases - Database1 and Database2. Both databases contain a table that has similar structure, exemplified as follows: ====================================================================...
1
vote
1answer
115 views

Interpreting XDL / Deadlock dumps in SSMS

I've generated the following XML + XDL: <deadlock> <victim-list> <victimProcess id="processc1eaf13468" /> </victim-list> <process-list> <process id="...
1
vote
2answers
37 views

Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password

Background I'm having to connect to a customer's Microsoft SQL Server. I generally don't need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so ...
0
votes
1answer
2k views

Adding a domain user in SQL Server Management Studio

Before I ask my question, let me mention that my SQL Server is installed on a member server of a domain (it belongs to the domain but is not an AD server). I am having trouble adding a network user ...
0
votes
1answer
218 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 ...
6
votes
2answers
340 views

In SSMS, is “Navigate to” (Ctrl+,) of any use?

In standard Visual Studio 2012 or higher, IDE window called Navigate to... (Ctrl+,) offers all useful objects in scope of currently open project (see samples) getting increasingly filtered as I am ...
0
votes
2answers
61 views

Can't alter database roles on a restored database

My SSMS Login (using an AD group) is allocated all server roles apart from sysadmin so I have quite a lot of access. Using this Login, I have restored a database from its .bak file. However, my Login ...
4
votes
1answer
952 views

SSMS Cannot show the editor for this task (Notify Operator Task)

I'm getting an error message whenever I double click on a Notify Operator Task in our Maintenance Plans in SSMS, which says "Cannot show the editor for this task." Property IsMailHost is not ...
2
votes
0answers
49 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/...
0
votes
3answers
565 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 ...
2
votes
1answer
2k 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
1answer
16 views

How to Get All Server Side Traces in SqlServer from SSMS, stop it from SSMS and delete the log files

How to Get All Server Side Traces in SqlServer from SSMS(Active,Inactive), stop it from SSMS and delete the log files. I need all traces saving into file as well as table. I tried SELECT * FROM ...
0
votes
1answer
549 views

Unable to connect to Listener after rebuild

I dropped an AG with DROP AVAILABILITY GROUP [MyDb] it had a listener. I left the listener open in the object Explorer of SSMS 17.3. While the AG and Listener were down. I hit refresh on the ...

1
2 3 4 5
21