18,376 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
3 answers

How to restore .bak file to SQL?

I want to create a new SQL database and restore a .bak file to it from a different database.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T14:28:34.9833333+00:00
Gabbard, Art 0 Reputation points
answered 2024-06-20T02:10:06.9933333+00:00
ZoeHui-MSFT 34,581 Reputation points
3 answers

Migrate MSSQL user databases.

Hi, I am about to migrate 1,000 databases from several older SQL installations (2008-2019) to a new SQL Server 2022 environment. Is it recommended by Microsoft to migrate databases by using either backup and restore (log shipping for larger databases) OR…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T11:18:38.2+00:00
Morten Brennebjerg Civitarese Olsen 0 Reputation points
answered 2024-06-20T02:03:13.8633333+00:00
ZoeHui-MSFT 34,581 Reputation points
2 answers

ID's coming back as nulls are not appearing in my data set

I am trying to create a, intergrity check that bring back data after a record has been cancelled after a certain event. In my query. I am joining to a few tables and I can see all the old cancelled record. When I then cancel any new records, some IDs I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
58 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,580 questions
asked 2024-06-19T13:29:32.62+00:00
Kuda 20 Reputation points
answered 2024-06-20T01:25:23.59+00:00
Bruce (SqlWork.com) 59,306 Reputation points
2 answers

indexes - cleanup

Hi All, Need some suggestions on how to disable or drop some of the unused indexes? Regards, Sam

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T05:10:52.2333333+00:00
Sam 1,396 Reputation points
commented 2024-06-19T21:58:43.66+00:00
Erland Sommarskog 103.8K Reputation points MVP
0 answers

How to give an AAD group view only access to a single database within SQL Server with multiple databases

I have a SQL Server in my subscription with multiple databases. Each database corresponds to a client organization. I wanted to give each client read only access to their individual database without them being able to see the other databases. For a…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,151 questions
asked 2024-06-19T01:44:05.8133333+00:00
Abdul Asim 0 Reputation points
commented 2024-06-19T21:55:14.48+00:00
Erland Sommarskog 103.8K Reputation points MVP
1 answer

How do I back up a SQL database to Azure from Microsoft SQL Server Management Studio

I don't have access to the Azure portal to do it from that instance. I need to migrate the database to another server

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,163 questions
Azure Database Migration service
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
505 questions
asked 2024-06-19T21:08:18.42+00:00
Sergio Sanchez 0 Reputation points
answered 2024-06-19T21:37:20.4266667+00:00
Rahul Randive 8,926 Reputation points Microsoft Employee
0 answers

Logic App SQL (V2) - Unable to create connection / 502 BadGateway

Issue Unable to create a Logic App SQL (V2) connection. What I am trying to setup a VNET integrated Logic App (Standard) that will connect to our onpremises SQL database using the SQL (V2) connectors. Architecture Logic App > NSG > Azure…

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,943 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T08:26:46.7866667+00:00
Vetle Kise 0 Reputation points
edited the question 2024-06-19T21:36:07.0066667+00:00
Erland Sommarskog 103.8K Reputation points MVP
1 answer

how does database scoped credential work

I understand how to create and why, but how does then underlying process work? how does the second server know about the credentials created on the first server when using polybase. Our security team want an explanation as we wish to connect an on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T13:08:07.25+00:00
Colin Ferguson 106 Reputation points
answered 2024-06-19T21:27:35.9833333+00:00
Erland Sommarskog 103.8K Reputation points MVP
1 answer

How to modify filepath of datafile that is inside a filegroup? Is it the same approach on alter database modify file directly the file that is inside a filegroup? Or need to do alter database modify filegroup modify file?

How to modify filepath of datafile that is inside a filegroup? Is it the same approach on alter database modify file directly the file that is inside a filegroup? Or need to do alter database modify filegroup modify file?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T19:17:17.9066667+00:00
Michelle Urbano 0 Reputation points
answered 2024-06-19T21:03:59.8566667+00:00
Erland Sommarskog 103.8K Reputation points MVP
0 answers

where do I download a copy of sql server MDM for testing

I AM TRYING TO SHOW A CLIENT WHAT MDM FOR SQL SERVER CAN DO.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T20:25:44.4133333+00:00
Jim Manousos 0 Reputation points
4 answers

Cannot add drive using Failover Cluster Manager - no disks suitable for cluster disks were found

I am creating a new SQL cluster to replace out old cluster. I created a new, two server cluster running Server 2022. I am told I need to add the disk to the cluster before I can install our SQL server software. I created a new volume in our PowerStore.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,440 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
640 questions
asked 2024-02-20T16:28:13.2166667+00:00
Doug V 0 Reputation points
commented 2024-06-19T20:01:29.7133333+00:00
Ben Miller-(DBADuck) 0 Reputation points MVP
4 answers One of the answers was accepted by the question author.

SSMS 20 can't show conflict viewer

Hi! Clicking on View conflicts in Object Explorer open Connect to Server dialog form instead of Conflict Viewer. If I fill in form to connect to the same server, it creates very strange error: A connection was successfully established with the server,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-04-05T12:35:44.52+00:00
Nebojsa Ilic 35 Reputation points
commented 2024-06-19T18:55:39.6066667+00:00
Erin Stellato 516 Reputation points Microsoft Employee
0 answers

Does DMA for SQL keep the source database intact?

I want to run DMA on a 2022 SQL Server. I want to migrate databases currently existing on a 2008R2 SQL server. 2 questions: If migrated successfully, will the source database remain intact and functional? and Is there a way to only migrate one database…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T18:30:55.2966667+00:00
Libby Gregg 0 Reputation points
0 answers

Connection to a managed SQL instance using Microsoft Entra Integrated Authentication

We need your assistance with connecting to a managed SQL instance using Microsoft Entra Integrated Authentication from VM. We're encountering the following error when attempting to connect. This is required for migration of our solution to Cloud. …

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,490 questions
asked 2024-06-19T13:03:52.6933333+00:00
Vishwanath K Bellubbi 0 Reputation points
commented 2024-06-19T18:01:57.0666667+00:00
GeethaThatipatri-MSFT 28,537 Reputation points Microsoft Employee
1 answer

How to update the activation of SQL Server?

Dear All, We have an open value agreement and recently we have added an extra SQL license to the agreement. First, we purchased a license for 4 cores then we added 4 cores. Now, how can we use these new extra SQL Server licenses on the existing SQL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
47 questions
asked 2024-06-19T14:05:36.9733333+00:00
Haitham Al-Haj 0 Reputation points
commented 2024-06-19T17:40:54.8566667+00:00
Olaf Helper 42,561 Reputation points
1 answer

Licensing for read a database master in sql server always on

Good morning, I'm wondering about the licenses to have on the nodes of an Always On cluster. We have the main node and two passive secondary nodes. In order to monitor the good state of a cluster I made a procedure stored in the master database which…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T08:24:33.7166667+00:00
Cédric 0 Reputation points
answered 2024-06-19T17:24:22.69+00:00
Olaf Helper 42,561 Reputation points
1 answer One of the answers was accepted by the question author.

we got alert issue on SQL server

Hello support team, Error : -1 in function sqlconnectionwithretry(SQLConnectionwithretry)) (258) (08001)[Microsoft][OBDC driver 17 for sql server] TCP Provider: the wait operation timed out Pls kindly check my attatch file for detail Thank…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-19T08:41:19.7166667+00:00
Chomnan KHIN 0 Reputation points
commented 2024-06-19T17:23:28.6733333+00:00
Olaf Helper 42,561 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Server blocking

The attached query is causing blocking problems (root blocker) with other SQL statements. Can you please review the attached query and suggest If I need add/or remove indexes to prevent blocking. Please advise. https://easyupload.io/zwcpgi

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-18T05:21:12.95+00:00
PraveenKumar 256 Reputation points
edited a comment 2024-06-19T17:00:23.06+00:00
PraveenKumar 256 Reputation points
0 answers

Does Encryption columns (Deterministic/Randomized) support Merge SQL statement inside stored Procedure? If not, how to replace merge SQL statement with other code?

There are 2- encrypted (Deterministic & Randomized) tables And I am loading data into Table1 via SSIS package. And after that, I am using Stored Procedure to merge data from table1 to table2 based on matches - INSERT, UPDTAE OR DELETE.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
asked 2024-06-18T08:31:32.7833333+00:00
Khwaza Bandenawaz Sikkalagar 0 Reputation points
commented 2024-06-19T15:54:18.6233333+00:00
GeethaThatipatri-MSFT 28,537 Reputation points Microsoft Employee
2 answers

DT_BYTES not able to convert Packed decimal in right format

I get weird result when I convert the ASCII file containing the packed decimal received from upstream system. The data is in form 0x00 0x00 0x00 0x00  0x00 0x97 0xB4 0x62  0x19 0x0A which dosen't seem to me correct ZONED format. Can someone please…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,490 questions
asked 2024-06-18T07:26:12.0633333+00:00
Alkari, Niranjan 0 Reputation points
commented 2024-06-19T14:55:43.88+00:00
Alkari, Niranjan 0 Reputation points