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
-2 votes
0 answers
25 views

Azure Data Studio Comment Blocks

I have used nested comment blocks in the past while writing queries using SSMS and never thought about whether or not it was alright. I was giving Azure Data Studio a try and noted that it doesn't ...
user avatar
1 vote
1 answer
43 views

Run MSSQL stored procedures containing SSIS packages using Windows Authentication from another computer

I am new to MSSQL. I have a question about executing MSSQL Stored Procedure. Let me briefly talk about my development environment first: PC400 (Computer/Server A), where SQL Server 2012 is installed ...
user avatar
-1 votes
0 answers
27 views

Can't Change Password On SQL Server Manager Studion 2019

So I have exactly the same problem that someone asked about here. I have an SQL server in SSMS and I'm trying to change the password for the sa Login. I went to its settings and tried to change the ...
user avatar
0 votes
1 answer
26 views

Setting up reporting and alerting in SQL Server through TSQL and Powershell

I am trying to automate monitoring on SQL Server through PowerShell and TSQL, to get alerts through mail whenever some issue is there. I have gone through many articles over the internet and tried the ...
user avatar
0 votes
0 answers
3 views

Is it possible to automate importing vssettings in SSMS?

I have a few settings which I distribute to students as a .vssettings file to be imported into SSMS. Importing the file isn’t too difficult, but I wondered whether it is possible to somehow automate ...
user avatar
  • 2,337
-3 votes
0 answers
35 views

how do i can create columns in sql dynamically?

i have one scenerio which i really want to pull it off in SQL. Scenerio: i have one date column PostMonth, i want to create columns based on this column. suppose i have Postmonth column which contain ...
user avatar
4 votes
3 answers
635 views

SQL Server / SSMS taking up lots of disk space

I installed SQL Server + SSMS for my univ class and ever since then my disk space is going missing (every so often, approx. 3 gb of space goes missing). I strongly suspect SQL Server and/or SSMS to be ...
user avatar
-3 votes
2 answers
76 views

I am facing difficulties in backing up a database in MS SQL Server

When I try to backup a database, it is showing this message : to accomplish this action set property devices. (microsoft.sqlserver.smoextended) I cannot able to select the file location to backup as ...
user avatar
0 votes
1 answer
60 views

Can not login with windows authentication after changing sa and windows passwords

I changed sa and Windows administrators password successfully, I can login to server with sa without any problem, services working normally, database is not corrupted and working without any problem. ...
user avatar
4 votes
3 answers
261 views

Parameterizing the Schema Used by .sql Scripts in Microsoft SQL Server Management Studio

I am running a local instance of Microsoft SQL Server 15 (2019) and am using Microsoft SQL Server Management Studio v18.9.1 (SSMS) as the client to work through the process of creating the tables ...
user avatar
  • 157
0 votes
1 answer
58 views

Corrupted database. How to restore it from an old backup and add newer changes after?

I have a corrupted database with the following error Msg 8952, Level 16, State 1, Line 1 Table error: table 'sys.syscolpars' (ID 41). Index row of index 'nc' (ID 2) does not match any row of data. ...
user avatar
0 votes
1 answer
25 views

Inhibiting results to pane in SSMS (TSQL language) via script

I found that one could use a menu to "discard" results in SSMS (TSQL language). Please see: Original Question about inhibiting results and its answer. However, I was wondering if there is a ...
user avatar
-1 votes
2 answers
117 views

SQL Server Agent not running SSIS package

I have followed many articles to create an SSIS pipeline package, deploy it and schedule it. I'm trying to transfer data from two remote servers, an OLEDB driver that connects to a SQL Server Database ...
user avatar
-1 votes
1 answer
69 views

Taking a weekly snapshot of table and appending it to a separate "history" table. Is this good practice?

I have set up a small project in work. Let's just say it's a list of customers and their "status" which is Gold/Silver/Bronze. Any time their status changes, a new row is created. However, ...
user avatar
  • 109
1 vote
3 answers
68 views

Is there a way to add database encryption on certain columns without changing code base?

I've experienced a few companies that have various different codebases ranging from 20 year old code without the source anymore to 1 to 10 year old code with the source but thousands of database calls....
user avatar
0 votes
0 answers
22 views

Can a SSMS job which runs an SSIS package be resource limited within a virtual server?

I have a SQL Agent job which runs weekly and executes an SSIS package. The job takes over two hours to complete and in that time it consumes over 90% of the server CPU, this means the replication ...
user avatar
0 votes
0 answers
15 views

Saving JSON files in SSMS renders them unparsable?

I have some query that outputs a JSON, i.e., select 1 AS 'test' for json path, without_array_wrapper After clicking on the result, which is {'test':1}, SSMS 18.10 opens a file with the JSON output. ...
user avatar
0 votes
1 answer
34 views

SSMS -- inhibit results or remove temporary files when query is done

I am running several instances of the same query to establish baselines for potential performance optimization. That is, I want to compare timing for two versions of the same query. I am using SSMS ...
user avatar
0 votes
1 answer
33 views

Search for an expression in Redgate's SQL Search

I can find word and terms inside stored proc and database, but I can't specifically search for an expression like WHERE name LIKE '%005%'. Is it possible to do that with the Redgate SQL Search plugin ...
user avatar
  • 11
3 votes
1 answer
302 views

How to change the web browser used by SSMS when you hit Ctrl+Alt+R

When I am running: Ctrl+Alt+R will run the web browser in an SSMS tab. However, this now produces the message: I do have MS Edge installed but SSMS is not finding it. What should I do to help SSMS ...
user avatar
0 votes
0 answers
43 views

Can't connect to SQL Server using its actual server name

I have a SQL Server instance, its actual server name (@@servername) is actual_name, and its alias is alias. When using SSMS to connect, I can only connect using alias, but not using actual_name. ...
user avatar
  • 23
-3 votes
1 answer
65 views

Where to submit bugs for SQL Management Studio 18.x?

Where do we go to submit bugs for SQL Management Studio 18.x ?
user avatar
-4 votes
1 answer
46 views

How to find relations between different tables

I am working with AdventureWorks2019 Full database in SSMS and the problems I am facing are as follows: I cannot find any any apparent connection between different tables of different schemas. For ...
user avatar
0 votes
3 answers
56 views

Find the count of unique FK associated with two or more Col2 values

I’m trying to find a way to get a count of unique foreign keys that are associated with at least two different Col2 values across multiple rows. Example: PK Col2 FK A page1 abc B page2 abc C page1 ...
user avatar
  • 1
2 votes
2 answers
231 views

SQL Server Management Studio throws exception when using Always Encrypted

With the latest version of SSMS (v18.10), when we choose to sign in to Azure to use key vault, it always gives this exception: Rotate (Microsoft.SqlServer.Management.ServiceManagement) And the error ...
user avatar
2 votes
1 answer
62 views

SSMS v18.9.2 Display Estimated Execution Plan returning XML error

From SSMS v18.9.2, when highlight a simple Select query like select * from sys.tables" in the master database (or any database), I get the following message: An error occurred while executing ...
user avatar
  • 61
0 votes
0 answers
88 views

How to connect to MS SQL Server 2019 Instance running in Openshift cluster with SSMS via port-forwarding?

Having: An Openshift Cluster version 4.8.18 running on the Azure Openshift Service A Project in the cluster running a SQL Server 2019 Instance created via oc new-app like so: oc new-app mcr....
user avatar
  • 101
2 votes
1 answer
22 views

Set DB to single-user mode, now I cannot open it in SMSS

In order to allow me to rename a database I set it to single-user mode. The rename worked fine but now trying to open the DB or even view its properties gives me connection errors. I've tried ...
user avatar
  • 121
0 votes
1 answer
51 views

Restoring to .bak process hung up because network path change

I have a SQL Server Agent job that grabs a bak file and restores it to a database on the server (code below). IT added memory and remapped network drives, so the "oldnetworkdrivename" is now ...
user avatar
  • 1
0 votes
1 answer
55 views

SQL Server SSMS - Edit 200 rows functionality - is it possible for two or more people to alter each other's work using this functionality?

Let's consider a scenario: Two or more people are working on a table that stores configuration data for an app. There are multiple configurations in that table, so each person can work on it's own ...
user avatar
  • 339
7 votes
2 answers
143 views

Intellisense automatically disabling with "WITH Inline = OFF"?

In my SSMS (I'm using 18.10) project, I've been frustrated by the fact that Intellisense is not functioning in my files. I had conjectured that it was due to the size of the codebase, but in fact, I ...
user avatar
3 votes
1 answer
2k views

Error starting localDb on Windows 11

I installed Windows 11 on a brand new NUC, then installed all updates. Installed Visual Studio 2022 CE and SSMS (v 18.10) I attempted to start the localDB which is assume was installed as part of ...
user avatar
  • 133
1 vote
0 answers
137 views

SSMS 2016 error "The client and server cannot communicate, because they do not possess a common algorithm"

I am trying to connect a database from SSMS 2016 it gets connected from one machine but other machine with exactly same version SSMS 2016 gives below mentioned issue. Note: on server only TLS > 1.2 ...
user avatar
1 vote
1 answer
75 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....
user avatar
0 votes
0 answers
17 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 ...
user avatar
1 vote
2 answers
113 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 ...
user avatar
  • 11
-2 votes
1 answer
25 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), ...
user avatar
1 vote
1 answer
66 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 ...
user avatar
  • 10.3k
0 votes
3 answers
114 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 ...
user avatar
1 vote
1 answer
14 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 ...
user avatar
0 votes
1 answer
129 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 ...
user avatar
0 votes
0 answers
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 ...
user avatar
0 votes
1 answer
20 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.
user avatar
0 votes
1 answer
38 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 ...
user avatar
1 vote
2 answers
71 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] ...
user avatar
0 votes
0 answers
35 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. ...
user avatar
  • 130
0 votes
1 answer
95 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 ...
user avatar
  • 1
0 votes
1 answer
63 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?
user avatar
  • 1,881
0 votes
0 answers
29 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: ...
user avatar
  • 101
0 votes
1 answer
63 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. ...
user avatar

1
2 3 4 5
24