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
1 answer
980 views

SQL Server User permissions-Hide all tables and give/show access to some views

I am using SQL Server 2019. I have gone through some questions here and not found an answer. I am trying to not to show some tables (with a certain Schema e.g. Structure) for a SPECIFIC user in the ...
SQLserving's user avatar
0 votes
0 answers
36 views

I can't find my database that I have created When I am trying to upload an Excel file using import Export wizard

The issue is when I use sql import export server , When I select a Excel file. In the next step , it does not show the name of the database that I have created and where I want to store my file. It ...
Aman Verma's user avatar
0 votes
1 answer
24 views

Using SSMS - if you have a large list of servers... is there a tip to use a search function to find a "string" in the list of registered servers

Like looking for all of my DEX servers? As opposed to looking/scrolling thru them all.
sherveyj's user avatar
  • 101
0 votes
1 answer
235 views

SSMS v18.10 - Open a script file with existing connection and database

In previous versions of SSMS, if I had a database selected in Object Explorer and then opened a script file through File → Recent Files, SSMS automatically used my existing connection and database. In ...
Sean Gough's user avatar
1 vote
2 answers
91 views

Select * - Why or Why Not?

Is there really any difference between these two queries? SELECT TOP 1000 [COL_1], [COL_2], [...], [COL_n] FROM [database].[schema].[table] SELECT TOP 1000 * FROM [database].[schema].[table] ...
Drew's user avatar
  • 13
0 votes
1 answer
869 views

SSMS Query store keeps getting disabled

I activated query store about a month ago with the settings below. Now, every morning starting up SSMS I find the Query store folder gone and query store disabled. Initially I used 1 Gb size, but ...
mpn275's user avatar
  • 1
0 votes
1 answer
160 views

Is there a way to customize SQL Server Performance Dashboard?

The report in SQL Server Management Studio presents System CPU Utilization broken out by a minute. Is there a way to specify the interval - perhaps by 10 seconds?
AngryHacker's user avatar
  • 1,931
0 votes
0 answers
89 views

Why Sql execution delays sometimes?

I made my project in VB.NET with SQL Server as backend but sometimes SQL query execution delays even from SSMS. I have the following query which I execute every time I want to fetch a product list: ...
bonny's user avatar
  • 101
0 votes
1 answer
2k views

How to recover missing SQL auto-recover files in SSMS (Microsoft SQL Server Management Studio) after unexpected shutdown

SQL Server Management Studio (SSMS) closed unexpectedly. Many SQL files were open. When SSMS was restarted, it did reopen some auto-recover files, but not all of them, especially one in particular. ...
spinjector's user avatar
2 votes
0 answers
6k views

Server is configured for Integrated authentication only [closed]

I'm new to SQL server. I have a very basic idea about it. And on a recent application I needed to use SQL server. But I have to access the db stored on the another computer. So I changed the SQL ...
Tanish Ranjan's user avatar
0 votes
0 answers
114 views

SSMS: Dragging vertical tab group divider and nothing happens

I've searched Google for "ssms vertical drag divider nothing happens" but can't find anything. Am I the only one experiencing this? I'm using both SSMS 17 and 18, as some servers I work with ...
SvendK's user avatar
  • 101
2 votes
2 answers
399 views

In SSMS, are IntelliSense and SQLCMD mode mutually exclusive?

In SSMS, are IntelliSense and SQLCMD mode mutually exclusive? Is there any way to make IntelliSense work when SQLCMD mode is enabled? (I use SQLCMD a lot) I'm trying to understand why IntelliSense ...
spinjector's user avatar
5 votes
3 answers
522 views

Hovering over an Operator in Execution Plans: How to make the tooltip not disappear when moving the mouse

I want to share my screen and show an execution plan but when I hover my mouse over an operator and what to point to something with my mouse in the tooltip then it disappears. Is there a way to make a ...
xhr489's user avatar
  • 805
11 votes
2 answers
26k views

Is there a simple way to add a read-only user?

I have a hosted (shared) SQL Server database and I'd like to add a read-only login. (This login will be used to build Power BI data visualization.) Looking into this, it's far more complex than I ...
Jonathan Wood's user avatar
0 votes
1 answer
3k views

How do I produce the relationship diagram in Microsoft Sql Server?

How do I produce the relationship diagram in Microsoft Sql Server? Here is a visual of what I am talking about here:
xarzu's user avatar
  • 131
1 vote
1 answer
593 views

Configuring Azure SQL Server and SQL DB instance with MFA/2FA for On-premise AD DS synched account

I've synched my OnPremise AD DS users into Azure using Azure AD connect. How can I enable the user of my Azure SQL Server and Azure SQL DB instance to use MFA/2FA when connecting with SSMS using the ...
Senior Systems Engineer's user avatar
1 vote
0 answers
226 views

Generating script of a table with more than 99 rows will append a 'GO' afterwards

I have a Powershell script that will take the schema and data on some of the tables. The relevant script being: foreach ($ScriptThis in $Objects | where {!($_.IsSystemObject)}) { # Scripter object ...
Paul_LayLow's user avatar
0 votes
0 answers
1k views

Permissions to run SQL Server Agent Job

I am getting the following error message: Message Executed as user: fin\jdoe. The server principal "fin\jdoe" is not able to access the database "abc" under the current security ...
Chicken Sandwich No Pickles's user avatar
0 votes
2 answers
690 views

changing SSMS settings via Powershell

in order to enable the dark theme to SSMS (not available on the picture below as you see): following this webpage: SQL SERVER Management Studio 18 - Enable Dark Theme - SQL Authority with Pinal Dave ...
Marcello Miorelli's user avatar
3 votes
3 answers
1k views

How to reset session in management studio tab?

In a management studio tab, suppose I run code that creates a temp table. Now if I re-run this code it gives an error that temp table already exists. I can open a new tab and run this code. This ...
variable's user avatar
  • 3,585
1 vote
1 answer
278 views

How to easily copy SQL Statements from multiple extended events like I used to do in SQL Profiler?

One thing I miss from using SQL Profiler is selecting multiple rows in profiler (looking at Batch Completed and RPC Completed events) and seeing all the SQL in the below panel, i.e. as one combined ...
Rory's user avatar
  • 1,300
0 votes
2 answers
3k views

SQL Server Management Studio 18 setup fails after splash screen

I'm trying to install the latest SMSS version on Win 10. I also had Visual Studio 2017 and Visual Studio 2019 Community, and all .Net runtimes and the DevExpress Framework which came also with some ...
geoalbi's user avatar
0 votes
1 answer
742 views

Performance issue when multiple columns of same table are grouped

I am dealing with large amount of data approx 1 million rows with 100s of columns. I have this proc which performs some calculation over this data based on grouped by a colum1. Now the same ...
Satyendra Routela's user avatar
0 votes
2 answers
1k views

SQL Server Configuration - Disabling the "Allow Remote Connections to this Server" Option

My organization had a security audit and was told that we need to DISABLE the "allow remote connection to this server" option for all of our SQL Servers. What impact would this have on ...
SFDCShark's user avatar
0 votes
1 answer
93 views

SSMS 2014 can't view Indexes on views

In SSMS 2008R2 you can navigate to a Database > Views > Find a specific view that you have an index on and unfurl the Index(es) In SSMS 2014 (possibly other modern versions) you cannot. When you ...
MHSQLDBA's user avatar
  • 224
0 votes
2 answers
2k views

Turn SQL tables into Views - with Dynamic SQL

As the name would suggest, I need to turn a TON of sql tables into views, using dynamic SQL. Motive-wise, it's just a silly workaround to preserve a Legacy program. So far I'm creating a temptable, ...
Sean Gillespie's user avatar
0 votes
1 answer
143 views

Duplicated SQL Server Execution Times For Dynamic Query

I'm getting duplicated SQL Server Execution Times from SET STATISTICS IO,TIME ON with dynamic queries. Is this a normal behavior?
JieLong's user avatar
  • 167
0 votes
0 answers
474 views

SQL Server: Always On Availability Group: getting Error: GetAccountToProcess failed: Cannot open database requested by the login. The login failed

When myself and our SA are testing our AO group, we are running a script that flows data into a table so we can monitor proper data. We are pointing this at our Listener: TestDBAG01, and it flows into ...
dragos_kai's user avatar
0 votes
0 answers
64 views

Cannot modify a job in SQL 2008 R2. The Modify window simply doesn't come up

I created a maintenance plan to perform daily backups with transaction log backups to be scheduled on four hour increments, however, I did not enable the job immediately, nor did I enter add the ...
Tom's user avatar
  • 21
1 vote
1 answer
6k views

How do I preserve leading zeros for varchar field

When saving a number with leading zeros into a string variable or column, leading zeros are truncated. When I run this query: declare @varchar as nvarchar(50) set @varchar = 011 print @varchar The ...
sandhun p.s's user avatar
1 vote
3 answers
2k views

Remote Desktop SQL Server Management Studio Dialog boxes Font size too small

When I connect from my local machine to a remote server through Remote Desktop Connection. And then try to use SQL Server Management Studio, the Dialog boxes in the application for example Connection ...
Naveed Ahmed's user avatar
4 votes
3 answers
7k views

Copy tables to another SQL Server keeping the identity property

Objective I want to make a exact copy of 10 tables from a database on a SQL Server into my local SQL Server. The local copy is used for testing. Problem The copied tables all have the identity ...
baltermia's user avatar
  • 143
0 votes
2 answers
639 views

Database status "restoring..."

I have opened SSMS today, and went to open my database ADMINISTRATOR (in the picture) but this option is unavailable: What's this problem, how can I cancel this restore? I have just added a new ...
developer's user avatar
0 votes
1 answer
112 views

I'd like to make this relational database into a star schema. Any help is appreciated

So basically, I want to make this relational database into a star schema. This would revolve around a sales fact table. Although I am confused as how to do so because there are two ways in which a ...
Yamiraj's user avatar
0 votes
2 answers
827 views

Query a list of objects in each database

I have a list of about 300 Views spread out across several databases. Some of the tables used in the DDL of the views have been dropped or renamed. What I want to do is try to query all 300 views in ...
Chicken Sandwich No Pickles's user avatar
-1 votes
1 answer
40 views

log shipping restore job

System.Data.SqlClient.SqlError: This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY. (Microsoft.SqlServer.SmoExtended)
user avatar
1 vote
1 answer
1k views

Enable Toolbox window in SQL Server Management Studio

I am assuming that the Toolbox windows in SSMS is used to store code samples. So I am able to highlight code in the editor and drag it to the Toolbox window. However, if I wanted to use the code ...
AngryHacker's user avatar
  • 1,931
0 votes
3 answers
58 views

MS SQL Server - Working Mechanism of Top clause

Intro This question is basically asked to understand how the TOP clause works in SQL. Example There is a table Table1 in which there are 10 Million records. If I fire the following query SELECT Top 10 ...
Agent_Spock's user avatar
0 votes
1 answer
131 views

How to determine the fully qualified tablenames of aliased tables, when a specifically named column is used in a stored procedure in SQL Server?

suppose StoredProcedure1 (SP1) contains the following SELECT A.COL1 ,A.COL2 ,B.COL2 ,C.COL5 FROM MYBIGTABLE A INNER JOIN MYSMALLTABLE B ON A.IDCOL = B.IDCOL INNER ...
adolf garlic 's user avatar
0 votes
0 answers
3k views

Using Office 365 as mail server with SSRS 2019 on Server 2019 Azure VM - error message 'Failure sending mail:'

We have a Windows Server 2019 with SSMA 2019 installed. We also use Office 365. in the mail settings I have smtp.office365.com, and a the username and password for an account that is set up in our ...
Riven2061's user avatar
0 votes
1 answer
864 views

Moving SQL MDF and LDF file

Is there a way to move an MDF and LDF file from C drive to D drive? I've tried to run ALTER DATABASE myDb SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE myDb SET OFFLINE ALTER DATABASE myDb ...
Ahmed's user avatar
  • 3
-4 votes
2 answers
501 views

What is a merge log in SQL? How is it structured, and what are its uses? [closed]

While creating merges, I was told of something called a merge log. I have not heard of this before. What is a merge log in SQL? How is it structured, and what are its uses? I appreciate any responses. ...
Nachiket Kulkarni's user avatar
7 votes
4 answers
2k views

Trick to remember which instance I am working with

I work as a BI developer and always switch between different instances on a same server. However, sometimes I forget the right instance and for example may cause to truncate a table on the other. I ...
programmer21's user avatar
2 votes
3 answers
426 views

Shorthand for "UNIQUEIDENTIFIER" data type name?

The data type keyword "UNIQUEIDENTIFIER" is a chore to type. I want a shorthand replacement. At first glance, it seems that SSMS provides two; the words "GUID" and "UID" ...
KevinP's user avatar
  • 105
1 vote
3 answers
5k views

Backup sqlserver 2019 and restore to Sqlserver 2017

I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server. To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
yfr24493AzzrggAcom's user avatar
1 vote
1 answer
207 views

SQL 2019 Linux, slow at GUI fast at sqlcmd/Query Analyzer

Server information OS Redhat 7 Memory 100GB CPU usage 1% User db size 2 gb each on avg total 7 user databases SSMS installed on a jump server Azure Data studio is also installed App Gui on application ...
Shamvil Kazmi's user avatar
1 vote
1 answer
631 views

Kerberos Issue - Anonymous Login

I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection; Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ...
sqllover2020's user avatar
1 vote
1 answer
803 views

Cannot Add "Active Directory - Password" as Linked Server into my SSMS

I'm trying to add Azure Database with Active Directory - Password as Linked Server, but its giving error while login. I'm using Domain account (for e.g. [email protected] and password) These ...
CodeRunner's user avatar
0 votes
1 answer
563 views

SSMS connection to Availability group listener doesn't failover

I've set up an Availability Group on SQL Server (on Azure VMs) and created a Distributed Network Name as the listener for this. (SQL Server 2019 on Windows 2019) If I connect to that listener in SMS ...
MrPurpleStreak's user avatar
0 votes
1 answer
32 views

MS SQL Row-Level-Security out of a Citirx Store Front

I’m looking for either a solution, or a definitive answer that what I want to do can’t be done. My situation: I have a MS Access Front End that is located in a Citrix Store Front. The Front End ...
rohrl77's user avatar
  • 99

1 2 3
4
5
26