19,838 questions with SQL Server-related tags

Sort by: Updated
1 answer

When installing SQL Server in an Azure VM FCI with Storage Spaces Direct, does it matter what host caching I select for each of the disks?

Hi Azure Community I have been given the task of installing a two node SQL Server 2022 failover cluster instance on Windows Server 2022. I'm going to use Storage Spaces Direct to create one storage pool, out of which I'll create volumes for data and…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,259 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.
14,320 questions
asked 2024-07-11T02:59:29.62+00:00
Adam 0 Reputation points
answered 2025-01-19T11:23:35.6066667+00:00
Amira Bedhiafi 27,601 Reputation points
1 answer

How to view my content from my database to my home view in .Net core MVC

Hi guys SO I was learning to use .NET Core MVC through the tutorial, and I decided to take it up a notch. While the tutorial has been helpful, it did not really have what I was looking for, and surprisingly, neither do all the AI bots. So what's the…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,740 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.
14,320 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.
11,208 questions
asked 2025-01-18T15:28:13.7133333+00:00
Assadullah Sanusi 0 Reputation points
commented 2025-01-19T10:44:16.04+00:00
AgaveJoe 29,281 Reputation points
1 answer

ElasticPoolSkuCombinationInvalid - How to find a valid database SKU for different elasticpool SKU's

I am getting a below error when trying to create a database with S3 for a elasticpool with StandardPool sku, I have tried different combination as per terraform document and azure document ended up with same error. Database Name: performing…

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.
14,320 questions
asked 2025-01-17T05:46:03.06+00:00
Gnanasoundari 45 Reputation points
edited an answer 2025-01-19T09:59:16.9166667+00:00
NIKHILA NETHIKUNTA 4,100 Reputation points Microsoft Vendor
2 answers

server sql 2019

Hello When installing the sql 2019 server, I get an error saying that my C disk is compressed. I decompressed and rebooted my pc but during installation I still get the same error. Could you please help me?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2023-12-12T10:56:23.3266667+00:00
Lange Ravie MAHOUNGOU NKENGUE 0 Reputation points
edited the question 2025-01-19T03:21:12.53+00:00
TP 101.9K Reputation points
2 answers

Question about decimal numbers in SQL Server Management Studio

Hello, everyone, I am new using SSMS, I created a data base. I used the "import flat file option" to import a csv file, in preview data I uncheck the use rich data type detection, in the modify colum section I see that temp and atemp are float,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2025-01-15T21:07:11.43+00:00
Marlon Abreo 40 Reputation points
commented 2025-01-18T21:24:45.9333333+00:00
Marlon Abreo 40 Reputation points
1 answer

How to debug "Invalid transaction state" error in ODBC?

Hi, ALL, I have an application that throws an aforementioned error upon exit/disconnect. I know that every transaction I start I COMMIT/ROLLBACK and those transactions are doing "CREATE TABLE/INSERT" statements. However I am also doing SELECT…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 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,830 questions
asked 2025-01-18T19:19:58.4133333+00:00
Igor Korot 26 Reputation points
commented 2025-01-18T21:23:17.26+00:00
Erland Sommarskog 115.6K Reputation points MVP
3 answers

@@ROWCOUNT issue

Hi there, I had the below code and it worked fine in counting the records inserted and logging insert counts. CREATE PROCEDURE ProcessCustomer AS BEGIN DECLARE @RowsInserted INT; -- Insert into the final table and capture row count …

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.
14,320 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,676 questions
asked 2025-01-11T05:26:26.6833333+00:00
RJ 206 Reputation points
commented 2025-01-18T20:58:35.1066667+00:00
Erland Sommarskog 115.6K Reputation points MVP
3 answers One of the answers was accepted by the question author.

Can the MSSQL JDBC driver connect to a SQL SERVER using a GMSA account?

Is it possible for the MSSQL JDBC driver to connect to a SQL SERVER using a GMSA account? If it is, what should the connection string look like? Can the connection URL include the GMSA account name, such as…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2023-10-20T09:20:34.7466667+00:00
Chiru 25 Reputation points
commented 2025-01-18T18:28:14.2366667+00:00
Erland Sommarskog 115.6K Reputation points MVP
2 answers

How to connect a database engine with default server name available in the dropdownlist or browse for more column?

I already reffered the documentation of how to connect a database engine and when I tried to connect it gives me error below: TITLE: Connect to Server Cannot connect to localhost. ADDITIONAL INFORMATION: A network-related or instance-specific 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.
14,320 questions
asked 2025-01-17T11:41:56.44+00:00
Vidhi Keyur Bhatt 0 Reputation points
answered 2025-01-18T17:06:31.4666667+00:00
Bruce (SqlWork.com) 69,501 Reputation points
1 answer

SQL Drivers for PHP 8.4

Been using PHP 8.4 for a couple months, just realized I needed to download SQL driver for new project. The newest driver I can find is 5.12.0 however it says it only supports up to PHP version 8.3. When will new driver that supports PHP 8.4 be…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2025-01-18T01:44:39.5133333+00:00
Piedlow, Bert 0 Reputation points
answered 2025-01-18T09:56:42.35+00:00
Erland Sommarskog 115.6K Reputation points MVP
0 answers

Trying to import Excel file into SSMS 20.2 and I get this error

TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) BUTTONS: OK

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2025-01-18T05:02:38.6833333+00:00
Brooke 0 Reputation points
commented 2025-01-18T09:52:49.16+00:00
Erland Sommarskog 115.6K Reputation points MVP
1 answer

cost threshold for parallelism

Good day, I am confused by reading 2 different information in Microsoft Documents and making some testing analyzing the execution plans regarding the cost threshold for parallelism What is the estimated cost which the threshold refers to? In one…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2025-01-17T03:40:19.15+00:00
Martin Garcia 0 Reputation points
answered 2025-01-17T22:12:41.88+00:00
Erland Sommarskog 115.6K Reputation points MVP
0 answers

Unable to instal SQL Server (setup.t lexe), Eit code (Decima): -2147467259Error description: The system cannot find the path specifled

facing this error while installing SQL server Developer edition Basic and got this error again and again i dont know how i will solve this error its urgent i havw to use SQl server urgently

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2025-01-17T09:23:29.4133333+00:00
Apoorv Srivastava 0 Reputation points
commented 2025-01-17T22:02:10.7666667+00:00
Erland Sommarskog 115.6K Reputation points MVP
2 answers One of the answers was accepted by the question author.

Frustrating with error message every time while installing MS SQL server 2022

I am trying to install MS SQL server 2022. I am getting this every time when i reinstall and install again even in my brand-new laptop I never experienced before this while installing SQL. Please can anyone advise me to fix this. Please see 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.
14,320 questions
asked 2025-01-17T12:32:34.5833333+00:00
Sachin Gurung 20 Reputation points
answered 2025-01-17T21:54:41.9133333+00:00
Erland Sommarskog 115.6K Reputation points MVP
0 answers

how can I connect to my azure sql server using SSMS from my home office?

How do I grant permissions to my SQL Azure database to new Internal users.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2025-01-17T21:11:26.88+00:00
Ronald Fuller 0 Reputation points
commented 2025-01-17T21:51:33.33+00:00
Erland Sommarskog 115.6K Reputation points MVP
0 answers

SSMS 20 Busy message

SSMS 20 constantly display Busy message sending to microsoft

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2025-01-16T22:18:43.0233333+00:00
Gary Paterson 0 Reputation points
commented 2025-01-17T21:44:09.72+00:00
Erland Sommarskog 115.6K Reputation points MVP
2 answers

Concurrency Update Issue in Temporal Tables

For a system-versioned table, when concurrent operations like INSERT, UPDATE, or DELETE are performed, the system-generated timestamps (SYSTEM_TIME columns) may reflect the same value. This makes it challenging to determine the exact sequence of 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.
14,320 questions
asked 2025-01-14T23:25:54.5433333+00:00
ARUNKUMAR KRISHNASAMY 0 Reputation points
commented 2025-01-17T21:37:39.47+00:00
Erland Sommarskog 115.6K Reputation points MVP
5 answers One of the answers was accepted by the question author.

SQL Server ID Jump 1000 issue fixed in SQL Server 2019 ?

hi, In SQL Server 2012 - MS had introduced 'Identity Cache'. This feature had a bug of auto-incrementing ID column by '1000'. For example, if ID columns are 1, 2 and when an ID Jump happens the next ID column is 1003, instead of '3'. There are…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,320 questions
asked 2021-08-17T14:26:54.31+00:00
Tariq Sattarkhan Pathan 26 Reputation points
commented 2025-01-17T21:34:35.0533333+00:00
Erland Sommarskog 115.6K Reputation points MVP
1 answer

How to login the SQL server authentication?

I can only access my database via the SQL Database Query Editor via the "Microsoft Extra Authentication". I tried logging in using the "SQL server authentication" but that doesn't allow me to do so. Question: Where do I generate 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,972 questions
asked 2025-01-17T18:34:44.3566667+00:00
Brian Thomas 0 Reputation points
answered 2025-01-17T21:06:12.8966667+00:00
Bruce (SqlWork.com) 69,501 Reputation points
0 answers

Export SSRS report from 2207 to a new 2409

I am trying to export custom reports from an old site and bring them into the new site, what would be the best option to do so?

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,972 questions
Microsoft Configuration Manager
asked 2025-01-17T17:20:12.6766667+00:00
Belgian Malinois 421 Reputation points