SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,369 questions
2 answers
Invalid object name 'STRING_SPLIT' in SQL Server 2019
Hi Support, Our SQL server version is 2019 and check the compatibility level is 150, but it still have error "Invalid object name 'STRING_SPLIT' ". We also tried the case sensitive according to this link, both of them have the same error. …
asked 2022-04-04T02:26:23.81+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, 43%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chong
866
Reputation points
commented 2025-01-25T21:28:12.8033333+00:00
Erland Sommarskog
115.9K
Reputation points MVP
1 answer
CREATE NOTIFICATION IF NOT EXIIST
Hi, ALL, Is there a way to do thttps://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-notification-transact-sql?view=sql-server-ver16 if one do not exist? Thank you,
asked 2025-01-25T03:34:34.7833333+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(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
26
Reputation points
answered 2025-01-25T19:26:30.63+00:00
Erland Sommarskog
115.9K
Reputation points MVP
0 answers
Get information about event
Hi, ALL, The docs at https://learn.microsoft.com/en-us/sql/t-sql/statements/create-event-notification-transact-sql?view=sql-server-ver16#examples sample D shows how check for the event However, I took a look at the sys.event_notification table and there…
asked 2025-01-25T18:30:16.2233333+00:00
Igor Korot
26
Reputation points
commented 2025-01-25T19:21:03.5066667+00:00
Erland Sommarskog
115.9K
Reputation points MVP
10 answers
One of the answers was accepted by the question author.
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,945 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,376 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,369 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,682 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR
135
Reputation points
answered 2025-01-25T19:04:25.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(0, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joshua Moonstar
0
Reputation points
2 answers
One of the answers was accepted by the question author.
I get an error when I connect to the local installed SQLserver and try to load data into PowerBi.
This is the error I get. Details: "Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL'" I installed the latest version os SQL and…
asked 2025-01-22T15:25:46.0966667+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(64, 52%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)
Uco Suierveld
20
Reputation points
commented 2025-01-25T16:06:55.9+00:00
Uco Suierveld
20
Reputation points
2 answers
Unable to install SQL Server 2019.
Detail.txt Screenshot 2025-01-23 163220.jpgI have tried multiple times and I recieve the same message every time. I have attached a screenshot of the error and the text file it gave me
asked 2025-01-23T22:38:25.6033333+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(105.60000000000001, 56.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Denver Wills
0
Reputation points
answered 2025-01-24T18:39:59.5233333+00:00
Erland Sommarskog
115.9K
Reputation points MVP
1 answer
i am unable to indtall sql server on my laptop, i am attaching a photo of what comes up as a problem
device specifications ryzen 5 ; 8 gb ram
asked 2025-01-24T12:14:26.33+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(35.2, 26%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Desh Shubham
0
Reputation points
answered 2025-01-24T18:36:52.2266667+00:00
Erland Sommarskog
115.9K
Reputation points MVP
0 answers
SQL Server fatal error 4014
Hi, I got error: MSSQLSERVER 4014 A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 10054, output error: 0). I applied the recommendations according to this…
asked 2025-01-24T13:00:55.5933333+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, 60%, 39%)' 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)
Андрей Михалевский
3,401
Reputation points
commented 2025-01-24T18:35:35.25+00:00
Erland Sommarskog
115.9K
Reputation points MVP
1 answer
Understanding Transaction Log Truncation in SQL Server 2022
In an Azure SQL Server 2022 environment with multiple databases configured with FULL recovery mode, hourly log backups are taken, and full backups occur nightly. According to the documentation, the expectation is that the log space usage should decrease…
asked 2025-01-21T08:37:26.9166667+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(96, 76%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Roberto Limongello
0
Reputation points
commented 2025-01-24T18:10:15.7266667+00:00
Erland Sommarskog
115.9K
Reputation points MVP
4 answers
SqlDataReader error “Invalid attempt to read when no data is present”
My environment used is Visual Studio 2022 v17.12.4. Language is C# and connecting to SQL Server Express v16.0.1135.2. This is a Windows form using .Net Framework 4.8.1. I am getting the error message “Invalid attempt to read when no data is present”…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,066 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,369 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,237 questions
![](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(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
Error at recreating new Excel table in SSIS after deletion
Greetings, I was trying to make a SSIS package in order to recreate an Excel file which contains some result of a SQL query I'm executing. My architecture is like this: In "Borrar tabla Excel" I delete the existing Excel table via a DROP…
asked 2025-01-23T15:38:26.5066667+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(32, 60%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
Frank Sebastián Franco Hernández
20
Reputation points
commented 2025-01-24T13:36:18.0733333+00:00
Frank Sebastián Franco Hernández
20
Reputation points
3 answers
Transient error in SSRS reports.
When we open a report in SSRS web service url it sometimes fails with the below error. When the same report is opened in web portal url with the same account, it opens with no errors. If we open an SSMS session with the same user and run any stored…
asked 2025-01-22T05:16:44.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(294.40000000000003, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nivedita Rao
0
Reputation points
answered 2025-01-24T13:10:11.51+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(76.8, 38%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ravi Garg
0
Reputation points
3 answers
Transient error in SSRS reports.
When we open a report in SSRS web service url it sometimes fails with the below error. When the same report is opened in web portal url with the same account, it opens with no errors. If we open an SSMS session with the same user and run any stored…
asked 2025-01-22T05:16:44.49+00:00
Nivedita Rao
0
Reputation points
answered 2025-01-24T13:10:11.51+00:00
Ravi Garg
0
Reputation points
0 answers
SSRS Report Server Connection refused
Hello, i have trouble with SSRS, when i try to connect on the local Server via http://localhost/reports or http://localhost/reportserver the connection is refused. On the machine there are SQL Server2022 and SSRS 2022 installed. I checked the services…
asked 2025-01-24T10:22:22.87+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(268.8, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Martin Wegner
0
Reputation points
edited the question 2025-01-24T12:30:10.0733333+00:00
Martin Wegner
0
Reputation points
0 answers
Databases Not Visible in Availability Groups on Primary or Secondary Server
In MS SQL Servers with version "Microsoft SQL Server 2022 (RTM-CU10) (KB5031778) - 16.0.4095.4 (X64) Oct 30 2023 16:12:44 Copyright (C) 2022 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Linux (Ubuntu 20.04.6 LTS)…
asked 2025-01-23T15:52:31.31+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(19.2, 12%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
George Vrynios
0
Reputation points
commented 2025-01-24T08:16:34.3866667+00:00
George Vrynios
0
Reputation points
2 answers
Installed Software Inventory Count without being broken up by version information SCCM
Installed Software Inventory Count without being broken up by version information SCCM
asked 2025-01-23T17:59:40.9466667+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(278.4, 57.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Denning, James
0
Reputation points
edited an answer 2025-01-24T06:27:28.45+00:00
AllenLiu-MSFT
47,626
Reputation points Microsoft Vendor
0 answers
extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server FileShare d
extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. extensionfactory!ReportManager_0-13!5100!01/24/2025-08:59:30:: w WARN: The extension Report Server FileShare…
asked 2025-01-24T05:55:20.9466667+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, 82%, 19%)' 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)
Shubham Sunil Mehetre-MIBS
0
Reputation points
asked 2025-01-24T05:55:20.9466667+00:00
Shubham Sunil Mehetre-MIBS
0
Reputation points
0 answers
Azure ML Workspace to connect with SQL Server hosted on a VM
Connectivity from Azure ML Workspace Notebook to An SQL Server hosted on Virtual Machine in a separate Vnet running data warehouse SQL Server. The ML workspace has a managed Network. Is it a possible scenario and how?
asked 2025-01-24T00:53:46.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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pravendra Rajput
51
Reputation points
commented 2025-01-24T05:42:45.11+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(281.6, 88%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Saideep Anchuri
1,285
Reputation points Microsoft Vendor
2 answers
Cannot Install SQL 2022 Express -Failing Database Engine and Sever Replication
Hi Everybody, I have trouble installing SQL Server 2022 Express. Also, not possible to uninstall it to make a clean install, but repairing seemed to work at first. When I try to install it, I get the error that the database engine and server…
asked 2025-01-23T18:45:21.82+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(118.4, 94%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOE%3C/text%3E%3C/svg%3E)
Osztheimer Enikő
0
Reputation points
answered 2025-01-24T05:39:42.5733333+00:00
ZoeHui-MSFT
39,971
Reputation points
11 answers
SQL Server 2022 install on Windows 10 fails with error that .NET is not installed, but it is installed and up to date
I have installed SQL Server 2022 Developer edition successfully on a Windows 10 and 11 virtual machine. The issue is that I cannot install it on a physical machine. During the install, I get the following fatal error. I have tried to install the latest…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,066 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,369 questions
asked 2023-03-23T18:04:44.7966667+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(48, 10%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
MJ Skeet
40
Reputation points
answered 2025-01-24T05:33:54.8366667+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(179.20000000000002, 98%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Virender Jain
25
Reputation points