18,665 questions with SQL Server-related tags

Sort by: Updated
3 answers

Error the datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large.

i work on sql server 2019 i face issue when run query to get queries run on server i get error Msg 535, Level 16, State 0, Line 1 The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too…

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,340 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
asked 2022-03-02T16:17:16.63+00:00
ahmed salah 3,216 Reputation points
commented 2024-07-23T18:43:32.7033333+00:00
Karnvir Moudgill 0 Reputation points
0 answers

Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length

Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…

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,678 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,261 questions
asked 2024-07-22T17:24:40.0233333+00:00
Michael King 0 Reputation points
edited a comment 2024-07-23T18:40:55.9366667+00:00
NIKHILANETHIKUNTA 155 Reputation points Microsoft Vendor
0 answers

SQL Server 2022 Error 0x84BC06AA

Trying to install SQL Server 2022 for WIN911 Alarming Software. I am getting the error: 0x84BC06AA I have no SQL items installed at this time, or the ole 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,340 questions
asked 2024-07-23T18:36:00.21+00:00
Brittany Drapeau 0 Reputation points
0 answers

Sql server 2019 patch error: [Error Message] There are no SQL Server instances or shared features that can be updated on this computer.

I have a sql server 2019 standard edition with the RTM + one GDR I am trying to install CU27, but I get this error below and everything is greyed out? [Error Message] There are no SQL Server instances or shared features that can be updated on 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.
13,340 questions
asked 2024-07-23T17:39:45.3966667+00:00
Stratton, Chuck 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to figure out the total number of doses within a time span given to a client as dose are being added and stopped.?

If the cadence values are different, even if the dates overlap the records must be separate. If an order for the same dose and cadence value (including nulls) starts on the same day or the next day (+or-1 day) the record should continue. outlook of…

Azure SQL Database
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.
67 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
11 questions
asked 2024-07-22T22:24:04.8633333+00:00
andrew omofonma 41 Reputation points
accepted 2024-07-23T17:36:56.54+00:00
andrew omofonma 41 Reputation points
3 answers

HSTS for Default page on SSRS

Hi, Our SSRS server is failing a vulnerability (Nessus) scan for HSTS. I have been able to add the SQL CustomHeader for HSTS and I can confirm this is working. SQL CustomHeader XML string…

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,340 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,873 questions
asked 2024-03-15T03:39:19.55+00:00
Craig Garland 286 Reputation points
answered 2024-07-23T17:34:51.8333333+00:00
David Neese 0 Reputation points
1 answer One of the answers was accepted by the question author.

I have a query where I like to run in another server and database

I opened a query in another database, and I would like to run it in another window. Is there a way to do that while keeping the same query window? For example server A database Q to server B database Y.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
11 questions
asked 2024-07-23T14:46:46.1766667+00:00
Jonathan Brotto 200 Reputation points
edited the question 2024-07-23T16:59:13.74+00:00
VarunTha 5,895 Reputation points Microsoft Vendor
3 answers

multi-subnet configuration on WSFC

Hi all, it my first time using Multiple Subnet in creating AlwaysOn Availability... but one of IP Address either AG Listener resource or IP Cluster resource comes offline and the other comes online, is it normal? if not, how should solve 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.
13,340 questions
asked 2024-07-22T14:53:04+00:00
UrBel 60 Reputation points
answered 2024-07-23T16:50:44.6633333+00:00
Alex Bykovskyi 1,846 Reputation points
1 answer

Application unable to connect to Listener intermittently on port 1433

We have a named instance that's running on a dynamic port, with a Listener specified on port 1433. All application strings only specify the listener IP and port. A scheduled job connects to the listener once a day, but it sometimes fails with the 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.
13,340 questions
asked 2024-07-21T04:05:37.09+00:00
Amisha Bhadauria 0 Reputation points
commented 2024-07-23T16:47:44.65+00:00
Amisha Bhadauria 0 Reputation points
3 answers

SQL71501: Error validating element while activating always encrypted

I was activating always encryted in my database when this error showed: Error SQL71501: Error validating element [dbo].[VIEW_NAME]: View: [dbo].[VIEW_NAME] contains an unresolved reference to an object. Either the object does not exist or the reference…

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,340 questions
asked 2024-07-17T15:48:42.3233333+00:00
Francisco Vargas 0 Reputation points
commented 2024-07-23T16:47:08.2766667+00:00
Francisco Vargas 0 Reputation points
1 answer

Cannot create and start Extended Events session in Azure SQL Managed Instance

Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…

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,340 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 20 Reputation points
commented 2024-07-23T16:18:19.89+00:00
Joby Mathew 0 Reputation points
1 answer One of the answers was accepted by the question author.

Add nodes to failover cluster

Hi All i am using windows server 2022, i want to add two nodes to failover cluster manager(these will be sql nodes). my VMs are hosted on azure, i am using quorum as cloud witness(i.e storage account). When adding nodes to windows 2019 cluster i used the…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,607 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,340 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
979 questions
asked 2024-07-18T23:50:07.5033333+00:00
Glenn Maxwell 10,761 Reputation points
accepted 2024-07-23T15:27:53.4333333+00:00
Glenn Maxwell 10,761 Reputation points
3 answers

SSRS Image rotate when exported

If a report is rendered with an image (with an "External" source and a URL in the expression) it is OK, but when it is exported to PDF the image gets rotated -90º on the PDF file. This issue can be seen in several versions of SSRS and on…

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,873 questions
asked 2023-01-04T16:50:37.55+00:00
David Carvalho 6 Reputation points
commented 2024-07-23T15:03:43.1266667+00:00
Jake Carville 0 Reputation points
1 answer

OS and SQL server upgrade

What could be the best upgrade plan for MS SQL server 2012 and Windows server 2012?

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,340 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,614 questions
asked 2024-07-23T12:00:18.7866667+00:00
AJCV 0 Reputation points
commented 2024-07-23T14:44:07.4766667+00:00
Erland Sommarskog 106.8K Reputation points
1 answer One of the answers was accepted by the question author.

Transfer documents from sqlserver in varbinary to Azure Blob storage

I am looking to move a large set of documents from a Managed Instance of SQL Server database where the documents are saved in varbinary data type on the sql server table. The ADF dataflow I created doesn't let me select a Azure Blob 'Binary' as the sink…

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,340 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,160 questions
asked 2024-05-23T16:42:11.0466667+00:00
Reema DSouza 20 Reputation points
commented 2024-07-23T13:57:37.0433333+00:00
Reema DSouza 20 Reputation points
3 answers

Connection to SQL Server from .NET Core on Ubuntu fails with SSL/TLS handshake error

I have a .NET Core console application that connects to a SQL Server database. The application works fine on Windows, but I'm encountering an SSL/TLS handshake failure when running it on an Ubuntu 22.04 LTS VM  class Program { static void Main() …

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,637 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,340 questions
asked 2024-07-18T15:56:42.1666667+00:00
Ansh 0 Reputation points
commented 2024-07-23T12:34:08.71+00:00
Ansh 0 Reputation points
1 answer

How to Fix this error - "Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position X"

How to Fix this below error, we are using the PowerBi report server Version 15.0.1114.33 & SQL Server 2019 version 2019.0150.4365.02 - "Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: ,…

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,340 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,873 questions
asked 2024-07-23T05:47:28.4566667+00:00
Jeetu Menghani 0 Reputation points
edited a comment 2024-07-23T10:28:42.5566667+00:00
Jeetu Menghani 0 Reputation points
1 answer

SQL query to import multiple csv/txt files into SQL Server.

SQL query to import multiple csv/txt files into SQL 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,340 questions
asked 2024-07-23T09:23:05.23+00:00
nn 20 Reputation points
commented 2024-07-23T09:50:48.2466667+00:00
Erland Sommarskog 106.8K Reputation points
1 answer

Custom Security implementation in report server 2024 version

Please explain or share how we i can implement Customs Security in report server 2024 version

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,873 questions
asked 2024-07-23T07:38:31.8+00:00
shafeeq pk 20 Reputation points
answered 2024-07-23T09:21:20.0233333+00:00
ZoeHui-MSFT 35,546 Reputation points
1 answer

SQL Agent job step outcome mentions "This security ID may not be assigned as the owner of this object."

Hello, I created a SQL 2016 Agent job which copies & replaces .bak files from Source Files Location to a Network Disk Share Target Files Location that are 1 day old as follows: robocopy G:\Source_Files_Location…

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,340 questions
asked 2024-06-17T18:41:45.6+00:00
techresearch7777777 1,801 Reputation points
commented 2024-07-23T07:58:41.0033333+00:00
Erland Sommarskog 106.8K Reputation points