19,425 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Support Plans for 32-bit ODBC Driver ## for SQL Server and 32 bit Architecture (Application) on 64 bit Windows

We are in a plan to migrate our 32 bit VB6 huge 25 year old Application into 64 bit compatible application hence we would like to know, Is there any specific or formal statements regarding Microsoft long-term plans on Support Plans: The Support for…

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,977 questions
asked 2024-11-07T06:25:26.27+00:00
Suresh Balasubramanian 0 Reputation points
answered 2024-11-07T08:23:36.93+00:00
LiHongMSFT-4306 27,961 Reputation points
2 answers

Issue with Deploying Azure SQL Server Managed Instances: “Your deployment failed”

Hello, I am encountering an issue while trying to deploy Azure SQL Server Managed Instances. The deployment process fails with the message “Your deployment failed.” I have attached a screenshot of the deployment details and included the error message…

Azure SQL Database
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,217 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,977 questions
asked 2024-11-05T09:15:43.5866667+00:00
DoFast 26 Reputation points
edited a comment 2024-11-07T07:36:42.2533333+00:00
DoFast 26 Reputation points
1 answer

How to covert UTC time to CST

I have a dataset recorded in UTC format. I want to covert it and add a field as CST. I used convert(datetime, switchoffset(convert(datetimeoffset, @UTCTime), datename(TzOffset, sysdatetimeoffset()))) to covert CST. However, I found it changed the time…

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,977 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
asked 2024-11-04T22:10:18.3466667+00:00
2956 1 Reputation point
commented 2024-11-07T07:00:33.2933333+00:00
LiHongMSFT-4306 27,961 Reputation points
1 answer

Why are ODBC statements still being registered as commits in SQL Server even though autocommit is off?

Hi, When executing (INSERT/UPDATE) statements through an ODBC driver for SQL Server, with SQL_ATTR_AUTOCOMMIT set to OFF on the connection, the autocommit behavior does reflect this, in practice. I.e., the data being updated is not available on the…

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,977 questions
asked 2024-11-06T17:01:30.7866667+00:00
Alex 0 Reputation points
answered 2024-11-07T06:46:11.9233333+00:00
ZoeHui-MSFT 37,446 Reputation points
2 answers

Browser for SQL Server 2017 and 2019

Browser for SQL Server 2017 and 2019 Hello,  my question is the following. Despite having the latest updates released for SQL Server 2019 and 2017, I notice that SQL Server Browser does not change versions, remaining in the versions mentioned below. 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,977 questions
asked 2024-11-06T12:25:39.8366667+00:00
Rafael da Silva Salgado 0 Reputation points
answered 2024-11-07T02:59:46.05+00:00
ZoeHui-MSFT 37,446 Reputation points
0 answers

Problem in download SQL Express (ODCB driver not recognized)

Hello, my problem is simple: I want to download SQL Express locally and I'm asked to download ODCB driver. Regardless of many restarts and re/uninstalls, ODCB driver remains unrecognized and install keeps on failing (see picture 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.
13,977 questions
asked 2024-11-06T09:44:13.69+00:00
Elja Placido De Oliveira 20 Reputation points
commented 2024-11-07T02:49:49.24+00:00
LiHongMSFT-4306 27,961 Reputation points
1 answer

DB Mail issue

Hello! Maybe I forgot something... please help me please to understand the following: If I have some job that must notify email operator upon its (for example) failure - should these email notifications be sent (and received) if DB Mail 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.
13,977 questions
asked 2024-11-06T15:41:10.04+00:00
Hram Admin 20 Reputation points
answered 2024-11-07T02:46:50.6833333+00:00
LiHongMSFT-4306 27,961 Reputation points
1 answer One of the answers was accepted by the question author.

Problems with passing Binary as a table-valued parameter

I'm using table-valued parameters to pass binary values. I used SQLBindParameter and passed the values as SQL_C_BINARY, SQL_BINARY, BinarySize, etc. as the arguments, but when I run SQLExecute, I get an error or the result is different from what 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,977 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,758 questions
asked 2024-11-06T01:19:40.36+00:00
Kwan 0 Reputation points
commented 2024-11-07T01:33:45.1133333+00:00
Rodger Kong 360 Reputation points
0 answers

Creditentials

Hello, Since I got my latest creditentials I am interested in getting more of them. I am interested in ones regarding .NET and for programming/development languages.

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,611 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,977 questions
asked 2024-11-06T21:55:12.46+00:00
Ivan Bulaš 0 Reputation points
commented 2024-11-07T01:24:54.52+00:00
Ping Ni-MSFT 4,720 Reputation points Microsoft Vendor
1 answer

Error Deploying Azure QuickStart API Builder: SQL Database Unavailable in any location

Hi all, I'm new to azure and am on the free trial and I have been trying to follow this guide to get started on APIs within Azure, https://learn.microsoft.com/en-us/azure/data-api-builder/quickstart-azure-sql. But once I get to deploying the static web…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
848 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,977 questions
asked 2024-11-06T16:07:33.23+00:00
Christopher Ajayi 0 Reputation points
answered 2024-11-06T23:26:52.8966667+00:00
Mahesh Kurva 725 Reputation points Microsoft Vendor
4 answers

Migrate 1 TB database within 10 minutes

Business wants to migrate 1 TB database to new server with 10 minutes of acceptable downtime. How to do 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,977 questions
asked 2023-08-27T14:15:04.8866667+00:00
Chaitanya Kiran 801 Reputation points
commented 2024-11-06T21:37:59.33+00:00
carlintveld 26 Reputation points
0 answers

Database re-provisioning failed with the exception "The schema info could not be retrieved from the schema info table.

Database re-provisioning failed with the exception "The schema info could not be retrieved from the schema info table. For more information, provide tracing ID ‘a991aa28-7145-459b-9530-e009fb53708d’ to customer support."

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,977 questions
asked 2024-10-31T19:37:36.5766667+00:00
John Tran 0 Reputation points
commented 2024-11-06T19:07:02.01+00:00
Oury Ba-MSFT 19,581 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Hi Team, We are getting below error while running query in SSMS: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Normally it shouldm't take more than 2 mins. But from…

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,977 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
asked 2021-07-07T20:32:35.56+00:00
Vijay Kumar 2,036 Reputation points
commented 2024-11-06T16:40:18.92+00:00
Jia Zhuang 0 Reputation points
1 answer

Permissions error in SSMS with a dataverse datalake

Hello, I'm having an issue with creating a PowerBI report - specifically connecting to a data source. I created a view in a datalake in SSMS based on dataverse data but keep experiencing this issue. My colleague cannot replicate the error and I'm not…

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,991 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,977 questions
asked 2024-11-05T16:03:32.91+00:00
Jesse Ruiz 0 Reputation points
edited a comment 2024-11-06T15:52:19.4433333+00:00
phemanth 11,200 Reputation points Microsoft Vendor
1 answer

Please provide windows powershell commands to import a database backup file which is on azure blob storage account to my azure SQL vm in which sql image is installed

we have a windows sql vm where we have a preinstalled sql windows 2022 image in it. Now there is a database backup file that is stored in azure blob storage now we want to import that file into this azure sql vm can we get any powershell commands for…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,918 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,977 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,584 questions
asked 2024-11-04T11:56:59.7933333+00:00
Aravapalli Ojeswi 0 Reputation points
commented 2024-11-06T12:27:55.2333333+00:00
ShaktiSingh-MSFT 15,341 Reputation points
1 answer One of the answers was accepted by the question author.

Azure SQL DB DTU Increasing

I have to Increase my Azure SQL Single database DTU from Standard S2 (50 DTU) to Standard S3 (100 DTU). How much time it will take and is there any Downtime required for that?

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,977 questions
asked 2024-11-05T06:53:35.6066667+00:00
Sudhakar P 20 Reputation points
edited a comment 2024-11-06T12:11:17.1366667+00:00
Sudhakar P 20 Reputation points
4 answers One of the answers was accepted by the question author.

403 Forbidden Error while trying to access authorized routes in a .NetCore 8 WebAPI -

Hi All, Let me discuss my problem in clear detail. I am trying to build a backend webAPI for an app using .NetCore 8. I created the database for my webapi by using code-first migrations on AspNet Identity. The respective tables have been created. In…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,611 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,507 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,977 questions
ASP.NET API
ASP.NET API
ASP.NET: A set of technologies in the .NET Framework for building web applications and XML web services.API: A software intermediary that allows two applications to interact with each other.
343 questions
asked 2024-11-05T18:16:25.4366667+00:00
P. G. Choudhury 41 Reputation points
accepted 2024-11-06T11:15:13.4033333+00:00
P. G. Choudhury 41 Reputation points
1 answer

In the UK South region, we face SQL Server login issues. The ensureCreated method fails with “Login failed for user ‘myUsername’.”

In the UK South region, we are experiencing issues with the SQL Server login. Although we are using the correct username and password, the login fails when attempting to call the method ensureCreated from Entity Framework, we encounter the error:…

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,977 questions
asked 2024-11-04T15:17:49.8866667+00:00
nikithakoshy 80 Reputation points
edited a comment 2024-11-06T10:28:58.7933333+00:00
Mahesh Kurva 725 Reputation points Microsoft Vendor
0 answers

SQL SP consuming lot more time in one env compared to other

Hello Experts, I am using AWS RDS DWH (8GB RAM & SQL Web edition), where have following two databases created Dev : contains 1 month of data Test: contains 3 months of data The data model, data ingestion stored procedure, functions are same in both…

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,977 questions
asked 2024-11-06T06:42:52.11+00:00
PANDEY Prashant 145 Reputation points
commented 2024-11-06T07:57:47.41+00:00
LiHongMSFT-4306 27,961 Reputation points
1 answer

SQL Availability Groups

Dear team, We are considering to deploy SQL 2019 on three servers, one that will be hosting the active databases (around 150 databases), one for high availability and one server in the disaster recovery site. We are considering using SQL availability…

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,977 questions
asked 2024-11-06T07:11:57.0333333+00:00
Micheal Mallo 310 Reputation points
answered 2024-11-06T07:57:40.5433333+00:00
ZoeHui-MSFT 37,446 Reputation points