18,052 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

SQL Select subquery using exists

I am trying to write a query with a subquery. The subquery returns what is in the attached image below. select top(1) with ties matter_uno, PART_CAT_CODE, EFF_DATE, EMPL_UNO from TBM_CLMAT_PART where MATTER_UNO = 11275 and PART_CAT_CODE = 'BILL' order…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-13T17:35:44.68+00:00
Joseph Mancini 41 Reputation points
answered 2024-05-13T17:44:36.7233333+00:00
Bruce (SqlWork.com) 57,241 Reputation points
0 answers

How to sql dump generation on sql server 2008 ?

Good morning, I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory. Can you give me the procedure to disable the generation of these files please. Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-13T16:40:04.5466667+00:00
Tidiane TRAORE 0 Reputation points
1 answer One of the answers was accepted by the question author.

Keep getting this error regardless to the accoun tused

SQL server 2022 / SSRS 2022, getting this error even when using an admin account An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'AutoGen__5C6349F2_4BB6_4a1b_A16E_8D69795D8602_'.…

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,814 questions
Microsoft Configuration Manager
asked 2024-05-13T01:25:46.7933333+00:00
Belgian Malinois 356 Reputation points
commented 2024-05-13T16:32:12.89+00:00
Belgian Malinois 356 Reputation points
5 answers

SQL SERVER 2022 - certificate error when creating a job for integration services

In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2024-04-10T03:35:21.82+00:00
Marcio Matos 10 Reputation points
edited a comment 2024-05-13T16:10:10.95+00:00
shadowfoxish 0 Reputation points
4 answers One of the answers was accepted by the question author.

SSMS 20 can't show conflict viewer

Hi! Clicking on View conflicts in Object Explorer open Connect to Server dialog form instead of Conflict Viewer. If I fill in form to connect to the same server, it creates very strange error: A connection was successfully established with the server,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-04-05T12:35:44.52+00:00
Nebojsa Ilic 35 Reputation points
commented 2024-05-13T15:28:14.19+00:00
Erin Stellato 486 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

SQL Max(Date) query could return multiple rows

Having a devil of a time trying to find a query to return what I need. I have a table as above. I am trying to use max(eff_date) to return the last record(s). Most of the time, only 1 record will be returned for the max(eff_date), but sometimes, more…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-13T14:12:50.9366667+00:00
Joseph Mancini 41 Reputation points
commented 2024-05-13T15:03:09.8+00:00
Joseph Mancini 41 Reputation points
2 answers

can not start sql server2012.the request failed or ther service did not respond in a timely fashion.

This error will be reported after starting sql server 2012, check the log，Please refer to the following picture to view the log. How to solve it? The description for Event ID 17836 from source MSSQL$MSSQL2012 cannot be found. Either the component that…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-11T04:10:59.0033333+00:00
Han Yang 0 Reputation points
commented 2024-05-13T14:58:47.8866667+00:00
Han Yang 0 Reputation points
2 answers One of the answers was accepted by the question author.

EDI cross reference table

Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2024-04-19T19:37:38.3733333+00:00
Jonathan Brotto 60 Reputation points
accepted 2024-05-13T14:34:58.0033333+00:00
Jonathan Brotto 60 Reputation points
2 answers

SQL2022-SSEI-Expr setup file is not opening

I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-04-24T12:17:54.3266667+00:00
sakib rahman 0 Reputation points
commented 2024-05-13T14:33:14.44+00:00
Oba Eze 0 Reputation points
1 answer

How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11

Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-10T13:49:21.6766667+00:00
Dhamodharan M 0 Reputation points
edited a comment 2024-05-13T14:00:12.6366667+00:00
Dhamodharan M 0 Reputation points
5 answers

How to fix Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException

Issue: ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
Microsoft Configuration Manager
asked 2023-08-16T21:30:00.86+00:00
Vjorn 0 Reputation points
answered 2024-05-13T11:52:34.2833333+00:00
Eric Berkowitz 1 Reputation point
0 answers

Connecting SQL Server Data to RDLC reports in Blazor .Net Framework

Hello, I am trying to create/integrate RDLC reports in Blazor .NET framework. So far: I have managed to open a RDLC report thanks this Question and Answer:…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,422 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,212 questions
Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,406 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.
12,820 questions
asked 2024-05-13T09:36:27.6966667+00:00
Geoffrey de Sousa 0 Reputation points
commented 2024-05-13T11:18:53.5066667+00:00
JasonPan - MSFT 4,381 Reputation points Microsoft Vendor
2 answers

Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.

Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-04T23:34:12.1833333+00:00
Albert Kirpach 0 Reputation points
commented 2024-05-13T10:17:27.3+00:00
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee
2 answers

How can I run an automation template

I want to run an automation template for a sql database deployed with ARM. The aim is to trigger a stored procedure

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,133 questions
asked 2024-05-08T00:16:54.5566667+00:00
Oyin 0 Reputation points
answered 2024-05-13T09:32:20.0466667+00:00
akinbade abiola 465 Reputation points
0 answers

Query ODBC text data using schema.ini and SkipLines, and is the Text Driver still in active development?

We are working on several applications in medical research and we often use the Text Driver to query, import and export data provided through text file datasets. A couple of times now we ran into the issue that for certain text datasets, that the data…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-04-02T08:47:21.8033333+00:00
Bas de Reuver (epi) 0 Reputation points
commented 2024-05-13T09:25:26.0466667+00:00
Bas de Reuver (epi) 0 Reputation points
1 answer

Using SSDT on a build server

I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
971 questions
asked 2024-04-24T19:26:26.72+00:00
Mark DeMichele 0 Reputation points
commented 2024-05-13T08:56:45.4133333+00:00
Tianyu Sun-MSFT 27,546 Reputation points Microsoft Vendor
1 answer

SSRS Report Viewer windows forms - The request failed with an empty response

Dear all, we use the following component in our Windows Form (.net 4.7.2 application): Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1620.0 Since we migrated our server on a new domain, we are getting sometimes the following execption in…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,841 questions
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,814 questions
asked 2024-05-10T13:16:20.6633333+00:00
SERIOLI, MARCO (MSTI) 0 Reputation points
edited a comment 2024-05-13T07:33:50.7866667+00:00
SERIOLI, MARCO (MSTI) 0 Reputation points
2 answers

Msg 319, Level 15, State 1, Line 88 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

Create Table #percentpopulationvaccination ( continent nvarchar(255), location nvarchar(255), date numeric, population numeric, New_vaccinations numeric, rollingpeoplevaccinated numeric, ); Insert Into #percentpopulationvaccination select dea.continent,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2023-03-31T12:41:12.3266667+00:00
pruthvi salian 0 Reputation points
answered 2024-05-13T06:18:08.44+00:00
Sahil 0 Reputation points
2 answers

Switching from SQL Server/CAL based licensing to core based licensing model for all SQL servers

We are using Server+CAL licensing model for all SQL servers in our organization. Due to the limitation of number of cores supported by CAL based license, we are planning to switch to core based license. Upon checking with client, he informed, "Under…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-10T06:34:06.92+00:00
Pratibha 0 Reputation points
commented 2024-05-13T06:11:06.13+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
1 answer

Will there be any problems in directly replacing the version of Log4j.jar from 1.17 to 2.X in SQL Server 2019?

Hi Team, Background: We now have installed Microsoft SQL Server 2019 Express locally. After installation, we found that it automatically uses the Log4j 1.2.17 version jar package. (As shown in the picture.) Since the jar package of Log4j version 1.2.17…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
asked 2024-05-13T02:26:20.46+00:00
Shi Liu 0 Reputation points
answered 2024-05-13T05:55:51.79+00:00
Olaf Helper 41,006 Reputation points