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
17 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)
0
votes
1answer
38 views

How to 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
39 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
36 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 ...
0
votes
0answers
54 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 ...
0
votes
1answer
52 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 ...
-4
votes
2answers
45 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. ...
6
votes
4answers
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 ...
1
vote
3answers
60 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" ...
0
votes
3answers
86 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 ...
1
vote
1answer
52 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 ...
1
vote
1answer
41 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'. ...
0
votes
1answer
42 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. abc@my-domain.com and password) These ...
0
votes
1answer
46 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 ...
0
votes
1answer
29 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 ...
0
votes
1answer
43 views

Cannot find sqlserver service

I installed Sql Server 2019 in Windows PC. In Sql Server Configuration Manager into SQL Server Service I stopped all the instances. But still I can loggin to Sql Server via SSMS.why is that? Where is ...
1
vote
1answer
48 views

Login to local db with ip

I install sqlserver and login with SSMS with windows auth. and server = DESKTOP-XXXXX\MSSQLSERVER01 When I tried to connect with 127.0.0.1 ot 127.0.0.1:1433 I can't I put into TCP/IP but still I can'...
0
votes
1answer
21 views

Setting Up Multi-Server Administration---SQL Server Account

I am trying to set up Multi Server Administration so that I can easily update multiple instances of the same database across our network with ease. Where I am getting lost is how to set up the SQL ...
0
votes
1answer
33 views

Query to list all the databases that have a specific user

I need to form a query that lists all the databases that include the words 'PRD' that have a single specific user name 'user_1' So far I have this query: select name as username, create_date, ...
-4
votes
1answer
36 views

Check If Today Is First Of Month [closed]

On my search engine I have seen multiple results to get the first day of a month, but I want to do something slightly different. In SQL 2016, I want to check if Today GetDate() is the first day of ...
2
votes
3answers
407 views

Where does the stored procedure Searchinall come from?

When I create a new database in SSMS either using the creation wizard or the CREATE DATABASE command the database will contain a stored procedure called Searchinall. This procedure has never been ...
1
vote
1answer
22 views

Installing SSIS package outside of SSIDB catalog

I'm trying to simplify deployment of SSIS package to a remote server. At the moment, I have Local Visual Studio SSDT and SSIS package that has 4 connection managers - DEV environment Remote server ...
-2
votes
2answers
58 views

Can not connect Database to

I'm trying to connect my server to MS SQL Server Studio but keep on getting an error. On this post I saw that I can use PowerShell to get more information on what the SQL Server is doing. It seems ...
0
votes
3answers
62 views

Allow user to create databases on server and to see only the databases that are created by him, without creating login first

I want to implement the following use case using C# application and MS SQL Server Express 2014. I have a centralized database server in which there are already created some database (which have the ...
0
votes
1answer
102 views

SSIS cannot deploy package to SQL server - An error occurred during decryption 15466

After recovering and re-importing a backup of a SQL Server 2019 instance none of my SSIS packages will deploy from Visual Studio. Whenever I try and deploy I get the error =============================...
0
votes
1answer
50 views

SSMSBoost intellisense not working? [duplicate]

SSMS Version 17.9.1 It looks like the intellisense may not be working? Shouldn't it auto complete Select etc? Also, it looks like the intellisense is from SSMS itself (doesn't work that great) I've ...
1
vote
1answer
56 views

SSMS Not showing Status and Scheduled Jobs Not Running

Recently in SSMS, I have started getting a blue question mark next to the database and SQL Server Agent, when previously all was showing running. At the same time my scheduled jobs have stopped ...
0
votes
0answers
21 views

What could cause a slow DB connection between AWS and Azure?

Currently we are running with a piece of middleware and our SQL server in AWS. We are looking to move to Azure SQL managed instance. But I am experiencing severely increased insert times when using ...
3
votes
2answers
379 views

Import local data to remote server for SQL Server

I currently have a machine A with SQL Server Management Studio (SSMS), and a data file on it. A connects to machine B's SQL Server database. I have no control of machine B. The problem is: I can't ...
0
votes
2answers
84 views

how to add a user to local sql server when one has only windows admin rights on the server

I'm in the admin group of a server, but yet I don't have access to the sql server, is there anyway to add myself without the need to reinstall the sql server?
0
votes
2answers
43 views

Can't Dump Database Because MS SQL Server Management Studio Won't Show Any Databases If 1 Is Permission Denied

I am logged into SQL Server Management Studio with an account that has access to multiple databases, but not DB_123. As shown in the picture below, clicking to expand the "Databases" folder ...
2
votes
3answers
53 views

How to find column which causing “Conversion failed” error

I've run into quite a lot of issues specially when it comes to conversion errors: convert(datetime, [fieldname]) or SELECT CAST([field2] AS int). Imagine a large select statement with 30+ conversion ...
1
vote
2answers
37 views

lock escalation issue when using DDL trigger

I have a problem, I am trying to create a log table for my database so I can keep track of changes. I have created the following trigger that runs when a table is altered, created and dropped: CREATE ...
0
votes
0answers
14 views

How to restore and overwrite an existing database on Azure SQL MI [duplicate]

We are trying to restore a backup file in Azure SQL MI using SSMS. the issue is we are trying to overwrite an existing database and we notice this feature is not present in SSMS for Azure SQL MI but ...
0
votes
1answer
25 views

How to block SSMS from accessing the internet?

How do I block SQL Server Management Studio from accessing internet sites? Let me set the stage. I'm sitting behind a Bluecoat proxy server at work. We have a management policy forbidding us to ...
2
votes
1answer
128 views

Source Database of a restore stuck Restoring

I have copied a database vn_Budget_2021_BofDOct29 to the database vn_Budget_2021_Rig2. I did this through Tasks->Restore Database shown in the second image. I saw this similar issue except the ...
0
votes
0answers
17 views

Failing to connect to Integration Service with SSMS on one VDI but on another it works fine

I have two VDIs with the exact same version of SSMS installed. On one, I can log into the standalone Integration Service of a remote server running SQL Server 2017, on the other I cannot. Every ...
1
vote
2answers
123 views

How does SSMS display varbinary data?

When you store a .jpg file in a varbinary(max) column and then view the data in SQL Server Management Studio, it appears like "0xFFD8FFE000..." Is this Hex Encoded or something? What is SQL ...
0
votes
1answer
34 views

Is there a way to disable / disallow someone from using View Creator using Diagram Tool in SQL Server?

We have a lot of DB and BI analysts who regularly create views. Some folks create these views using SSMS' view creator which allows someone to drag and drop tables. This creates a lot of problems when ...
0
votes
2answers
87 views

How to increase agent history rendering timeout in SSMS?

We keep only 30 days of SQL agent job history but due to the frequent execution of jobs, SSMS will experience the following timeout error when trying to view history for a given job: Execution Timeout ...
0
votes
1answer
30 views

Dynamic execution query produces error when called from the procedure, but works when executed manually

create procedure createTable(@tableName varchar(25), @columnName varchar(25), @columnType varchar(25)) as begin declare @sqlQuery as varchar(MAX) set @sqlQuery = 'create table ' + @...
1
vote
1answer
47 views

SSMS Template Browser Add-In development

Okay, I’m trying to do something that I just can’t seem to get accomplished and I haven’t found anything online to address this request. In the “Template Browser” I want to add another category of ...
1
vote
1answer
193 views

Why Sql Server management studio use English regional settings instead my local Windows settings?

Scenario: I've a Sql Server instance on English Windows Server. But I've my own ITALIAN client with Sql Server Management Studio and SSMS regional settings set to Italian. So when I extract data, i ...
2
votes
1answer
45 views

Every person has a contact info table and every contact has an address

so i'm still in the design phase of this database. Anyways, every person, whose PK is their name, has a FK to a contact table then I'm very confused as to what's next as every contact table contains a ...
-4
votes
1answer
39 views

Error when running query as a subquery [closed]

The inner query runs successfully alone, but when I run it as a subquery, an error pop up. My query: Select TOP 3 * FROM (select fr.rating , sp.SpId ,sp.FName ,sp....
0
votes
2answers
23 views

Cannot Find Job Associated Active Email Notifications

We have a email notification going via our SQL Server however I cannot find any job or setting associated with it. Its definitely the correct server and I am logged in as admin. The email is sent via ...
0
votes
1answer
48 views

BFS Traversal In MSSQL

I have been trying to write queries so that I can get the BFS & DFS traversal of the tree. I am getting the DFS preorder traversal right but unfortunately, I am not able to get the BFS part right. ...
0
votes
1answer
7 views

How to get SSIS to stop waiting/processing at task above time limit?

So I have a couple SSIS packages that are run sequentially, scheduled through SQL Server Agent. Right now, I'm getting some errors where certain input data steps just wait indefinitely-- i.e access ...
1
vote
1answer
15 views

Is there a plugin to add a map behind the spatial results?

Using SSMS 18.5.1 and dealing with spatial results. I would like to visualize this data against a map of the world using Google Maps, Bing Maps, or any other mapping software. Is there a plugin or a ...
0
votes
1answer
86 views

Clustered Index during data load in MS SQL Server

Until today, I was under impression that it's been considered as a best practice to disable the indexes in sql tables during the data load. And with the fact that one cannot disable the clustered ...

1
2 3 4 5
22