Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
22 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
0answers
38 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
14 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. ...
10
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
20 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
46 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
77 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
53 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
25 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
29 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
22 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
37 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
16 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
68 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
38 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
27 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
46 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
64 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
44 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
0answers
45 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
35 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 ...
2
votes
1answer
35 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
76 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
38 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
26 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
56 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
28 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 ...
4
votes
2answers
114 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
31 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
56 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 ...
1
vote
0answers
76 views

Error cs1567 while installing ms-sql on windows 8.1

I tried to install sql server 2008 and 2012 on my windows 8.1 laptop but at both times i faced with the same error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following ...
-2
votes
1answer
44 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
25 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
26 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
45 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
279 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
11 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
votes
0answers
31 views

SQL Server Authenticated user cannot attach network files

A have a database located on our NAS which is attached to a SQL Server instance on another machine. In Management Studio I can attach the files using a Windows Authenticated User using the below ...
1
vote
3answers
77 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
12 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 ...
1
vote
1answer
234 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
52 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
117 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 ...
-1
votes
0answers
48 views

Access Denied issue, SQL Server LocalDB on Windows Server 2008 R2 SP1

Running SQL Server LocalDB 2012 and 2014 on Windows Server 2008 R2 SP1 VM I have some bizarre issues which don't happen when running on Windows 7 or Windows 10. I can create databases, save data to ...
2
votes
1answer
59 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
114 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
28 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
109 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
56 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 ...