18,229 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

select top results without selecting columns

select top results without selecting columns?

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,968 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,569 questions
asked 2024-06-04T15:25:35.46+00:00
Jonathan Brotto 100 Reputation points
edited the question 2024-06-04T15:35:42.6033333+00:00
Kiran P 865 Reputation points Microsoft Vendor
0 answers

Mssql express installation failure

I am trying to install sql express on my laptop but i am unable to i have attached the error message and error file Summary_DESKTOP-JU2JTT1_20240604_154222.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.
12,968 questions
asked 2024-06-04T14:48:02.3+00:00
Samuel 0 Reputation points
4 answers

create sp to populate table from one db to another

Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync

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,968 questions
Azure Database for PostgreSQL
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,837 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
asked 2024-05-21T02:56:37.6+00:00
Vineet S 205 Reputation points
commented 2024-06-04T14:28:23.0166667+00:00
ShaktiSingh-MSFT 14,081 Reputation points Microsoft Employee
2 answers

Hyper-V SQL can't connect.

I created a Windows 2022 Server VM and Installed Microsoft SQL Server 2022 Standard on that VM. From that VM I can access the SQL server from SSMS without any issues. I cannot however access the SQL server from my desktop. The Hyper-V host machine, 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,968 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,589 questions
asked 2024-02-23T16:37:11.2466667+00:00
JoeW 0 Reputation points
answered 2024-06-04T14:22:02.96+00:00
Christian Lesjak 0 Reputation points
2 answers

Having Trouble installing the SQL Server Integration Services Projects for Visual Studio 2019

I am having trouble installing. Need to do this offline without internet access. Have Visual Studio 2019 installed and was able to get the Analysis Services installed, but Integration Services is not installing: …

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,968 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,476 questions
asked 2024-06-03T14:26:48.4666667+00:00
tbforwork-6882 0 Reputation points
edited an answer 2024-06-04T14:20:21.0333333+00:00
Yitzhak Khabinsky 25,211 Reputation points
0 answers

Could not find any service with display name ‘XCELERAINST ’

Hi Experts, I was trying to install MSSQL 2019 via powershell. During the MSSQL installation we are setting instance service name as XCELERAINST. As per our code we trying to check the service XCELERAINST. If the XCELERAINST service already present then…

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,968 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,352 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,423 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,197 questions
asked 2024-06-04T14:06:43.2333333+00:00
Jimmy Afflick 40 Reputation points
5 answers One of the answers was accepted by the question author.

Named Pipes Provider error 40 connecting to localhost SQL Server (tried all standard resolutions)

I am attempting to create the reporting services database for usage in MECM. The reporting services installed fine (install only), but once I get to the Database tab and try to connect to the database server to create the database, it fails by timing…

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,968 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,837 questions
asked 2021-01-25T01:37:46.97+00:00
Thomas Simon 61 Reputation points
answered 2024-06-04T12:56:31.68+00:00
Robert Wiltjer 0 Reputation points
1 answer

Powershell backup and then send email. send email has issues

<# Script: Backup database with email notification Version 1.3 - May. 31, 2024 This script performs full and transaction log backups of the Mobile database and sends email notifications. #> Variables $serverName = "TFS" $databaseName =…

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,968 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,423 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,197 questions
asked 2024-06-04T07:34:32.9666667+00:00
Dyan Marquez 0 Reputation points
edited a comment 2024-06-04T12:47:40.6166667+00:00
MotoX80 32,331 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to Uninstall SQL Server 2019

I'm trying to uninstall SQL Server 2019 (64-bit) from the Control Panel, but I'm encountering errors during the uninstallation process. I was able to remove all the features, but I received a prompt to restart my system. After restarting, I noticed 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,968 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,569 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
6 questions
asked 2024-06-03T11:48:17.8633333+00:00
Pramod Kumar 20 Reputation points
commented 2024-06-04T12:15:11.0366667+00:00
Pramod Kumar 20 Reputation points
5 answers One of the answers was accepted by the question author.

SSIS Script Task - Edit Script not working

This is a common recurring issue on Microsoft SSIS Projects development IDE on Visual Studio Community 2019 (Windows 10): given a Script Task the edit button that should open a Visual Studio Intance (VSTA) to work on C# code do not react to the click.…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,476 questions
asked 2022-09-30T12:21:07.24+00:00
Paolo Cos 31 Reputation points
commented 2024-06-04T11:51:08.2166667+00:00
Derome, Eric 11 Reputation points
1 answer

SSIS : How to access SharePoint site and load data from SharePoint using SSIS to SQL database ?

Hi All - I am looking for help. I have an requirement of pulling the data from Sharepoint site into SQL database using SSIS. What could be the pre-requisites to build the SSIS package ? Do i need the sharepoint site username and password ? …

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,260 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,968 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,927 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,476 questions
asked 2023-04-11T22:08:00.88+00:00
kkran 831 Reputation points
commented 2024-06-04T11:43:45.3566667+00:00
Mohamed Hussain 0 Reputation points
2 answers

How to deploy a SQLServer with named instances.

I want to create a sqlserver with named instances for developing connectivity from a python client to such instances. Is there a way to do this for free, i.e can i deploy SQL Servers with named instances without any cost for testing purposes.

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,968 questions
asked 2024-06-04T04:26:09.5966667+00:00
kaif khan 0 Reputation points
commented 2024-06-04T10:58:42.3166667+00:00
kaif khan 0 Reputation points
1 answer

Microsoft (R) Visual Basic Compiler asking the upgrade the version.

We are trying to Execute SSRS report using rs.exe and will store result in CSV file. For this We have prepared (.rss) file, and executed from command prompt with following command. rs -i filename.rss -s https://server_name/ReportServer -v…

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,837 questions
.NET F#
.NET F#
.NET: Microsoft Technologies based on the .NET software framework.F#: A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
97 questions
asked 2024-05-29T09:11:40.0433333+00:00
Kalee Mamillapalli 0 Reputation points
commented 2024-06-04T10:05:32.54+00:00
Kalee Mamillapalli 0 Reputation points
2 answers One of the answers was accepted by the question author.

Final result: Failed. Exit code (Decimal): -2064908287. After I deleted all the previous sql and reinstalled it, this error occurs, how can I fix it?

Detail.txt Summary_Duknh_20240603_183710.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.
12,968 questions
asked 2024-06-03T12:04:53.94+00:00
Dukanhh 0 Reputation points
commented 2024-06-04T10:05:08.75+00:00
Dukanhh 0 Reputation points
2 answers

exit code (decimal): -2068052377error description: invalid command line argument. consult the window installer sdk for detailed command line help

This morning I was still able to use sql, I was curious and deleted something like SQLEXPRESS16, then I uninstalled all sql and reinstalled it all, and used quite a few cmd commands that I didn't know to uninstall but still nothing. I can't remove them,…

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,968 questions
asked 2024-05-29T14:08:19.1766667+00:00
Dukanhh 0 Reputation points
commented 2024-06-04T09:31:11.3266667+00:00
MikeyQiaoMSFT-0444 830 Reputation points
1 answer

How to fix Duplicate Output in sql server when using Distinct Create performance Issue

Respected Techie, I am facing very Bizarre issue of Duplicate Record in sql Output. May someone please help me with their expertise. I am very much Thankful for your kind help. The Problem I am facing is I am brining column from multiple dimension table…

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,968 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,569 questions
asked 2024-06-04T05:12:32.3666667+00:00
Uma 426 Reputation points
commented 2024-06-04T07:00:25.7866667+00:00
Olaf Helper 41,891 Reputation points
1 answer

SQL Server 2022 Kurulum Hatası

SQL Server 2022 Detail.txt Summary_DESKTOP-UN0800B_20240602_203435.txt Summary.txt Exit Code (Decimal): -2068052377 Error Description: Geçersiz komut satırı bağımsız değişkeni (Invalid command line argumant)

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,968 questions
asked 2024-06-02T17:55:45.07+00:00
Kadir Veysel SAYAR 0 Reputation points
commented 2024-06-04T06:48:14.08+00:00
MikeyQiaoMSFT-0444 830 Reputation points
2 answers

Power BI Sources and Education

Just looking for some good Power BI resources and education materials...web sites...YouTubes And is there a separate Forum for Power BI? Because I cannot seem to tag anything with "Power BI" here. Thanks in advance for your review and 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.
12,968 questions
asked 2024-05-31T14:03:29.1766667+00:00
Bobby P 221 Reputation points
commented 2024-06-04T06:47:50.34+00:00
MikeyQiaoMSFT-0444 830 Reputation points
3 answers

Help required with SQL Server

Hi Team, Could you please reply to below 2 points - I have a requirement where I need to identify all windows machines where Microsoft SQL Server is installed (any version). To identify I have gone to control panel of each machine(inside uninstall and…

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,968 questions
asked 2024-05-30T10:08:43.63+00:00
Salil Singh 20 Reputation points
commented 2024-06-04T06:46:32.1266667+00:00
MikeyQiaoMSFT-0444 830 Reputation points
2 answers

In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role.

In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role. If yes then what is that. Do I need to install 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.
12,968 questions
asked 2024-05-30T02:59:59.6566667+00:00
Mahesh Kumar 20 Reputation points
commented 2024-06-04T06:45:26.1866667+00:00
MikeyQiaoMSFT-0444 830 Reputation points