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…
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…
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…
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?
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,…
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…
@@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 …
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…
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 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…
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
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…
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
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…
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.
SSMS 20 Busy message
SSMS 20 constantly display Busy message sending to microsoft
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 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…
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…
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?