Microsoft Q&A

SQL Server

17,698 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

17,698 questions with SQL Server-related tags

Sort by: Updated
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

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
asked 2023-09-21T12:44:06.8633333+00:00
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…

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
asked 2023-09-20T15:08:40.13+00:00
kkran 771 Reputation points
edited an answer 2023-09-21T13:05:30.6966667+00:00
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,…

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
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
10,541 questions
asked 2023-09-21T12:38:49.9533333+00:00
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…

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,545 questions
asked 2023-09-20T10:20:03.7466667+00:00
Sai G 21 Reputation points
accepted 2023-09-21T11:49:02.0733333+00:00
Sai G 21 Reputation points
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
Eric Bezemer 181 Reputation points
commented 2023-09-21T11:44:33.1133333+00:00
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
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…

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
asked 2023-09-20T08:31:39.54+00:00
arkiboys 8,961 Reputation points
accepted 2023-09-21T11:41:30.8366667+00:00
arkiboys 8,961 Reputation points
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
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.…

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,109 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
379 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
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
875 questions
asked 2023-09-14T19:07:44.4666667+00:00
Andrei Bathory 0 Reputation points
commented 2023-09-21T11:07:44.8666667+00:00
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
asked 2023-09-20T09:04:32.94+00:00
Mesh Ka 140 Reputation points
commented 2023-09-21T10:58:19.31+00:00
Mesh Ka 140 Reputation points
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.

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
asked 2023-09-18T07:57:58.47+00:00
JDK246 0 Reputation points
commented 2023-09-21T09:50:00.0833333+00:00
JDK246 0 Reputation points
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…

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
asked 2023-09-21T08:34:17.3733333+00:00
Lylyy 100 Reputation points
accepted 2023-09-21T09:30:55.3+00:00
Lylyy 100 Reputation points
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?

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,545 questions
asked 2023-09-21T08:07:45.63+00:00
Buddha Li 0 Reputation points
accepted 2023-09-21T09:06:47.25+00:00
Buddha Li 0 Reputation points
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…

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
asked 2023-09-20T13:20:14.6833333+00:00
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,…

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
asked 2023-09-19T23:07:07.48+00:00
고민재 0 Reputation points
commented 2023-09-21T07:44:07.27+00:00
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…

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
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,224 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
431 questions
asked 2023-09-20T17:25:25.2733333+00:00
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…

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,545 questions
asked 2023-09-20T22:54:04.92+00:00
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…

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
asked 2023-09-11T04:02:05.2366667+00:00
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…

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
asked 2023-09-20T23:46:50.8+00:00
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.

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
asked 2023-09-21T02:12:02.56+00:00
NN 0 Reputation points
answered 2023-09-21T06:20:01.0433333+00:00
CosmogHong-MSFT 14,591 Reputation points Microsoft Vendor