18,069 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

Custom skill integration Azure AI Search

0 I have a requirement to crawl an Azure SQL server from Azure AI search. The SQL server exists in different VNET and I have created a Shared Private Link to connect. The Indexer works fine without any problem. As soon as I add a custom webapi skill the…

Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
736 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,834 questions
asked 2024-05-15T18:18:35.6533333+00:00
Somdeep Niyogi (external) 1 Reputation point
commented 2024-05-16T05:40:24.8466667+00:00
Somdeep Niyogi (external) 1 Reputation point
1 answer

We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work

Hi We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work. We have come across documention which says its has limitations onwiht regards to publisher/subscriber and…

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,834 questions
asked 2024-05-15T17:41:11.7933333+00:00
Nitya V 20 Reputation points
answered 2024-05-16T05:35:53.2466667+00:00
MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
1 answer

How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11

Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…

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,834 questions
asked 2024-05-10T13:49:21.6766667+00:00
Dhamodharan M 0 Reputation points
edited a comment 2024-05-16T04:56:42.0266667+00:00
Dhamodharan M 0 Reputation points
1 answer

Exception problem

Hi, I've got issue due to this line below. reader = cmd.ExecuteReader(); Can it be owing to no record returned?

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,834 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,333 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2024-05-10T08:22:21.91+00:00
Peter_1985 2,526 Reputation points
commented 2024-05-16T03:33:51.0466667+00:00
Jiale Xue - MSFT 34,501 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

SQL Server 2016 RTM feature

Hello, Does SQL Server 2016 RTM support Table Partitioning? Thank you.

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,834 questions
asked 2022-11-17T06:10:38.533+00:00
Lee John Li 21 Reputation points
accepted 2024-05-16T03:17:14.12+00:00
Lee John Li 21 Reputation points
1 answer

Transferring SQL Express database from Primavera P6 15.2

I have a SQL express database on SQL server 2014 with nearly 10 GB of size. While to backup the database and transfer it to a new laptop windows 11 installed with Primavera P6. It is facing error on Bad private user name or password. Check the public…

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,834 questions
asked 2024-05-16T00:18:13.3033333+00:00
huang jin yao 0 Reputation points
answered 2024-05-16T03:02:37.2566667+00:00
CosmogHong-MSFT 23,406 Reputation points Microsoft Vendor
1 answer

Emoji Rendering Issues in SSRS-Generated PDF

I'm encountering issues with emoji representation in PDF and PowerPoint outputs from SQL Server Reporting Services (SSRS). Despite successfully displaying emojis in Word documents that are rendered through SSRS, the same emojis are not appearing…

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,817 questions
asked 2024-05-15T15:48:05.93+00:00
Abdullah Riaz 0 Reputation points
answered 2024-05-16T02:56:24.8966667+00:00
ZoeHui-MSFT 33,386 Reputation points
1 answer

I can't start the MSSQLSERVER on new esxi host

I am a student currently studying virtualization and SQL installation for one of my projects apkbeb. After obtaining approval from my instrcutor, I attempted to transfer a virtual machine (VM) to my personal laptop apkbeb.However, upon doing so, 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.
12,834 questions
asked 2024-05-07T11:39:26.0633333+00:00
ahmedbark 0 Reputation points
commented 2024-05-16T02:37:27.7033333+00:00
LucyChenMSFT-4874 1,280 Reputation points
2 answers

Error description: The system cannot find the path specified while installing SQL server management studio

I am facing an error while installing Microsoft SQL Server 2022, In the log file the error says : Component name: SQL Server Database Engine Services Instance Features Component error code: 0x80004005 Error description: …

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,834 questions
asked 2024-05-06T16:23:40.68+00:00
Nikita Gaur 0 Reputation points
commented 2024-05-16T02:36:43.46+00:00
LucyChenMSFT-4874 1,280 Reputation points
2 answers

How to fix this error in Microsoft SQL: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query timeout expired...

Hello, Kindly advise how to solve below issue: we have one job that's failing is Microsoft SQL. This issue is affecting the Power BI reports as well. Below error is found: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,752 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,834 questions
asked 2024-05-04T22:07:43.62+00:00
Aya 0 Reputation points
commented 2024-05-16T02:35:44.1033333+00:00
LucyChenMSFT-4874 1,280 Reputation points
1 answer

Do ODBC Linked Servers (MariaDB) support XA Transactions?

My setup involves 3 servers, 2 MariaDB servers -- one under my control, the other not -- and an MSSQL server. I have the two MariaDB servers linked via the Spider Engine and I have my internal MariaDB server set up as a linked server in Sql Server with…

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,834 questions
asked 2024-05-03T20:31:26.51+00:00
Evan Howlett 0 Reputation points
commented 2024-05-16T02:35:02.8433333+00:00
LucyChenMSFT-4874 1,280 Reputation points
2 answers

SQL Licensing for SQL Always ON Availability group

Hello Guys, I need to understand how many licenses i need to buy for SQL always on availability group, below is my requirement. As per my understanding only active cores should be licensed SQL always on cluster    Primary site:   Server 1 : Active copy  …

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,834 questions
asked 2024-05-02T06:33:28.6+00:00
mohammed arifuddin 25 Reputation points
commented 2024-05-16T02:33:41.9833333+00:00
LucyChenMSFT-4874 1,280 Reputation points
1 answer

SSRS - Unable access the Report Server Web portal URL's

We have SQL Server Reporting Services. Nothing has been changed but users are not able to access to Reports Web URL. We are unable to access the URL on the same machine where the Report Server Configuration Manager is running. Checked the SQL connection…

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,817 questions
asked 2024-05-01T07:49:37.3766667+00:00
Yashwanth Bellum 0 Reputation points
commented 2024-05-16T02:31:59.9066667+00:00
LucyChenMSFT-4874 1,280 Reputation points
1 answer

SSRS is restricting excel report to 35 tabs.

SSRS is restricting excel report to 35 tabs (pages). Workingsetmaximum is set to 8 GB. Is there some setting that i can change so that the number of pages is not restricted?

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,817 questions
asked 2024-05-01T06:11:37.92+00:00
Avijit Swain 0 Reputation points
commented 2024-05-16T02:30:06.6866667+00:00
LucyChenMSFT-4874 1,280 Reputation points
1 answer

Sql server reporting issue on save and print the data

Hi Team, customer facing weired issue on reporting url that is customer can't save and print the output but customer can able to pull the data. I verified with customer for any errors but I don't see any…

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,834 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,817 questions
asked 2024-04-30T23:15:39.4333333+00:00
nasar babu 0 Reputation points
commented 2024-05-16T02:29:28.65+00:00
LucyChenMSFT-4874 1,280 Reputation points
0 answers

SQL 2016 Linked Server Problems

I am trying to setup a linked server connection to another DB running a non-MSSQL DB. On the local server the account I am using has Sysadmin right on the remote server the local DB account has what they call Admin rights as well. We have tried using…

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,834 questions
asked 2024-05-15T20:35:42.68+00:00
rr-4098 1,256 Reputation points
commented 2024-05-16T02:20:23.46+00:00
ZoeHui-MSFT 33,386 Reputation points
1 answer

Migrating On-prem Sql DB to Azure Managed Sql Instance

Hello, I have created recently Azure Managed Instance and looking some expert guidance as I need to restore on-prem Database first for testing but my database is in simple recovery mode as it's non-prod DB. Do I need to change recovery model to FULL then…

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.
12,834 questions
asked 2024-05-14T22:06:14.8033333+00:00
pdsqsql 391 Reputation points
commented 2024-05-16T01:56:47.4333333+00:00
Alberto Morillo 32,901 Reputation points MVP
4 answers

set order by based on asc series

Hello This is my sql table with data /****** Object: Table [dbo].[temp_days_order_pending] Script Date: 05/15/2024 23:12:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE…

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,296 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,834 questions
asked 2024-05-15T17:50:11.12+00:00
RAVI 916 Reputation points
answered 2024-05-16T01:43:29.9633333+00:00
CosmogHong-MSFT 23,406 Reputation points Microsoft Vendor
3 answers

How do I hide subreport option from the Reportin g Services screen?

I am a SSRS newbie, so pardon simple questions. I created two main reports. One report has hidden reports within. The other report has sub-reports. When I deployed the programs to Reporting Services, the sub-reports appear as selection options. How do I…

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,817 questions
asked 2024-05-14T17:35:37.34+00:00
Stephen Schleyer 40 Reputation points
answered 2024-05-16T01:26:47.4166667+00:00
ZoeHui-MSFT 33,386 Reputation points
2 answers

SSRS 2022 - Subscription Error when Scheduling to Run each Month on 10th 20th or 30th (Error: Invalid Days)

Unable to create/modify SSRS 2022 report subscription to run each month on the 10th, 20th or 30th. Example Schedule settings (See screenshot below): Schedule: Month Months: All months selected On calendar day(s): 20 (But is the same result if 10 or…

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,817 questions
asked 2024-02-15T04:43:13.83+00:00
Gui Xiong (South Western Sydney LHD) 0 Reputation points
commented 2024-05-16T01:25:39.28+00:00
Gui Xiong (South Western Sydney LHD) 0 Reputation points