SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,899 questions
Content
1 answer
C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230921_143255
SQLServer_ERRORLOG_2023-09-21T14.35.02.txt SQLServer_ERRORLOG_2023-09-21T14.35.00.txt SQLServer_ERRORLOG_2023-09-21T14.35.02.txt
asked 2023-09-21T12:44:06.8633333+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(112.00000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERQ%3C/text%3E%3C/svg%3E)
rashed qazizada
0
Reputation points
answered 2023-09-21T13:26:59.79+00:00
Olaf Helper
33,346
Reputation points
1 answer
SQL : Send email via DB mail based on the row count mismatch.
Hi All - I have written a stored procedure and it sends out an email to users in the below format. Its basically the row count between three systems ( Oracle, STAGE, SDS). Currently, the email is sent every hour, but the user wants to get an email only…
asked 2023-09-20T15:08:40.13+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(284.8, 36%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
kkran
771
Reputation points
edited an answer 2023-09-21T13:05:30.6966667+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, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
23,141
Reputation points
1 answer
Delete Ploybase dump files in SQL Server2019, is it affect Database or performance of sever
Hi Team, We have a Server 2019, includes SQL Server 2019 with 4 instances, in one instance C:\Program Files\Microsoft SQL Server\MSSQL15.SGSFAROOJ\MSSQL\Log\Polybase\dump have 500GB size. We are not using Polybase services. So if we delete those logs,…
asked 2023-09-21T12:38:49.9533333+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, 0%, 36%)' 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)
Shabin Suresh
101
Reputation points
answered 2023-09-21T12:41:31.4366667+00:00
Shabin Suresh
101
Reputation points
2 answers
One of the answers was accepted by the question author.
Can we refresh/overwrite SQL Server Reporting databases.
Can we refresh SQL Server Reporting databases. We are in the process of the migration of reports from SQLServer 2016 to SQLServer 2019. Week back we copied the reporting databases to another server and configured the reporting services then released for…
![](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(249.60000000000002, 37%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
4 answers
One of the answers was accepted by the question author.
Create assembly in SQL Server from C# dll
I write c# code with these references: using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Net; I build this in a dll file that I want to use to create a assembly in sql…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,899 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.
8,941 questions
asked 2021-01-04T16:30:18.217+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(284.8, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Eric Bezemer
181
Reputation points
commented 2023-09-21T11:44:33.1133333+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, 97%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Gadipudi, Tushara
0
Reputation points
0 answers
Deploy an asp.net core API on a Linux server with nginx
hi I followed your tutorial on deploying an asp.net core API and I followed the same logic to deploy my API on an ubuntu server with Nginx, it happens that locally I access the API from the development environment, and even from another machine on the…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
582 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
3,541 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.
10,899 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.
8,941 questions
Microsoft Intune Linux
Microsoft Intune Linux
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Linux: A family of open-source Unix-like operating systems.
23 questions
asked 2023-09-21T11:42:05.2133333+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(224.00000000000003, 96%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marnelle M'BENGUET
0
Reputation points
asked 2023-09-21T11:42:05.2133333+00:00
Marnelle M'BENGUET
0
Reputation points
1 answer
One of the answers was accepted by the question author.
left join to insert
hello, I would like to return all rows from "Logins" which are not present in "tbl_LoginIdCount" It's just that I run this once and insert into compute."tbl_LoginIdCount" but then when I run the same query again the select…
![](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(262.40000000000003, 97%, 35%)' 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)
2 answers
How to read SQL Trace(.trc) or Extended events file(.xel) for SQL server 2022 in c#.net
Hi Team, We need a help on parsing the data from SQL trace file(.trc) or Extended Events file (.xel) in C# application. Required for SQL server 2017 to SQL 2022 Could you please guide us how to do that? Regards, Deepak Rane
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,899 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.
8,941 questions
asked 2023-09-20T08:52:00.1866667+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, 13%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Deepak Rane (drane)
0
Reputation points
commented 2023-09-21T11:24:29.56+00:00
Dan Guzman
7,621
Reputation points
0 answers
Private endpoint as cloud witness for clustering supported ?
Windows cluster in Azure , two VMS ( for now ) Storage account standard gen 2 with min TLS 1.0 ( just in case ) and network access cut ( only to be done via PE) Private endpoint lies in a nearby subnet of the source, auto approved, dns registered.…
asked 2023-09-14T19:07:44.4666667+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(9.6, 56.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Andrei Bathory
0
Reputation points
commented 2023-09-21T11:07:44.8666667+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(128, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Ramya Harinarthini_MSFT
3,816
Reputation points Microsoft Employee
1 answer
How can I create a Complex View Like this one in WPF DataGridView C#?
I created this Example and Tried to make it as Simple as Possible so that you can Understand Clearly. I have SQL Server Database Named EmployeesDB that contains 4 Tables as following: 1. Employees Table which is the Parent Table in this Example. 2.…
Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,474 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
3,763 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.
10,899 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.
8,941 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(16, 56.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
2 answers
How to fix "Unable to install SQL Server (setup.exe) Exit Code (Decimal): -2061893607Error description: Could not find the Database Engine startup handle."
Hi, I keep getting this problem when trying to install the SQL Server (Express Edition) through basic installation. Here are the Summary.txt and Detail.txt. Really need to get this fixed as soon as possible, I appreciate any help.
![](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(80, 47%, 17%)' 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)
1 answer
One of the answers was accepted by the question author.
Unpivot result with null value
Referring to this post: pivot/unpivot my table. create table TableA( ECODE char(2) NULL, MEM1 int NULL, MEM2 int NULL, MEM3 int NULL); insert into TableA values ('AA',6234,null,2354), ('BB',null,3568,4564), ('CC',1023,3941,null); Suppose I want…
![](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(6.4, 26%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Power BI Report Server MSSQL server collation
What is the required MSSQL server collation for Power BI Report Server or SSRS?
![](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(150.4, 62%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
0 answers
Upgrade sql server 2012 Business Intelligence to SQL 2016
Hi All, We have SQL 2012 Business Intelligence instance and we are trying to upgrade SQL 2016 Enterprise as one of below link says suitable for as…
asked 2023-09-20T13:20:14.6833333+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, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Balaji Konkoni
0
Reputation points
commented 2023-09-21T08:27:20.8666667+00:00
Balaji Konkoni
0
Reputation points
1 answer
Differences Between CDC, Trigger, and Transaction Log Replication
Differences Between CDC, Trigger, and Transaction Log Replication Hello. While operating SQL SERVER, I'm currently researching CDC, Trigger, and Transaction Log Replication for data synchronization. All three methods are used for data synchronization,…
asked 2023-09-19T23:07:07.48+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, 4%, 17%)' 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)
고민재
0
Reputation points
commented 2023-09-21T07:44:07.27+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(230.39999999999998, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AniyaTang-MSFT
9,276
Reputation points Microsoft Vendor
2 answers
How to fix data convertion error from string value to int in ssis
Currently, I am working on a task where I am using the "SSIS Integration Toolkit for Microsoft Dynamics 365" to fetch data from online dynamic CRM source and populate this to on prem CRM database(just a copy activity). I am using dynamic crm…
asked 2023-09-20T17:25: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(201.6, 1%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Avijit Swarnakar
0
Reputation points
commented 2023-09-21T06:49:58.71+00:00
Avijit Swarnakar
0
Reputation points
2 answers
After upgrading SQL Server and Reporting Services to 2019 the report viewer no longer displays on the web pages.
Morning After upgrading SQL Server and Reporting Services to 2019 the report viewer no longer displays on the web pages. It appears as thought the web pages no longer recognise the report viewer control. I have removed references to the old report…
asked 2023-09-20T22:54:04.92+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, 31%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Marc Brierley
0
Reputation points
answered 2023-09-21T06:38:38.3+00:00
AniyaTang-MSFT
9,276
Reputation points Microsoft Vendor
1 answer
How to upgrade sql server 2012 express edition to sql server 2017 standard edition
I order a sql server 2022 standard edition license. The license key should suppose to be used in sql server 2017 standard edition. I already have a sql server 2012sp4 express edition system. During upgrade from sql server 2012sp4 express edition to sql…
asked 2023-09-11T04:02:05.2366667+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, 87%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Doctor Hung
0
Reputation points
commented 2023-09-21T06:37:20.91+00:00
Doctor Hung
0
Reputation points
2 answers
Why does connection to local server take so long?
When I use SSMS and bcp tool, if I want to connect to a network SQL Server, I can connect really fast. It doesn't matter if its windows auth or SQL Server auth. It all works really well. But when my server = (localdb)\MSSQLLocalDb and Windows auth, it…
asked 2023-09-20T23:46:50.8+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, 94%, 36%)' 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)
Coreysan
1,326
Reputation points
answered 2023-09-21T06:23:02.4133333+00:00
ZoeHui-MSFT
25,301
Reputation points
2 answers
For Database scenarios showing “Out of Memory” exception how to fix in sql server step by step? memory space also available
For Database scenarios showing “Out of Memory” exception how to fix in sql server step by step? memory space also available.
asked 2023-09-21T02:12:02.56+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, 86%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NN
0
Reputation points
answered 2023-09-21T06:20:01.0433333+00:00
CosmogHong-MSFT
14,591
Reputation points Microsoft Vendor