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
4
votes
1answer
170 views

Availability Group Endpoints Windows Authentication Error

I have a two-node SQL Server 2016 Standard Always-On environment and when I create a new availability group, I receive the error message below: The Endpoints tab lists at least one endpoint that ...
6
votes
1answer
506 views

Exclamation point on plan guide

I created a plan guide using the following query: EXEC sp_create_plan_guide @name = N'Entity_Property fix', @stmt = N'SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value ...
0
votes
1answer
34 views

T-SQL - Script all tables creation, contraints, indexes, keys and triggers

I'm using SSMS and I was wondering if there is a script that can generate tables creation, constraints, indexes, keys and triggers for a given table names as a single result and another script that ...
0
votes
1answer
56 views

Cannot set up replication between two servers

I am trying to subscribe a 2016 (sp2, cu1) server to another 2017 server. I am getting the following error message: For merge publications, the version of the Subscriber must not exceed the version ...
0
votes
0answers
51 views

Can't connect to SSAS server — “Element 'return' was not found. Line 5, position 2.”

I'm trying to access an SSAS server from SSMS v17.4 (2017). I'm using Windows Authentication. I know the credentials are correct and can actually connect successfully from Visual Studio 2015. ...
11
votes
2answers
2k views

Where do you go to request new features in SSMS?

I'd like to ask Microsoft: To color code the pages in SSMS based on the server they are connected to Make it go ding when the query results are returned. Question: How do you ask for those features?
0
votes
0answers
24 views

SSMS Manage Help Content Error

I am not able to install Help Viewer 2.2 content in SSMS 17.9.1. I follow the steps in SQL Server offline help and Help Viewer, but after selecting content from the online source I get the error ...
0
votes
2answers
183 views

How to reduce the mdf file size in this database which I have 50 GB reserved space

I have a DB with 50 GB of size I need to reduce the size of it. How to reduce the file size of it? I already did this: shrink | files | selected 'Data' as filetype. but still it shows 50 GB Reserved ...
1
vote
2answers
473 views

SSMS does not open popup wizard to create a new schema

When I right click on 'schemas' and then on 'create new schema' my SSMS only opens the query editor but on every tutorial I saw a pop up wizard opens instead. How can I access this popup wizard? I can'...
0
votes
4answers
61 views

Creating a database from a backup file

I have a peculiar issue on my hands. I have a few databases in my SSMS already (2014), and when creating a new database and performing a restore from a file that has never been used, it sets my main ...
0
votes
2answers
543 views

How to view xEvent event_file data

I have a small xEvent that is sending the results as .xel to an event_file in G:\XEvents and I want to explore the data with SSMS. I have been looking for a solution and found several posts about ...
0
votes
1answer
47 views

Server version error where restoring backup with SQL Server Management Studio

I have SSMS v17.9.1 freshly installed. I believe the only later versions as of this post's date and time are only preview versions. I am attempting to restore a .bak file. I get the error that: The ...
0
votes
0answers
30 views

Maintenance plan changing from ALL USER DBs to SELECT DBs automatically

We came across an odd bug in Maintenance Plans on SSMS 2016 and 2017 for SQL Server versions 2012 and 2016 (at least). The setup is unusual, but I couldn't find anything about this or any similar ...
1
vote
2answers
64 views

Restore a single database backup (.bak) file into multiple filegroups

I have a SQL Server 2014 database DB01 (single filegroup - PRIMARY) and I took a backup of it into a DB01.bak file in SSMS. I have another database DB02 with 1 primary filegroup (1 file) and one ...
0
votes
1answer
23 views

Can I ignore queries about extendedproperty?

I want to reuse the structure of a database in a new project. So using SSMS I use Generate Script and in settings I set to generate schema only. In the result there are too many queries about ...
0
votes
4answers
227 views

SQL SSMS want to shortcut “Edit View”

I usually right click on a view or a stored procedure and then choose Script View -> Alter -> In New Editor Window. Is there a way to shortcut this - either on Keyboard or on direct menu entry?
1
vote
1answer
83 views

SSMS closes after installing visual studio

Good Morning. I have a problem, first I made the installation of SQL Server Express, followed by SSMS and finally Visual Studio Community. Before installing visual studio, SMMS worked perfectly, when ...
0
votes
0answers
34 views

Primary key error when running in C# but not SSMS

I have written a stored procedure to insert a record into a table that is used with our ERP system. When a record is written to this table there are triggers on the table that were written by the ...
1
vote
1answer
63 views

SSMS How to find the Connection name

How do you return the connection name via TSQL? This is visible in SSMS via the properties window. For example if you have a DNS alias "ProductionServer" for a machine named "SRVR0001" and further ...
2
votes
1answer
77 views

SQL Server Management Studio - Actual Execution Plan - Actual Row Size and Actual Data Size

I am looking at an actual execution plan in Microsoft SQL Server Management Studio v 17.9.1 and I can't see a lot of actual values to compare against the estimates. For example, we have a connector ...
0
votes
1answer
314 views

I'm trying to enable SQL Filestream on Windows Server 2012 and SQL Server 2016 64 bit, Management Studio 2017

The machine config is Windows Server 2012, 64 Bit SQL Server 2016, and SQL Server Management Studio 2017. When I use SQL Server Configuration Manager to enable filestream, it gives me an error that I ...
1
vote
1answer
124 views

Getting attended, absent and no class days from database attendance

Problem the problem is that I am able to get the days instructors record attendance and only that, I am unable to get the days they didn't make attendance and the days the instructors were not ...
-1
votes
1answer
77 views

Subtract column data from two unrelated tables

this is my database diagram i want to determine blood remaining in each bank i am having a problem because the tables donation and transfusion are not related how i can subtract? i have created ...
3
votes
1answer
117 views

SSMS generated script failing to execute

So I am in a situation where I need to import a small DB (under 1GB) from a newer version of SQL Server (I am restoring to a 2014 SQL Server from a 2016 SQL server), without a direct connection ...
2
votes
2answers
2k views

How to resolve error 15517 when DBO is set to SA?

Newbie DBA here, just getting settled into my first DBA job and trying to figure out how things work outside of a classroom environment. Your patience is appreciated. I'm trying to create diagrams ...
-2
votes
1answer
49 views

Looking for help with this shipping report! The Case Syntax is throwing me for a loop

So, the goal of this report is to get all orders that have been shipped in a month (October here). I was initially just using the 'PickedUpOn' field but soon found that there were instances where this ...
1
vote
1answer
36 views

SSMS 2017 Export SCOPED CONFIGURATION

I reinstalled Windows 10 from scratch. I'm trying to get SSMS options setup the way I like them. When I r-click a DB, then Tasks->GenerateScripts, the result doesn't contain SCOPED CONFIGURATION ...
1
vote
2answers
67 views

Creating databases - no access to folder - MS SQL

I am merging a few instances together which are for separate customers. They need to be separated by account access so customer X can't view customer Y's databases. I have created a login (we'll ...
0
votes
1answer
108 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 ...
5
votes
2answers
527 views

SSMS can't connect to Azure database

I got a new Windows 10 machine and installed the latest version of SQLEXPRESS and then the latest version of SSMS (17.9.1). When trying to connect to my Azure database, I'm getting the following ...
1
vote
1answer
135 views

Rolling week numbers into one row and getting cummulative values

I have a table of orders with varying dates and have been asked to get the weekly order count for past 8 weeks and cummulative order count overall I have been using the datepart clause to break my ...
2
votes
1answer
64 views

Why wont SSMS remember my tables when I connect to the server

I have the same problem everytime I connect to SQL server through the SSMS tool. If I have been working on a script and close my laptop for a period of time, when I come back and re-connect it doesnt ...
-2
votes
1answer
243 views

How to add operator and email notification on all the SQL jobs?

To be more proactive and responsive to the job issues or failures I want to set an alert, add operator and send the notification(to me) when a job fails. I know Operator and notification can be added ...
1
vote
0answers
282 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 ...
3
votes
1answer
1k views

Does SQL Server Management Studio 2017 Contain a New Explain Feature

TL;DR I happened upon a feature in SQL Server Management Studio v17.9 which I was not aware of. It looks a bit like the EXPLAIN found in Oracle, PostgreSQL and MySQL. Where is this feature documented?...
0
votes
1answer
415 views

Query or ETL process to insert data into fact tables in SSMS

I'm working on creating a star schema for my project. I want to use it for reporting. I have used Google Play Store dataset from Kaggle. The thing that I'm having trouble loading data into my fact ...
0
votes
1answer
49 views

Is it possible to get server roles and database roles in a same query/script?

Is it possible to get all database roles and server roles in the same query/script? if so then how can it be achieved? Initially, I wrote two separate queries, one for server roles and another one ...
4
votes
1answer
627 views

Can SQL Server disable IntelliSense on SSMS?

I am using SSMS 2016 (ver: 13.0.15000.23) and connecting to SQL Server database 2016 (ver: 13.0.5081.1). IntelliSense is not working on my SSMS. I tried the following: Tools >> Options >> Text ...
0
votes
1answer
29 views

SQL Audit Log In Repeats Results

I'm using SSMS's Audit feature to see who's successfully logging in and logging out of the server and I'm currently testing it in a server in which only I have access to it. I used for ...
1
vote
3answers
439 views

How to get all the users on a database with SA access?

I am new to SQL database and besides running basic queries I don't know much. Trying to figure out how to get users with SA access. Can anyone guide me through this, will really appreciate the help.
0
votes
0answers
31 views

Azure SQL database AAD user can't connect

I've read through the documentation and have tried many, many things to get this to work but am still having trouble. The AAD user is a member of a group that has been provisioned Contributor ...
13
votes
2answers
6k views

How to add the Debug button to SSMS v18?

The Debug button is present on this version of SSMS: But it is not present on version 18, preview 4: I have tried in several ways to add the Debug button to my SSMS but not successful. Is there a ...
1
vote
0answers
232 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 ...
0
votes
1answer
835 views

Log-in as service account in SQL Server Management Studio

The stored procedure that performs a CTE in production is being executed using a service account. However, the stored procedure returns empty and I tried checking this using SSMS but I my domain ...
2
votes
1answer
350 views

How do I copy the structure and contents of some tables from one database to another?

How do I copy the structure and contents of the tables below in SQL Server Management Studio from database SNO_TEST to SNO_TMP (on the same server)? The names of the tables are ADMIN_ErrorLog, ...
1
vote
1answer
275 views

Why do LocalTemp table showing with lengthy underscore under Temporary Tables of tempdb in SSMS 2017 Express Edition? [duplicate]

In my Microsoft SQL Server 2017 Express Edition, I have created a local temp table using below create statement, create table #localtemptable (tempid int,tempname varchar(20) ) After creating #table,...
1
vote
0answers
44 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 ...
0
votes
1answer
748 views

How to remove the red squiggly line from IntelliSense for the newly created table or procedure without restarting the SSMS [duplicate]

A newly created table or procedure will always have the red squiggly underline until the SQL Server Management Studio is restarted. Is there a way to get rid of it without re-start the SSMS? Or it's a ...
0
votes
2answers
61 views

Where do I use T-sql for SQL Server? [closed]

I have used SQL Server a fair amount but always with SSMS. I would like to be able to use all the capabilities and understand the environment better but I do not know where I use T-sql. I have tried ...
0
votes
1answer
32 views

SSMS Restore Database Wizard questions while restoring to different destination

I need to pull some data from an earlier backup of a current prod database, so I'm using the SSMS Restore Wizard to run a point in time restore and put it into a temporary restore database (for ...