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
0 answers
10 views

Data Lake Setup [closed]

I'm looking to create a data lake with various data points that will feed into the data lake, and I'm looking for the best possible books/guides to accomplish this. I've never set up a data lake ...
user avatar
1 vote
0 answers
43 views

SQL server job agent fails to execute SSIS package, the package runs fine manually

I have a job which executes two packages. Step 1 is a package which is no longer executing under the job agent although it was executing fine before the server reboot. The package executes fine ...
user avatar
0 votes
1 answer
67 views

SQL Server can't create sysname type colunmn

I'm trying to create a new table based on an existing table. In the existing one, there are two columns that are sysname data type. But when I'm trying to create the new one with sysname, SSMS shows ...
user avatar
0 votes
1 answer
34 views

Most recent version of SQL Server Management Studio that works with Windows 7 pre SP1?

I am trying to do some work with SQL Server 2008 (not 2008 r2, just 2008) that is installed on a Windows 7 Pro 32-bit PC. It's just Windows 7 with no Service Pack 1 applied. I have no option to update ...
user avatar
0 votes
2 answers
90 views

SQL Query execution with IN statement

I didn't get proper result Below is my tables values : DECLARE @Id as nvarchar(MAX) = N'''2'',''3''' DECLARE @spparams as nvarchar(max) =N'@Id as nvarchar(max)' EXEC sp_executesql N'select * from ...
user avatar
0 votes
0 answers
16 views

SQL management studio auto update without internet [closed]

We have many SQL servers on which Management Studio is also installed. Due to security issues, these must now be updated monthly. Since the servers do not have direct internet access, I am looking for ...
user avatar
-2 votes
0 answers
90 views

Can we get deleted records back in SQL Server without backup

I have deleted some records accidentally. and I tried to retrieve it with the below query, SELECT [Current LSN],[Transaction ID], Operation, Context, AllocUnitName FROM fn_dblog(NULL, NULL) WHERE ...
user avatar
1 vote
1 answer
85 views

Cannot connect to SQL Server, cannot start SQLEXPRESS service

There are 2 issues at the same time. I cannot connect to the database (SQL Server 2012) using SSMS - I'm getting error 1225 I cannot start the SQLEXPRESS service - getting error 3414 Earlier last ...
user avatar
0 votes
1 answer
13 views

How to generate ER diagram for specific tables in MSDB

I would like to generate ER diagram for tables in MSDB database, but in my SSMS (v18.6) I don't see Database Diagrams folder which is common for other databases. Is it something related to the ...
user avatar
  • 815
-1 votes
0 answers
24 views

OpenRowset vs a direct connection (SSMS) in SQL

I can do this query in an SSMS window directly connected to a database and it takes 5 seconds. Do the same query with OpenRowSet or OpenDataSource and it take exponentially longer 1:10 vs 0:05 Why? ...
user avatar
  • 1
0 votes
0 answers
38 views

Some of databases I had created in the server not displaying in my device in Microsoft SQL Server Management Studio

Some of databases I had created in the server not displaying in my device in Microsoft SQL Server Management Studio but any another device can I tried to delete and reinstall the SQL Server management ...
user avatar
1 vote
1 answer
69 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
0 votes
1 answer
31 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
4 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
4 votes
3 answers
692 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
89 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
84 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
276 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
62 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
212 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
94 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
74 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
29 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
20 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
40 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
36 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
384 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
46 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
66 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
57 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
3 answers
401 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
83 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
126 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
25 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
53 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
56 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
153 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
168 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
94 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
24 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
117 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
30 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
69 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
157 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
15 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
183 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
15 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

1
2 3 4 5
24