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

Why can't binary data be inserted/displayed as ones and zeroes?

If I have a column of type binary or varbinary, I imagine the data as a sequence of bits. For example, it makes sense to me that 01001 (as a base 2 number) could be a valid value in a binary(5) column....
0
votes
0answers
6 views

Template Browser in Management Studio blank

I created some templates in SQL server management studio using the UI. All my templates go into the their own folder within the template Browser. The folder is prefixed with '1' so it is on the top of ...
1
vote
2answers
100 views

In SQL Server the backup file is around 190 gb, but when restore the log needs around 2 TB space

From the production the database is backed up automatically every day full backup and every 1 hour for transactional backup. A test server was prepared and I want to restore the latest full backup to ...
-2
votes
1answer
20 views

Getting an error while creating stored procedure

When I tried to create the following procedure, I get an error that the must declare scalar variable username. How do I resolve this error? Create procedure sp_addagent @username varchar(50), ...
1
vote
1answer
60 views

Cannot script stored procedure while restoring another copy of current db

I have some large DB that I need to restore to another db from time to time, this process take some time to conclude. The annoying thing I found out in last version of SSMS is that I cannot script any ...
0
votes
3answers
92 views

Is there safe way to remove a .ldf file without losing database data? [duplicate]

I have a database which in stuck "in recovery" mode. The .ldf file is very large and the free disk space is very low. I suspect that the large size of the .ldf file is causing the database ...
1
vote
1answer
9 views

Publication Properties window in SSMS hung when attempting to update

We have a SQL 2012 Database that is mirrored. It also has one publication with 3 subscribers. After a problem occurred (a view that couldn't replicate) during a snapshot push to one of the ...
0
votes
1answer
39 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 ...
0
votes
0answers
13 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 ...
0
votes
1answer
18 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.
0
votes
1answer
28 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 ...
1
vote
2answers
68 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] ...
0
votes
0answers
20 views

SQL Server Management Studio 18.9.2 Registered Servers Query Error The server is not connected"

Today when I attempted to query more than one database instances using SSMS Registered Servers the error message, "Cannot execute script. the server is not connected (SQLEditors)" was throw. ...
0
votes
1answer
46 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 ...
0
votes
1answer
38 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?
0
votes
0answers
25 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: ...
0
votes
1answer
18 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. ...
1
vote
0answers
191 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 ...
0
votes
0answers
24 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 ...
0
votes
0answers
19 views

Give SQL Server DB Login permission

I have SQL Server 2017 instance with many databases, as an example, I have a database on this instant called DB_A, and I want to create a SQL Server user account to log in to this database (I will ...
2
votes
2answers
27 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 ...
5
votes
3answers
352 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 ...
0
votes
2answers
45 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 ...
0
votes
1answer
56 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:
1
vote
1answer
106 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 ...
1
vote
0answers
40 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 ...
0
votes
0answers
149 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 ...
0
votes
2answers
51 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 ...
2
votes
3answers
157 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 ...
1
vote
1answer
50 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 ...
0
votes
2answers
919 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 ...
0
votes
1answer
74 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 ...
0
votes
2answers
70 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 ...
0
votes
0answers
109 views

SSMS Object Explorer The semaphore timeout period has expired

I'm having an issue connecting to a remote instance in SSMS. When trying to connect using the Object Explorer I get the following error message. A transport-level error has occurred when receiving ...
0
votes
1answer
52 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 ...
0
votes
2answers
71 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, ...
0
votes
1answer
35 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?
0
votes
0answers
35 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 ...
0
votes
0answers
38 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 ...
0
votes
1answer
332 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 ...
0
votes
1answer
308 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 ...
3
votes
3answers
310 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 ...
0
votes
2answers
75 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 ...
0
votes
0answers
18 views

Not able to select secondary replica using failover wizard during manual failover

When I am performing failover using ssms 18.6 GUI from primary to secondary replica the replica selection box is disabled. The same task i can able to do using other version of ssms. My team members ...
0
votes
1answer
55 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 ...
0
votes
2answers
73 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 ...
-1
votes
1answer
25 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)
1
vote
1answer
135 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 ...
0
votes
3answers
44 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 ...
0
votes
1answer
39 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 ...

1
2 3 4 5
23