17,904 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
3 answers One of the answers was accepted by the question author.

Is support for SQL data queries in Excel being phased out?

I was told today by my IT department that I'll have to stop using Excel with SQL data queries to pull data directly into Excel from a SQL server. They stated that Microsoft was phasing out this feature. I couldn't find anything searching the Microsoft…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,457 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,797 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2024-04-19T19:34:52.87+00:00
Colin Sachs 40 Reputation points
answered 2024-04-22T15:44:42.1933333+00:00
Colin Sachs 40 Reputation points
3 answers One of the answers was accepted by the question author.

SSRS Going Away?

I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,797 questions
asked 2024-04-19T19:31:42.4666667+00:00
Colin Sachs 40 Reputation points
answered 2024-04-22T15:44:23.57+00:00
Colin Sachs 40 Reputation points
2 answers One of the answers was accepted by the question author.

best approach to migrating a table from system to another

I have a test system where we update entries on a table for cross refence purpose and was wondering the best approach for this.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 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.
494 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.
41 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2024-04-19T19:52:02.5533333+00:00
Jonathan Brotto 40 Reputation points
accepted 2024-04-22T13:09:20.73+00:00
Jonathan Brotto 40 Reputation points
2 answers One of the answers was accepted by the question author.

Determine SQL Licensing Type after installation

Hello, From the Microsoft Volume Licensing Center, I downloaded both Server/Cal and PerCore SQL Server 2022 Standard Edition download (ISO) files and placed them in separate folders, not realizing they were saved with the same name. A coworker installed…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-03-28T15:59:59.69+00:00
Bela de Souza 20 Reputation points
edited a comment 2024-04-22T11:43:33.4966667+00:00
Bela de Souza 20 Reputation points
2 answers

How to use Localhost (On-premise database) as sink in Azure Data Factory? It's possible to have source as On-premise database but why not as "Sink"?

I want to use my local database on-premise as "SINK" in Azure Data Factory. It's possible to have it as a "Source" using self-hosted-integration-runtime but why not as a "SINK"???

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,360 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.
12,691 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,523 questions
asked 2024-04-21T14:04:29.1+00:00
Abhinandan Shrestha 20 Reputation points
answered 2024-04-22T11:06:25.9266667+00:00
Harishga 3,260 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

where to download sql server 2022 for upgrading existing sql

where to download sql server 2022 for upgrading 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.
12,691 questions
asked 2024-04-22T10:18:26.92+00:00
Dannie Rothmann 20 Reputation points
commented 2024-04-22T10:53:55.24+00:00
Dannie Rothmann 20 Reputation points
1 answer One of the answers was accepted by the question author.

In ADF, how to get data for specific month

In ADF , dataflow source is dataverse table and move data to sql table depending upon the column created on ( 01.01.2024 to 31.01.2024) We are using filter activity but it's not suitable for this I got error while running the pipeline, "Operation 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.
12,691 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,523 questions
Microsoft Dataverse Training
Microsoft Dataverse Training
Microsoft Dataverse: A Microsoft service that enables secure storage and management of data used by business apps. Previously known as Common Data Service.Training: Instruction to develop new skills.
4 questions
asked 2024-04-17T15:58:19.6333333+00:00
Prakash Durairaj 20 Reputation points
commented 2024-04-22T09:57:11.7733333+00:00
Amira Bedhiafi 15,056 Reputation points
1 answer

SQL server backup in a 2019 VM to s3 using backup URL

Hi I have set up a Windows Server 2019 VM with SQL server 2016. I want to take the backup of SQL server in AWS S3. It should have monitoring and auditing capability and cost effective and secure. I have looked at below…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,112 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,361 questions
asked 2024-04-18T04:47:01.0433333+00:00
Pradeep 21 Reputation points
commented 2024-04-22T08:37:59.7866667+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SQL database growth report

How to Generate SQL Database Growth Report Day wise report. SQL Server 2016 SE

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2021-09-20T08:56:14.407+00:00
Devendra Kumar Sahu 236 Reputation points
commented 2024-04-22T08:23:48.92+00:00
Venkatesulu Akula 0 Reputation points
1 answer

dbnetlib connectionopen (seccreatecredentials) ssl security error

Hi, am getting the error message when trying to connect using the ODBC driver: Connection from: windows server2016 standard Target: MS SQL Server 2012 For your advice please.. thanks! connection error.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-04-19T11:25:56.6466667+00:00
Shah 0 Reputation points
answered 2024-04-22T07:27:00.1433333+00:00
MikeyQiao-MSFT 485 Reputation points Microsoft Vendor
3 answers

How to subscribe to Microsoft for CU updates

I will like to subscribe to Microsoft so that I can get the latest CU patches immediately Microsoft have a release. How do I go about this? Please can someone send the SPECIFIC LINK to get this done

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-04-15T14:05:36.84+00:00
Martins 0 Reputation points
commented 2024-04-22T07:04:38.95+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
2 answers

How to Fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

I am doing a Import Data from an Excel spreadsheet to a table. I get the following message : Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. What will resolve this error?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-04-12T15:06:30.7966667+00:00
Steve Clark 21 Reputation points
commented 2024-04-22T07:03:53.44+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
2 answers

connect to server

TITLE: Connect to Server Cannot connect to.... ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-04-11T17:37:27.1566667+00:00
KKIRUI 0 Reputation points
commented 2024-04-22T07:03:21.1966667+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
1 answer

Use SSMA for DB2 to Migrate AIX DB2 11.5.9 to SQL Server 2019

Is it possible to use the SSMA tool to migrate an AIX DB2 (Big endian) to Windows SQL Server 2019 (little endian)?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 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.
494 questions
asked 2024-04-09T20:16:55.67+00:00
Robert Carter 0 Reputation points
commented 2024-04-22T07:02:44.23+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
1 answer

MSSQL SMS export error

We are working on automation through AutoHotkey. When selecting the data source when exporting from MSSQL SMS, if you select SQL SERVER NATIVE CLIENT 11.0 with the mouse, the export to Excel, etc. works fine without any problem. If you pass the FLAT 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.
12,691 questions
asked 2024-04-03T01:48:51.9266667+00:00
윤석 차 0 Reputation points
commented 2024-04-22T07:01:13.5966667+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
1 answer

Nightly snapshot causing SQL Server backups to break in Veritas NetBackup chain

We are experiencing issues with the backup chain being interrupted by a VM snapshot backup. Our regular SQL backups are sent to NetBackup, and we want to maintain the backup/restore chain within NetBackup without the need to interrupt it with a snapshot…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-04-01T02:13:44.51+00:00
Vanitha Dodla (MINDTREE LIMITED) 40 Reputation points Microsoft Vendor
commented 2024-04-22T06:58:43.04+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
2 answers

SQL tables always disappear after close the program

*** Solved Problem *** I recently upgraded SQL Server Management Studio from version 19 to 20 a few days ago and encountered an issue. After creating a database and subsequently a table using the 'CREATE TABLE' command in a query, everything appeared to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-03-31T00:40:17.98+00:00
Xanakone SYPHANTHONG 0 Reputation points
commented 2024-04-22T06:57:46.9733333+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
2 answers

regular full backup on secondary replica

In Availability Groups(AG), can we take regular full backup on secondary replica

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-03-30T13:55:56.43+00:00
Chaitanya Kiran 696 Reputation points
commented 2024-04-22T06:56:48.52+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
2 answers

Assembly 'system.net.http, version=4.0.0.0' was not found in the SQL catalog error

I created a SQL C# CLR Stored Procedure project and when trying to publish it the SQL Server (15.0.4335.1) I got this error: (47,1): SQL72014: .Net SqlClient Data Provider: Msg 6503, Level 16, State 12, Line 1 Assembly 'system.net.http, version=4.0.0.0,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-03-29T14:32:39.2433333+00:00
Nguyen, David V 1 Reputation point
commented 2024-04-22T06:55:09.1266667+00:00
LucyChen-MSFT 870 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Does ms sqlserver support JWT or client certificate authentication

We are using JDBC and ODBC to connection MS SQL Server authenticated by user name and password, but from security requirement we need to find a more secure client authentication method. Does SQL Server support client certificate or JWT client…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
asked 2024-03-25T09:57:05.8633333+00:00
Gong, Allen 25 Reputation points
accepted 2024-04-22T06:54:44.4666667+00:00
Gong, Allen 25 Reputation points