7,076 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
5 answers One of the answers was accepted by the question author.

Exit code (Decimal): -2068052377Error Invalid command line argument. Consult Windows Installer SDK..please help me fixing this

Log folder path C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220218_192800

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2022-02-18T14:25:57.053+00:00
Raman R 51 Reputation points
commented 2024-10-10T19:58:54.55+00:00
Erland Sommarskog 111.4K Reputation points MVP
2 answers One of the answers was accepted by the question author.

whats the limit of nvarchar in SQL Server 2014?

I would like know how many characters can be saved in a nvarchar column in older sql server versions

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2024-10-09T10:39:32.83+00:00
Wueest Alois 20 Reputation points
commented 2024-10-09T20:59:19.2166667+00:00
Erland Sommarskog 111.4K Reputation points MVP
2 answers One of the answers was accepted by the question author.

report server service management pages not showing

I'm trying to get SSRS installed. Everything appears to be working, but I cannot browse to the Web Service URL. By contrast, I can access the Web Portal URL (though there are no reports published currently). Am I missing a setting?

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,924 questions
asked 2024-10-07T18:29:54.7033333+00:00
Oblio 21 Reputation points
accepted 2024-10-09T14:16:12.2666667+00:00
Oblio 21 Reputation points
4 answers One of the answers was accepted by the question author.

What does ADF SSIS Error "Disk Full Exception Caught" mean

Hi, we are running an Azure-SSIS Type Integration Runtime in Azure Data Factory. This morning this IR suddenly got Unavailable for some reason. Fortunately we had the Diagnostic Settings ADFSSISIntegrationRuntimeLogs enabled and I found the following…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,701 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,578 questions
asked 2024-09-25T10:26:26.61+00:00
Cedric Ahlers 55 Reputation points
commented 2024-10-09T13:55:01.8733333+00:00
Cedric Ahlers 55 Reputation points
2 answers One of the answers was accepted by the question author.

Is it good to use single database connection for all database operations in one API request?

In general, I know the best practice while handling database connections in C#/ADO.NET is to open Db connection just before querying the Db & close the connection immediately after query execution, so that connection gets back to pool. My question…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2024-09-30T18:48:01.8833333+00:00
Abhilash Perla 20 Reputation points
commented 2024-10-09T13:27:19.58+00:00
Abhilash Perla 20 Reputation points
2 answers One of the answers was accepted by the question author.

why does my 7:45am ssrs subscription run twice - at 2am and 7:45am?

I have a data driven subscription set to run at 7:45 am, however, noticed that the report run at 2am and 7:45am. can't seem to know what the problem is. any help will be appreciated. here is my schedule.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,086 questions
Windows 365 Business
Microsoft Configuration Manager
asked 2024-09-23T09:26:50.6566667+00:00
Ijeoma Nmaju 21 Reputation points
accepted 2024-10-09T11:18:16.88+00:00
Ijeoma Nmaju 21 Reputation points
7 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
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,123 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.
13,818 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,639 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR 130 Reputation points
commented 2024-10-09T10:08:35.4633333+00:00
Pedro Valente 0 Reputation points
3 answers One of the answers was accepted by the question author.

how to export stored procedure data with headers into a xls file in sql server?

Hi every MS Sql server user . I have a stored procedure in my server that make a lot of join and in the result shows them. Now I want to make a job in the server and this job should run this SP and copy the results into a xls file.I have seen a lot of…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2024-10-03T05:54:01.9133333+00:00
Farshad Valizade 461 Reputation points
commented 2024-10-09T08:22:16.01+00:00
Farshad Valizade 461 Reputation points
1 answer One of the answers was accepted by the question author.

Powersehell command invoke-sqlcmd command is looking for an additional parameter TrustServerCertificate=True on Windows 2022 server

Hi there, We heavily use PowerShell scripts to query Microsoft SQL Server databases on Windows 2016 machines using a command invoke-sqlcmd -ServerInstance <servername> -Database <databasename> -Query <Query statement>; While testing…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,086 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,526 questions
asked 2024-10-07T16:10:36.2666667+00:00
Suresh 20 Reputation points
commented 2024-10-08T21:18:31.87+00:00
Suresh 20 Reputation points
4 answers One of the answers was accepted by the question author.

SQL 2019 : Json Data in Resultset gets truncated

Hi, I am using SQL 2019. I have a table where I have a large number of rows (around 100K+). I want to leverage on SQL to return the data in JSON format. I have used both FOR JSON AUTO & for json path, Root('Data'), but my results are getting…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2022-11-06T12:31:36.953+00:00
Soni Samuel Panackacheril 66 Reputation points
commented 2024-10-07T15:33:23.1866667+00:00
Rafael Gálvez Martínez 0 Reputation points
1 answer One of the answers was accepted by the question author.

Executing parameterized query with spatial functions

We want to use SET PARAMETERIZATION FORCED on a DB due to unstable Plan Cache caused by third party applications like https://geoserver.org/ and https://mapserver.org/ We have tables with spatial data and when querying them with spatial functions then we…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2024-10-04T13:07:58.2733333+00:00
Peter Riis 20 Reputation points
commented 2024-10-07T06:49:32.82+00:00
Erland Sommarskog 111.4K Reputation points MVP
1 answer One of the answers was accepted by the question author.

How can I delete this list?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2024-10-06T08:46:24.25+00:00
KaiiKaii 20 Reputation points
accepted 2024-10-07T05:57:21.89+00:00
KaiiKaii 20 Reputation points
2 answers One of the answers was accepted by the question author.

Calculate time duration

I have a table with status_id and time column. Need to calculate time duration of status=1. Sample data like this: CREATE TABLE #Temp (Id int, status_id int, [Time] DateTime); INSERT INTO #Temp VALUES (1, 0, '2023-10-13 05:23:19.433'), (1, 1,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2023-09-29T09:31:01.69+00:00
Lylyy 380 Reputation points
answered 2024-10-06T13:00:02.09+00:00
Peter Jonson 0 Reputation points
2 answers One of the answers was accepted by the question author.

Questions About Sorting

Suppose I have this table in an SQL Server database: CREATE TABLE Widgets ( WidgetID INT, .... ) and I use this stored procedurre to retrieve the data: SELECT WidgetID .... FROM Widgets ORDER BY WidgetID In my application I get 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.
13,818 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,727 questions
asked 2024-08-01T05:38:21.34+00:00
RogerSchlueter-7899 1,321 Reputation points
accepted 2024-10-05T20:41:22.59+00:00
RogerSchlueter-7899 1,321 Reputation points
4 answers One of the answers was accepted by the question author.

Sql backup into Azure Blob fails: 1117(The request could not be performed because of an I/0 device error.)

I am trying to run a backup from our sql server to a blob azure container. I went ahead and did the setup exactly as suggested by…

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.
13,818 questions
asked 2024-02-21T09:29:58.56+00:00
Andreas Niedermann 20 Reputation points
answered 2024-10-04T11:53:17.8133333+00:00
Joby Mathew 5 Reputation points
1 answer One of the answers was accepted by the question author.

SQL query left Join

I have sample data like this DECLARE @TBL TABLE(col1 VARCHAR(100),col2 varchar(100)) INSERT INTO @TBL VALUES ('server-1','11111') INSERT INTO @TBL VALUES ('server-2','22222') INSERT INTO @TBL VALUES ('server-3','33333') INSERT INTO @TBL VALUES…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
asked 2024-10-04T01:08:24.86+00:00
Handian Sudianto 4,976 Reputation points
accepted 2024-10-04T06:43:46.64+00:00
Handian Sudianto 4,976 Reputation points
2 answers One of the answers was accepted by the question author.

Suggest a way to replicate data from on premise sql server 2019 to azure synaspe analytics directly

Im using an sql server in my on premise with version 2019, I need to transfer or replicate real time data to azure synapse database, so which azure service will be more effective and flexible for large data transfer

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,921 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.
13,818 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,701 questions
asked 2024-09-26T14:30:15.38+00:00
AGP 40 Reputation points
commented 2024-10-03T21:15:47.0133333+00:00
Erland Sommarskog 111.4K Reputation points MVP
2 answers One of the answers was accepted by the question author.

How to add 100 plus source link in ADF pipeline to transfer data to single destintion.

I need to transfer data from multiple source sql servers( almost 100 plus) to a single destination using ADF, Is there is any way to add these much servers to ADF as source

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,921 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.
13,818 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,701 questions
asked 2024-09-29T13:21:02.1033333+00:00
AGP 40 Reputation points
accepted 2024-10-03T18:53:06.7366667+00:00
AGP 40 Reputation points
2 answers One of the answers was accepted by the question author.

Comparison of actual database schemas against each other (within one database)

Hi all, for a small project I created a database within Azure and one schema for dev and one for prod (to save run cost). I would like to compare these two schemas now with Azure Data Studio, but it looks like, that I can only compare databases with one…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
114 questions
asked 2024-08-17T10:10:18.3266667+00:00
Maximilian Ksoll 20 Reputation points
commented 2024-10-03T18:06:47.1133333+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Allocated vs. Used Memory in SQL Server Elastic Pool

Hello! I’m seeking help regarding the reduction of allocated space in databases within an SQL Server elastic pool. The allocated space in the elastic pool I'm using is significantly larger than the actual used space (due to recent deletions of deprecated…

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.
13,818 questions
asked 2024-10-01T00:41:03.21+00:00
Sinara Medeiros 20 Reputation points
accepted 2024-10-02T19:54:25.6133333+00:00
Sinara Medeiros 20 Reputation points