17,345 questions with SQL Server-related tags

Sort by: Updated
4 answers

Issues in using Microsoft.Data.SqlClient in SSIS project

I have installed visual studio 2022 image and installed SQL Server Integration Services Projects 2022. I am trying to implement functionality of ado.net using Microsoft.Data.SqlClient and running into below issues. ADO NET Destination has failed to…

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.
473 questions
asked 2023-11-07T23:13:16.0566667+00:00
veera 0 Reputation points
answered 2024-02-21T16:16:04.5733333+00:00
Duncan Dubick 0 Reputation points
1 answer

Best Practice/Standard Alias Schema/Table Convention

Just looking for suggestions for best practices and/or standards for table aliases in a Query. I know this is very subjective...but just looking for some general guidelines from experts and their experience and what works and what might not work. Should…

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.
21 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,515 questions
asked 2024-02-21T15:20:45.85+00:00
Bobby P 221 Reputation points
answered 2024-02-21T16:14:01.55+00:00
Michael Taylor 43,891 Reputation points
1 answer

Connect to Azure Database for MySql

Hi, I am trying to connect to Azure Database for Mysql from SSIS. I have installed the connector (MySql connector for NET ADO) I have entered the server name, username (MySql database username) and password and the port 3306. When I clicked Test…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
668 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,404 questions
asked 2024-02-21T15:59:47.2933333+00:00
Raj Maddala 20 Reputation points
answered 2024-02-21T16:04:43.27+00:00
Vahid Ghafarpour 14,215 Reputation points
1 answer

Azure SQL autoscaling based on DTU load

Hi Team, Is there any option to use auto scaling option for my azure SQL DB Condition: if DTU is 100% for around 10min then i want automatically scale to next DTU and if load comes down i want to scale down to low DTU. Regards, Naveen

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,232 questions
asked 2024-02-21T13:40:31.7533333+00:00
Naveen Kumar 0 Reputation points
edited the question 2024-02-21T16:00:12.63+00:00
Naveenommi 180 Reputation points Microsoft Vendor
2 answers

Sql backup into Azure Blob fails: 1117(The request could not be performed because of an I/0 device error.)

I am trying to run a backup from our sql server to a blob azure container. I went ahead and did the setup exactly as suggested by…

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,232 questions
asked 2024-02-21T09:29:58.56+00:00
Andreas Niedermann 0 Reputation points
edited an answer 2024-02-21T15:59:01.03+00:00
Javier Villegas 895 Reputation points MVP
2 answers

Re-use of ##Global Temporary Table in additional SSRS Datasets

We currently have multiple Datasets in the same report that are going to use the same ##Global Temporary Table. Should the ##Global Temporary Table be defined in the first Report Dataset listed in Microsoft Visual Studio so then it can be re-used by…

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,725 questions
asked 2024-02-16T21:22:49.5666667+00:00
Bobby P 221 Reputation points
commented 2024-02-21T15:25:33.9566667+00:00
Bobby P 221 Reputation points
2 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.
12,232 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,677 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.
620 questions
asked 2024-02-20T16:28:13.2166667+00:00
Doug V 0 Reputation points
edited an answer 2024-02-21T15:20:24.0333333+00:00
Alex Bykovskyi 1,351 Reputation points
0 answers

How to remove blank cells from a Report Builder Report when displaying daily data?

Is it possible to edit the report to display dates that only have data and not everyday?

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,725 questions
asked 2024-02-21T13:46:38.5066667+00:00
Camponeschi, Alan William 0 Reputation points
1 answer

delete with Y flag and I with N

please note this is no duplicate question,here output is different HI EXPERT, create tabletest19 (col1 char(23), col2 CHAR(20),col3 char(3),col4 CHAR(23),col5 CHAR(23),col6 DATETIME )and expected output is this insert into tabletest19…

Azure SQL Database
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,844 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,232 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,404 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,515 questions
asked 2024-02-20T23:36:07.36+00:00
Shambhu Rai 1,381 Reputation points
commented 2024-02-21T13:12:14.25+00:00
Vineet S 0 Reputation points
2 answers One of the answers was accepted by the question author.

Can i organise stored procedures in ssms in different folders?

I have a lot of stored procedures in my project and I want to organize them in multiple folders for clear identification and segregation. Is it possible?

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,232 questions
asked 2024-02-15T11:04:18.6533333+00:00
PRASHANTH KUMAR THOTA 20 Reputation points
accepted 2024-02-21T11:36:27.2+00:00
PRASHANTH KUMAR THOTA 20 Reputation points
0 answers

Datefirst in SQL Server Function

Hello, I have a SQL server function where I have to find the weekday number. Now it seems that it depends on the user which result I get. With some users I get a 7 for Sunday, with others a 1. I've inserted Set DATEFIRST into this function, but 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,232 questions
asked 2024-02-21T11:22:39.1466667+00:00
Hans Furmann 0 Reputation points
0 answers

MFA when connecting Azure Sql via ssms

I have not enabled MFA, but when I try to sign in to Azure SQL Database via SSMS, it asks me for an MFA code. I logged in with my M365 account and checked the security info, and MFA was not enabled there. I am able to login to Azure portal without…

Azure SQL Database
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
5,069 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,232 questions
asked 2024-02-07T18:12:56.2+00:00
Siva Prasad 0 Reputation points
commented 2024-02-21T10:32:55.5933333+00:00
Siva Prasad 0 Reputation points
1 answer

SQL server data import error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Hi All, I'm attempting to import data into SQL Server from an Excel spreadsheet, but I consistently encounter an error message stating: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" from the System.Data…

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,232 questions
asked 2024-02-21T09:09:56.7433333+00:00
Rajapriya Rajendran 21 Reputation points
edited an answer 2024-02-21T09:35:05.42+00:00
ZoeHui-MSFT 30,411 Reputation points
0 answers

Error connecting to database via separate app

I am trying to use a separate app to scan pictures and attach them to the specified client in my customer database, but I am receiving an error message: "A network-related or instance-specific error occurred while establishing a connection to 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,232 questions
asked 2024-02-21T09:09:55.99+00:00
Natnael Tsehaye 0 Reputation points
2 answers One of the answers was accepted by the question author.

BackupIoRequest::ReportIoError: read failure on backup device 'C:\Ondemand\databasename.bak'. Operating system error 13(The data is invalid.).

i am trying to take a backup with verification after backup complete and with include of checksum, still verification of backup failed and also restoration is also failing and when i pulled out the error log i got this error and i am unable to sort 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,232 questions
asked 2024-02-20T13:25:16.81+00:00
Mahesh Mattapally 0 Reputation points
accepted 2024-02-21T09:06:22.59+00:00
Mahesh Mattapally 0 Reputation points
1 answer

How to fix Violation of PRIMARY KEY constraint 'PK_Mytable'. Cannot insert duplicate key in object 'dbo.Mytable' with Transaction (Process ID 181) was deadlocked on lock resources with another process

I am encountering an issue while attempting to call a stored procedure from a .NET Framework application to a Microsoft SQL Server instance. The error message returned is: "Violation of PRIMARY KEY constraint 'PK_Mytable'. Cannot insert duplicate…

Internet Information Services
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,232 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,099 questions
asked 2024-02-21T06:12:13.96+00:00
BalajiGnanendren-6915 0 Reputation points
commented 2024-02-21T08:29:23.4433333+00:00
BalajiGnanendren-6915 0 Reputation points
0 answers

Unable to connect to SQL server in standard logic app using built-in SQL server connector

Hi I am using standard logic app built in sql server connector to connect my on prem sql server DB. Authentication is the connection string Server={your-server-address};Database={your-database-name};User Id={your-user-name};Password={your-password};…

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,696 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,232 questions
asked 2024-02-21T01:26:00.13+00:00
Ren 1 Reputation point
edited a comment 2024-02-21T08:21:58.6366667+00:00
Greg Low 355 Reputation points Microsoft Regional Director
0 answers

Optimizing stored procedure that exceeds timeout limit

I am encountering a challenge with a Windows service responsible for generating reports using the stored procedure "Mgmt_Report". The stored procedure is subjected to a timeout period of 5 minutes. While smaller reports, typically taking 1 to 3…

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,232 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,515 questions
asked 2024-02-21T07:37:37.88+00:00
BalajiGnanendren-6915 0 Reputation points
commented 2024-02-21T08:07:41.43+00:00
Greg Low 355 Reputation points Microsoft Regional Director
1 answer

We are using windows 2022 server with SQL 2022, the problem is that after sysprep execute ,sql analysis failed with Error:Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change

After upgrade the image to win22 and sql22. Not able to run bam Analysis service getting error Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException: Errors in the…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,677 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,404 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,231 questions
asked 2024-02-09T08:23:31.9833333+00:00
edited a comment 2024-02-21T07:42:45.46+00:00
Greg Low 355 Reputation points Microsoft Regional Director
1 answer

Maps in SSRS coming back with status 401: Unauthorized

We have reports written in SSRS that have Map components in them. They have been working well, but recently they have been producing intermittent 401: Unauthorized and not displaying the base map layer (Bing map imagery), see the attached image. No…

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,232 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,725 questions
asked 2023-12-08T01:13:44.01+00:00
Bruce Cauchi 36 Reputation points
commented 2024-02-21T07:38:14.5266667+00:00
Dag Hagen 20 Reputation points