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.

1
vote
0answers
21 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
36 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
23 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
53 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
17 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
66 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
30 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
53 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
24 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
37 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
18 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
22 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 ...
-5
votes
0answers
38 views

Creating Master Slave Relationship on SQL Server 2017 (v14.x) using only SQL Server Management Studio [closed]

I have run into an issue where I have a database that I need to replicate on another server (readonly). I've never created a Master, Slave relationship. I don't have remote access to either server, is ...
0
votes
0answers
30 views

SQL SMS: Use T-SQL Editor instead of Plain Text Editor

In SQL Server Management Studio, right clicking a table shows options to "Select..." or "Edit..." rows. I'm not sure if I have my terms correct, but choosing "Select..." opens what I believe is a "...
0
votes
1answer
41 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 ...
3
votes
1answer
240 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 ...
0
votes
0answers
23 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
60 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
35 views

How do I generate SQL scripts in UTF8 encoding?

When I generate SQL scripts for a given database, output files are encoded in UTF16-LE. Is there any way to generate them using UTF8 encoding?
0
votes
0answers
8 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
153 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
34 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
63 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 ...
0
votes
0answers
36 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
53 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
99 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
76 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
55 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
0answers
23 views

SP times out when run via IIS but executes in 1 second when run in SSMS [duplicate]

I have a problem where a particular stored procedure takes about 1 second to execute when I call it manually from the SQL Server Management Studio, but when it is called by ASP.NET via IIS (this is ...
0
votes
1answer
26 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 ...
0
votes
2answers
29 views

What does this margin symbol in the SSMS text editor mean?

While editing text in SSMS I mistakenly pressed a random keyboard combination, which I think began with Ctrl-K, and found this diagonal arrow symbol appeared in the text margin where the breakpoints ...
1
vote
3answers
89 views

List all users on SQL Server for auditing

I'm using SQL Server Management Studio 17 and I'm trying to list all the users for auditing in an organized way with mentioning their database name. I tried the query below but it's showing the ...
0
votes
0answers
82 views

Microsoft SQL Server Management Studio is busy doing internal operations

I have SQL Server 2016 Standard Edition SP1 and RAM, CPU all are normal when I got this message. Backups are running fine. The database size is 2 TB and I want to expand the database from SSMS, but ...
1
vote
1answer
98 views

Restoring development database from production backup triggered production database to restore as well

We backed up our production database to restore our development database. When we restored our development database from the backup it triggered the production database to restore as well. The ...
1
vote
2answers
46 views

sp_spaceused reveals 0 rows but 72 KB of reserved space

When I run sp_spaceused dummybizo I get the following results: name rows reserved data index_size unused dummybizo 0 72 KB 8 KB 8 KB 56 KB I am expecting the ...
0
votes
2answers
37 views

Granting a SQL Server database only user execute on xp_instance_regread fails

So I'm not finding an answer to my specific issue. SQL Server 2012 database SSMS 17 admin tool Log on as a database (not domain) user foo. Receive sys.xp_instance_regread no permission errors. In ...
0
votes
0answers
177 views

SQL Server stored procedure not working when being executed from code

I have a stored procedure in SQL Server 2016 that runs fine when it is run in SSMS, when this command is used: exec UPDATEUser @user_id = 2, @first_name = N'john', @...
1
vote
2answers
57 views

running many CREATE VIEW and GRANT SELECT statements in one execution

Is there a way to run multiple CREATE VIEW commands and/or multiple GRANT SELECT commands by hitting F5 in SQL Server Management Studio? If so, how can I do this?
1
vote
1answer
47 views

SQL Batches and the GO command: which parts of my script failed?

I executed a script that had multiple sections, separated by the GO command, something like this: Use DB1 GO ALTER TABLE foo ADD bar VARCHAR(10) NULL UPDATE foo SET bar = 'nananana' ALTER TABLE foo ...
0
votes
1answer
68 views

Cannot connect to SQL server through SSMS from other machine after IP change [closed]

There was an ip change on the sql server and after that I cannot connect from other machines ssms but can connect locally . The firewall is disabled on the server and moreover its listening on port ...
1
vote
2answers
114 views

ODBC Driver for Salesforce: Access Linked Server Object in SSMS

I have problems to access a linked server for a Salesforce ODBC data source with our MS SQL Server 2016 (Standard 64-Bit) using the Devart ODBC Driver for Salesforce in SSMS and SQL Studio Management ...
0
votes
1answer
35 views

SqlLocalDB.msi and DBNETLIB / PowerShell SqlServer ServerConnections

I'm trying to setup a development SQL server using SqlLocalDB.msi which installs a local version of SQL Server 2017. I can connect to the SQL engine with SSMS (v14.0.17277.0) using MDAC (v10.17134.1)....
0
votes
1answer
76 views

SSMS 17.8.1 Error: Accessing SQL Server logs

I am experiencing an error when I am trying to access the SQL Server Logs through SSMS 17.8.1 for SQL 2017. I click to expand the SQL Server Log folder in SSMS and I get the following error. How can ...
-1
votes
1answer
25 views

data translating issues [closed]

I have these two table here in ssms: one is called client table, which have a column called city, and it is really city name, like new york, etc. Another table is called city table, it has city's ID ...
1
vote
3answers
81 views

Cant restore database from A to B using any method in SSMS GUI

I have two databases. One is production (A), the other is development (B). I use to be able to restore database from a backup.BAK file of A in B by using SSMS > right clicking databases > restore ...
0
votes
1answer
31 views

SSMS crashes when attempting to create a database diagram

I'm currently using the latest version of SSMS (17.8.1) on windows 10 and everytime I try to create a database diagram it crashes without giving me any error message. I've already tried to re-install ...
1
vote
0answers
235 views

SQL Server was unable to communicate with the LaunchPad service

I have run the below code: execute sp_configure 'external scripts enabled'; and it is giving me the output as: name minimum maximum config_value run_value external scripts ...