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
-1
votes
0answers
9 views

SSDT debugger error in visual studio by database engine SQL-SERVER 2019

In new futures of Microsoft company remove debugger in SSMS database engine 15.0 and they are called improvement. (-_-) I tried use debugger in visual studio 2019 by this answer : How to add the ...
1
vote
1answer
11 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 ...
2
votes
0answers
24 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
23 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 ...
0
votes
0answers
32 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 ...
0
votes
1answer
20 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
43 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 ...
0
votes
1answer
22 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
28 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 ...
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 ...
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 ...
1
vote
2answers
36 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 ...
2
votes
0answers
44 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
1answer
14 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
2answers
60 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 ...
0
votes
1answer
24 views

SQL Server Management Studio cannot Connect to Always On Availability Listener

I am trying to connect to the AG Listener in SSMS. I choose [Connect] Then [Database Engine] I type in the name of the listener I created. SQLListener [Windows Authentication] Click [Connect] ...
0
votes
1answer
27 views

SQL Server AlwaysOn Availability Group - Creating an Index Online in SSMS

I am running a 2-node SQL Server 2016 AlwaysOn Availability Group. I would like to create a non-clustered index online in SSMS for one of the availability databases in the AlwaysOn Availability Group....
0
votes
2answers
46 views

Deny certain user from updating certain rows [duplicate]

Say I have a table like this: canModify | name | age ------------------------ 1 | John | 24 0 | Nick | 21 I want to grant update access to a specific user only where canModify=1 I ...
0
votes
1answer
32 views

Logon failed for login due to trigger execution / LOGON TRIGGER

I have this situation. I created a logon script to block any session for specific logins. These logins are in a table. So the behaviour of my script is simple. Get the login from the table, compare it ...
1
vote
1answer
13 views

Is there a way to group often used tables and queries in SSMS? [closed]

I am not a DBA by training, but due to role shifts I am having to modify and maintain tables and stored procedures fairly often. I would like to visually group tables and stored procedures together in ...
1
vote
0answers
21 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 ...
4
votes
1answer
181 views

How to get list of users on all instance's databases? excluding the mirrors!

For an audit of our MSSQL databases, I have been asked to provide a list of all users for each database running on each instance. There is an existing stack overflow question which advised to use......
0
votes
1answer
40 views

SSMS Linked Server -ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (Microsoft SQL Server, Error: 7303)

How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"? I've tried many methods as following to show you what I did right now: Oracle client connect to ...
0
votes
0answers
49 views

how to open SSIS 2016 with SSMS 18.5 or later?

I have just patched one of my sql server 2016 instances to the latest cumulative patch (at the moment CU 12 that gives you a version 13.0.5698.0 as you can see on the picture below). I had a few ...
0
votes
0answers
16 views

I am not seeing Management Folder in SSAS but I do see it in SSMS. What am I doing wrong?

So I am trying to turn on extended events for my SSAS multidimensional cube. However, when I am logged into SSAS (with full admin priv) I only see Database & Assembly folders as seen below. I am ...
0
votes
0answers
10 views

Modifiing object in SSMS while Check for object existence is True

When Check for object existence is set to True in Scripting options of SSMS, modifiing object like stored procedure in Object explorer generates ALTER code encapsulated with sp_executesql (with ...
0
votes
0answers
23 views

How to get the table change script for SQL Server using SSMS 2017?

I'm having frequent table changes in my database, I'm using SSMS 2017, is there any easy mechanism for generating scripts for the changes made to the table. Or Are there any tools for managing this ...
0
votes
0answers
46 views

Failed sending an email to outlook account using SQL server management studio

I have been trying to send an email to my outlook account using SQL server management studio but keep facing with error like: The smtp server requires a secure connection or the client was not ...
0
votes
1answer
30 views

SSMS execution time queries besides SET STATISTICS [closed]

When I run my query, it prints multiple execution times instead of just one. I only want one so what should I use instead of SET STATISTICS? SET STATISTICS TIME ON DECLARE @firstNum INT, @secondNum ...
0
votes
1answer
24 views

How to bring all replicas on a SQL availability group to an earlier state / point in time?

I have a SQL Always on availability group, with 4 replicas. One of them is the primary. Lets say someone accidentally drops a table on the primary. This transaction would go to all of the secondary ...
0
votes
2answers
39 views

SQL Server instance level action tracking

How can we track actions happening at instance level in SQL Server 2014 .e.g. would like to know who created database, who changed recovery model, who setup backup strategy, who gave permissions to ...
1
vote
1answer
308 views

Activity Monitor paused

Some of our end-users still like to use the Activity Monitor in SQL Server. When setting up our SQL-server 2016 servers the activity monitor always ends up in a paused state when the users are not ...
1
vote
1answer
37 views

With SSMS on my local machine, is it possible to login to a remote SQL server on my VPN network via my Active Directory credentials?

I'm trying to login to a SQL server on my work network with a VPN connection to the network and by using my AD credentials. When I'm directly on my office machine, I use "Windows Authentication" as ...
0
votes
2answers
48 views

Creating a database snapshot for every previous month

I am new to SQL Server, I got a task to create a snapshot of existing database for every previous month until current month and do a snapshot once a month from now on. I created a job to make ...
0
votes
1answer
106 views

SQL Server Management Studio Error Access Denied Editing Job Step

I recently changed the owner of a job from my user to sa. After the ownership change I am able to edit the Schedules and Notifications for the job. However all attempts to to create New, Insert, Edit, ...
0
votes
1answer
62 views

SQL Server Failed Login - SQL Server login (not windows) - Random times

We have the following situation and am wondering if anyone can suggest a way of determining the cause. One of our SQL Developers can log into, and use, the instances/databases fine and has a SQL ...
0
votes
0answers
93 views

“The backup set holds a backup of a database other than the existing database.” - No matter what - even with replace?

I have a strange problem. I have been able to restore + overwrite databases for years on our SQL Server yet suddenly I seem to be unable to overwrite any databases. I should be system admin, there is ...
0
votes
2answers
95 views

why there is no incremental backup in sql server [closed]

How i can change my database backup type from full backup to incremental backup? Is that possible? Why there is no option for incremental backup type.
9
votes
1answer
302 views

MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can't Bring It Online

I can take databases offline (via GUI) but can't bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A ...
0
votes
1answer
108 views

After doing latest windows10 update 1909 SQL Server Management Studio 17 not working

yesterday I have an update for windows version 1909, after updating to the latest version, When I tried to open SSMS it shows me an error like this(please check the screenshot).
0
votes
0answers
22 views

SQL Server Management Studio: Could not load file or assembly 'Microsoft.VisualStudio.TextManager.Interop.8.0'

I've had this problem for a while and can't find anyone with the exact same issue. I get the error when trying to select top 1000 rows. I checked in the PublicAssemblies and it is not there. the ...
0
votes
0answers
51 views

Unable to create ssis db catalog

I am trying to create ssis db catalog using wizard but getting this error message: The catalog backup file 'C:\Program Files\Microsoft SQL Server\120\DTS\Binn\SSISDBBackup.bak' could not be ...
1
vote
2answers
93 views

(SSMS) How do you prevent an open tab from querying a DB after disconnecting the server

In SSMS if you have a tab open with a query and then you disconnect the database you can still run the query after disconnecting. is there a way to prevent SSMS from running a query after server is ...
0
votes
1answer
55 views

Permissions for Edit Top X Rows in SSMS

What are the minimum permissions needed to allow Edit Top 200 in SQL Server Management Studio?
0
votes
0answers
21 views

Restore got failed in sql server

While i restore my database i got the below error. But i have more space in my drive. modify file encountered error 112 (Ther is not enough space on the disk)while attempting to expand the physical ...
0
votes
0answers
23 views

SSMS 18.4 Disappears

SO recently we had a hard time figuring out why we could not find SSMS all of a sudden in one of our servers. Initially thought it was uninstalled by any of the members of DBAs but later found it to ...
0
votes
1answer
36 views

SSMS18 - Default File Location (Changed ssms.Application.pkgdef)

I have changed the DefaultProjectsLocation (SSMS18) from the default (My Documents) to a folder on my network. But when I run SSMS18 and open Projects it is still looking at the default location. What ...
0
votes
1answer
24 views

Using Management Studio on Linux [closed]

Is it possible to use Management Studio in Linux? I want to connect to my SQL Server instances with an IDE. How can i do that?
1
vote
0answers
296 views

Is it possible to edit the “Missing Index Details” template in SSMS?

When you turn on "Include Actual Execution Plan" and run a query in SSMS, the resultant plan can include information about missing index(es) that would make the query more performant. In that case, ...

1
2 3 4 5
21