SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,493 questions
0 answers
Azure SQL DB - Serverless Zone redundant option
Hi , I recently converted one of the MSSQL DB to a Serverless vCore purchase option. However, there is no option to make the database zone redundant. This also happened with Elastic Pool with vCore purchase. Our old databases have the option to make…
asked 2025-03-26T08:50:03.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ricky Kusuma
10
Reputation points
edited the question 2025-03-26T13:33:35.43+00:00
Ricky Kusuma
10
Reputation points
0 answers
Can not find sqlncli.msi URL -404
Hi, I want to create installsheild msi , my MSI have Prerequisite that need to download sqlncli.msi the url to dowload was : <file LocalFile=".\SQLFeaturePack\2012Sp2\x64\sqlncli.msi"…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 88%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
0 answers
is db accessible without consent
a database was edited without my consent, I login with an OTP , so how did someone get into the account?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 66%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
6 answers
One of the answers was accepted by the question author.
Microsoft SQL Management Studio for Mac
Hi, Is there any Mac version for Microsoft SQL Management Studio? Where can I get it from? Thanks, Jassim
asked 2023-04-27T10:10:32.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 31%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jassim Al Rahma
1,596
Reputation points
commented 2025-03-26T11:01:40.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 67%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jarle F
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How to export all DDL statement for entire schema from SQL server using script
Hi, I wanted export all DDL script from UAT and importing into my DEV environment for entire schema.
asked 2025-03-20T08:57:02.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 25%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
C, Manoharan (Cognizant)
40
Reputation points
accepted 2025-03-26T09:22:10.4733333+00:00
C, Manoharan (Cognizant)
40
Reputation points
2 answers
Adding Conditional Not Null Constraint to Table
Hi, Running SQL Server 2008 R2. DDL below: CREATE TABLE [dbo].[Test] ( [TestID] [bigint] NOT NULL IDENTITY, [Column1] [varchar](50) NOT NULL, [Column2] [varchar](50) NULL, [Column3] [varchar](50) NULL, [Flag] [bit] NOT NULL, CONSTRAINT…
asked 2025-03-25T20:47:55.5866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV7%3C/text%3E%3C/svg%3E)
VDT-7677
121
Reputation points
answered 2025-03-26T01:41:14.8166667+00:00
ZoeHui-MSFT
41,296
Reputation points
2 answers
One of the answers was accepted by the question author.
Issue trying to import .dat flat file into SQL Server 2019 DB?
Hello I have a flat .dat file as Source and am trying to import it into a SQL Server 2019 Database as a Table. This .dat file FIELDTERMINATOR = '|' Vertical Pipe...and I've been trying different variations using bcp and BULK INSERT with FORMAT FILE (and…
asked 2025-03-24T21:53:03.4733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,981
Reputation points
accepted 2025-03-26T01:40:26.6133333+00:00
techresearch7777777
1,981
Reputation points
1 answer
One of the answers was accepted by the question author.
Auditing Azure SQL Azure
Hello! I need to start configuring auditing for some SQL databases in Azure. Before starting, I'd like to clear up some questions I have. What's the difference between enabling auditing at the SQL Server level or at the Database level? What's the…
asked 2025-03-25T15:21:45.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
265
Reputation points
commented 2025-03-25T18:35:08.6233333+00:00
Fernando Gutierrez
265
Reputation points
5 answers
Issues installing latest Microsoft OLE DB Driver for SQL Server ?
Hello, a machine has what looks like an old OLE driver as follows: Microsoft OLE DB Driver for SQL Server = Version 18.5.0.0 I downloaded and tried to install the latest at: Download Microsoft OLE DB Driver 19 for SQL Server (x64) I get the following…
asked 2024-01-26T19:19:38.06+00:00
techresearch7777777
1,981
Reputation points
commented 2025-03-25T15:36:42.6666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 40%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
STIAN BREIVIK BARMEN
0
Reputation points
0 answers
Is it possible to change certificate installed on Azure SQL Server with a non Microsoft one?
Hello, We setup an SQL Server and database in the public Azure cloud. About the connection to the database, the SQL Server present a TLS Certificate which CA is Microsoft. Is it possible to change this with a certificate from Digicert or other?Thanks…
asked 2025-03-25T15:11:51.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 1%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sébastien Thiry
0
Reputation points
asked 2025-03-25T15:11:51.46+00:00
Sébastien Thiry
0
Reputation points
1 answer
Sql server configuration manager upgrade
After completing an in-place upgrade from SQL Server 2016 to SQL Server 2019, the SQL Server Configuration Manager will automatically update to the 2019 version. Or we want to install anything manually.
asked 2025-03-25T14:48:05.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
145
Reputation points
answered 2025-03-25T15:09:24.6133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
40,540
Reputation points MVP
2 answers
SQLSERVER configuration manager
After completing an in-place upgrade from SQL Server 2016 to SQL Server 2016, the SQL Server Configuration Manager will automatically update to the 2019 version. Or we want to install anything manually.
asked 2025-03-25T14:44:46.9866667+00:00
Anandhswarupp
145
Reputation points
answered 2025-03-25T14:50:02.4466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
57,396
Reputation points
0 answers
Cannot resolve the collation conflict between "Latin1_General_100_CI_AS_SC_UTF8" and "Latin1_General_100_BIN2_UTF8" in the UNION operation After upgrading to SPARK 3.4
We have upgraded the Spark pool from 3.3 to 3.4. We were having the view that was absolutely working fine in Spark pool 3.3. But after upgrading it to Spark pool 3.4 the view is throwing the error Msg 468, Level 16, State 9, Line 260 Cannot resolve the…
asked 2025-03-25T12:42:26.7666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 24%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mustafa Ali Asghar
0
Reputation points
asked 2025-03-25T12:42:26.7666667+00:00
Mustafa Ali Asghar
0
Reputation points
1 answer
One of the answers was accepted by the question author.
SSMS Object Explorer Details context menu scarcely populating
In SSMS object explorer details, when I view object explorer details and click on the headers row, the context menu shows only name and Policy Health status. Most of my tables only have a couple of columns (I'm only just starting on SQL), but said…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 54%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Could not allocate a new page for database 'TEMPDB' because the 'DEFAULT' filegroup is full due to lack of storage space or database files reaching the maximum allowed size.
Hi, Need help on this. When am running below query automatically tempdb is growing and local drive is getting full which is 70GB free. The actual size table is 5 Million. with custmr_billed as ( select cus_id, year([bill date]) as…
asked 2025-03-21T12:47:22.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 97%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
mrrobot telg
20
Reputation points
commented 2025-03-25T09:28:17.3533333+00:00
mrrobot telg
20
Reputation points
1 answer
Can I distribute SQLSysClrTypes.msi
Hi, We are using SqlGeography classes stored in Microsoft.SqlServer.Types and rely on native SqlServerSpatialxxx.dll (part of SQLSysClrTypes package). My question is can I use SQLSysClrTypes.msi as redistributable package as part of our installer? (Idea…
asked 2025-03-17T17:10:54.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 75%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZS%3C/text%3E%3C/svg%3E)
Zachi Sharon
0
Reputation points
edited the question 2025-03-25T04:37:33.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 21%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Syed Saleem Peera
12,115
Reputation points Microsoft External Staff
1 answer
Trying to install SQL Server 2022 Developer edition on new Windows 11 Machine
I can't get SQL Server 2022 to install on my new Laptop. I get errors with no messages. I am out of ideas. I have attached the detail log. Detail.txt
asked 2025-03-21T22:47:02.5866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 86%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Chad Hendrickson
0
Reputation points
commented 2025-03-24T22:56:43.93+00:00
Chad Hendrickson
0
Reputation points
1 answer
Lost Encryption password
Someone from our company had previously setup an automated backup for SQL server VM with encryption enabled however, we don't have the password they set it up. Without the password setup originally, we are not able to restore any backups. How do we fix…
asked 2025-03-24T14:57:47.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 26%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Samy Ponnusamy
0
Reputation points
answered 2025-03-24T20:45:41.4466667+00:00
Azar
26,910
Reputation points MVP
2 answers
Difference Between Virtual memory and Page File in SQL Server?
Hi there, In On Prem SQL Server with 4gb server memory and page file size 4206 MB. I ran DBCC memorystatus command and got below…
asked 2025-03-23T09:09:09.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 11%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chirag Sachdeva
281
Reputation points
answered 2025-03-24T18:17:39.9133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
73,101
Reputation points
0 answers
Azure Data Fatory -Failure happened on 'Source' side.
Receiving the following error in my Pipeline "Message": "Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the…
asked 2025-03-24T17:12:33.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 10%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Roshani Chavan
0
Reputation points
asked 2025-03-24T17:12:33.49+00:00
Roshani Chavan
0
Reputation points