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
0answers
19 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 ...
0
votes
2answers
34 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
34 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
19 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
21 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
23 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
21 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
268 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, ...
0
votes
0answers
26 views

What Visual Studio version should I use when I have SQL Mangement Studio v18.3.1 already installed?

I really like using SQL Server Management Studio v18.3.1 but I want to be able to step through code for troubling shooting. Since this version of SSMS does not have the "Debug" button or "Debug" pull-...
1
vote
0answers
17 views

Migrating TDE Protected Database - Cert Migrated, Manual Copy Works, But Not Copy Wizard

I'm attempting to migrate several DB from an SQL 2014 to 2016 server. They all have TDE enabled, and are protected by a certificate. I successfully copied the certificate, and I am able to manually ...
0
votes
1answer
77 views

MSSQL 2016 - Restore SSISDB from MSSQL 2012

On "MSSQL 2016 (SP2-CU11) (KB4527378)" I created empty SSISDB. After that I restored SSISDB from "MSSQL 2012 (SP4) (KB4018073)" to "MSSQL 2016 (SP2-CU11) (KB4527378)" On DB I set owner to sa and ...
2
votes
1answer
72 views

Procedure shows results differently in SSMS 18.4 than in SSMS 17.9

I have a complex stored procedure that queries specific network folders, collects the names of SQL Server backup files it finds there, and then processes each file for details. If I run the procedure ...
1
vote
2answers
40 views

Copy database removed source - Cannot acces mdf file

I attempted to copy a database, using Microsoft SQL Server Management Studio (SSMS), but right-clicking and following the wizard. I wanted to target server to be the same as the source, so I added "...
-1
votes
1answer
33 views

See UPDATE permissions at column-level for all tables in a database [closed]

I have a table of metadata, listing every variable in every table in my database, which when a variable is flagged as 'Released' it triggers a stored procedure to deny UPDATE permissions on that field ...
1
vote
0answers
39 views

IntelliSense is not woking SQL Server 2017

I am using SQL Server 2017 and I had already installed Visual Studio 2019 before installing SQL Server. Sometimes when I create the first table in a database it gives me IntelliSense for that first ...
-1
votes
1answer
20 views

Using Sum With Query

How can I get the Sum of data from a secondary table w/o using a join? Select emp.ID, emp.fname, emp.lname, emp.address1, emp.address2, emp.city, emp.state, emp.zip, emp.phone, Sales = SUM(Select ...
8
votes
1answer
143 views

Permissions required for row counts to show up on Object Explorer Details

I'm having a weird security issue. I have a user that's using SSMS 18.2 on a SQL 2016 server. They are a member of db_datareader but when they pull up the the Row Count column in Object Explorer ...
6
votes
1answer
2k views

Does SSMS use ODBC?

I am running SSMS V18.2 and connecting to SQL 2008 - 2019 instances. I am researching various multiple subnet connection scenarios. I learned that ODBC 13.1+ includes ...
0
votes
1answer
21 views

Login failed for newly created user

I just created my first database yesterday. It is now set up and I can write to it from my C# application using the admin user login. I would now like to use a limited write only user so my admin ...
-1
votes
1answer
44 views

Is there a good SSMS T-SQL code clean up / formatter plugin? [closed]

I'm looking for a good plugin that will automatically do things like upper case all keywords, indent lines appropriately, maybe brackets around reserved words being used as names / aliases, etc.
-1
votes
1answer
48 views

Can I use built-in (deterministic) SQL functions in a Computed Column or do I need to create my own function as a passthrough to leverage them? [closed]

I'm trying to create a (persisted) computed column on a table that is essentially:YEAR(DateColumn). When I try to directly call the YEAR() function inside the Formula of the Computed Column ...
0
votes
0answers
15 views

SSMS 18 Install Error - Microsoft Analysis Services OLE DB Provider

I've been trying to install SSMS (18) and I get this error every time: I've tried installing the OLE and tried numerous fixes online (can't remember every as this was a few weeks ago) but nothing ...
2
votes
1answer
65 views

Extended Events Collation resolution error

When trying to expand the sessions under extended events I am getting a Collation Resolution error in SSMS 18.2 (15.0.18142): Looking at a trace I have found that this query is what is giving me the ...
9
votes
3answers
277 views

Help performance tuning master/detail (email like inbox) SQL query

I have spent the last couple days searching, watching videos, and I think I've gotten as far as I can get just fumbling my way through. I am looking for more specific direction given my example below. ...
1
vote
2answers
212 views

How to print results in SQLcmd window

I'tm trying to show in SQLcmd window the results of these queries: SELECT SYSDATETIME() AS "date"; PRINT 'EXTRAÍDO POR:' SELECT SUSER_NAME() AS "Owner" PRINT 'PASSWORD SETTINGS'; exec ...
0
votes
1answer
53 views

How to print more than 8,000 characters at a time to the SSMS Message window, without compromising text formatting?

Whenever I write dynamic SQL, I typically include a PRINT @DynamicSQL statement in a comment right above the EXEC sp_ExecuteSQL @DynamicSQL statement so that the dynamic SQL can be easily read and ...
0
votes
1answer
42 views

Restoring a Database Using Full Backup and Transaction Logs in SSMS

I have a full backup file (.bak file) of a database for the 25/10/2019. However I want to restore the database to the 21/10/2019. My problem is that I do not have the full backup files for the 21/10/...
0
votes
1answer
30 views

Is it possible to generate DB diagram for all SQL databases opened in SSMS

At the present we have to go to each database and manually generate database diagrams, so I want a way to automate this. Question: Is it possible to generate DB diagram for all SQL databases opened ...
0
votes
0answers
18 views

Syntax highlighting in View Designer and Edit All Rows

I simply want syntax highlighting for the View Designer and Edit All Rows For example, in the View Designer SQL (right click View >> Design) And in the Edit All Rows SQL (right click Table >> Edit ...
2
votes
1answer
67 views

Imported SSIS package fails if imported with SSMS on the SQL server, but works when imported from a remote PC

I am facing a strange issue on SQL Server 2017 Enterprise edition running in AWS on EC2. When we are on the SQL server and we import an SSIS package using the locally installed SSMS connected to ...
1
vote
1answer
64 views

Login failed for user when trying to connect to Azure Postgre database from MSSMS [closed]

I created a database on Azure but can't log to it with MSSMS. I always have the Error 18456 even if I followed this tutorial. TITLE: Connect to Server ------------------------------ Cannot connect ...
1
vote
1answer
37 views

Cannot take backup into NAS storage at specific time

I have a job which runs every 30 minute and takes t-log backup of the database suing Ola's script. Every Thursday and Friday at 22:45 I get an error: 11/07/2019 22:45:00,Backup,Unknown,Error: 3041<...
0
votes
1answer
32 views

SSMS.exe Access Denied

have a new Win10 pc and need run MSSQL Management Studio as a different user. However when I do so I get error: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe ...
-1
votes
1answer
41 views

data compression does not show when scripting index on ssms

when I right click on SSMS and choose to script the create index: I get this script, without the data_compression: USE [APCore] GO /****** Object: Index [i_agencyId] Script Date: 07/11/2019 12:...
1
vote
0answers
41 views

How many connections does Object Explorer use in SSMS?

I recently enabled DAC and noticed this error when first trying to connect with object explorer in SSMS: Cannot connect to admin:servername Dedicated administrator connections are not ...
1
vote
1answer
39 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 ...
1
vote
0answers
34 views

SSMS Connect to remote SQL instance with Windows Authentication

I have a remote SQL instance (Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
3
votes
1answer
52 views

Inconsistency between object explorer and available database dropdown

I am working with SQL Server 2008R2. I am able to see a database in the "available database" drop down, but not in the object explorer. I am able to query it, for example select * from ...
3
votes
2answers
84 views

SSMS cannot connect remote server by IP through Windows authentication

I'm trying to connect a remote server by IP,port via Windows authentication. It will end out with the following error Connection Timeout Expired. The timeout period elapsed while attempting to ...
3
votes
0answers
74 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, ...
0
votes
1answer
102 views

I'm not understanding the concept of login/user on Azure [closed]

So as a SQL Server DBA, I can normally create a user, then inside the database U just create a login pointing to that login and then I give the necessary privileges. I'm trying to understand the ...
1
vote
0answers
28 views

Is the table designer not supported for memory optimized tables?

If I right click a table, I get the normal designer option: But if I right click a memory optimized table, the designer is missing: The server is 2016 and I've tried it in SSMS 16, 17, and 18.3. Is ...
0
votes
0answers
24 views

Is there a vsix installer for SSMS 2014?

Is there any way to install extension from vsix into SSMS 2014 without breaking the pkgdef from both sides? Because everytime I copy paste one of the extension directory from Visual Studio 2010 to ...
1
vote
0answers
33 views

How to force SQL Studio not to use copy-only backups to build database restore script?

How to force SQL Studio not to use copy-only backups to build database restore script? I want to ommit copy-only backup (because it's not longer available) and force studio to use last full backup (I ...
0
votes
0answers
46 views

Unable to access SQL Server from SSMS 2014

I'm unable to access the server after I installed Visual Studio Isolated Shell. No matter how I try to access the server, the result will always be the same (image below). How can I access it back ...
0
votes
0answers
127 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
0answers
22 views

Setting an Authorization [duplicate]

How can I set a user's authorization to see only the database that the user got access to, when accessing database via MS Management Studio? Is that even possible?
0
votes
0answers
69 views

launch database mirroring monitor grayed out in SQL server 2014

I have 2 servers configured with mirroring each other. Both the servers are principal & Mirror servers each other. From the 2nd Server launch database mirroring monitor is working fine but from ...
0
votes
0answers
23 views

Internet-facing loadbalancer for encrypted connections to DB

I am trying to get my head around a problem; Background: Host1 is running SQL-Server 2017 on an EC2 in a private subnet in AWS. Problem: In order to have it accessible for an external service we put ...
-1
votes
2answers
56 views

In SSMS I can hover over a column name and it gives me the Type. Is there also a simple way to get its source table/query?

In SSMS when I am in a script, I can hover over a column name and it will give me the column's type and if it is Null/Non Null. Is there a similar simple way to get which table/query in the From ...

1 2 3 4 5 20