SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,833 questions
0 answers
SQL 2016 Linked Server Problems
I am trying to setup a linked server connection to another DB running a non-MSSQL DB. On the local server the account I am using has Sysadmin right on the remote server the local DB account has what they call Admin rights as well. We have tried using…
![](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(236.8, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)
2 answers
How do I hide subreport option from the Reportin g Services screen?
I am a SSRS newbie, so pardon simple questions. I created two main reports. One report has hidden reports within. The other report has sub-reports. When I deployed the programs to Reporting Services, the sub-reports appear as selection options. How do I…
asked 2024-05-14T17:35:37.34+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(259.20000000000005, 71%, 35%)' 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)
Stephen Schleyer
40
Reputation points
commented 2024-05-15T20:26:26.93+00:00
Stephen Schleyer
40
Reputation points
2 answers
set order by based on asc series
Hello This is my sql table with data /****** Object: Table [dbo].[temp_days_order_pending] Script Date: 05/15/2024 23:12:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE…
asked 2024-05-15T17:50:11.12+00:00
RAVI
916
Reputation points
answered 2024-05-15T18:23:28.7566667+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(86.4, 13%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gowtham CP
700
Reputation points
0 answers
Custom skill integration Azure AI Search
0 I have a requirement to crawl an Azure SQL server from Azure AI search. The SQL server exists in different VNET and I have created a Shared Private Link to connect. The Indexer works fine without any problem. As soon as I add a custom webapi skill the…
asked 2024-05-15T18:18:35.6533333+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(259.20000000000005, 2%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Somdeep Niyogi (external)
1
Reputation point
asked 2024-05-15T18:18:35.6533333+00:00
Somdeep Niyogi (external)
1
Reputation point
0 answers
We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work
Hi We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work. We have come across documention which says its has limitations onwiht regards to publisher/subscriber and…
![](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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
0 answers
Emoji Rendering Issues in SSRS-Generated PDF
I'm encountering issues with emoji representation in PDF and PowerPoint outputs from SQL Server Reporting Services (SSRS). Despite successfully displaying emojis in Word documents that are rendered through SSRS, the same emojis are not appearing…
asked 2024-05-15T15:48:05.93+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(169.60000000000002, 69%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Abdullah Riaz
0
Reputation points
asked 2024-05-15T15:48:05.93+00:00
Abdullah Riaz
0
Reputation points
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
![](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, 0%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
![](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, 31%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
2 answers
Assembly 'system.net.http, version=4.0.0.0' was not found in the SQL catalog error
I created a SQL C# CLR Stored Procedure project and when trying to publish it the SQL Server (15.0.4335.1) I got this error: (47,1): SQL72014: .Net SqlClient Data Provider: Msg 6503, Level 16, State 12, Line 1 Assembly 'system.net.http, version=4.0.0.0,…
asked 2024-03-29T14:32:39.2433333+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(176, 11%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nguyen, David V
1
Reputation point
commented 2024-05-15T14:29:13.24+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(198.4, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Samyn Axel
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Add grand total of stack bar report in SSRS
Hi Team, How to add grand total in chart reports. I need grand total as highlighted in out put screenshot Input Chart: Out put :
asked 2020-12-04T04:14:59.763+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, 0%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Bala Narasimha Challa
466
Reputation points
commented 2024-05-15T14:27:18.7133333+00:00
Christopher George
0
Reputation points
0 answers
Microsoft programmability model that
libraries to access data on Microsoft 365 services.
![](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(272, 49%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
2 answers
install SQL SERVER 2022 Express Edition A required file could not be downloaded
I tried to install SQL SERVER 2022 Express Edition, and this is the message I get: Oops... A required file could not be downloaded.This could mean the version of the installer is no longer supported.Please download again from the download site. I do have…
asked 2024-03-24T19:15:25.8833333+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(163.2, 7.000000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYL%3C/text%3E%3C/svg%3E)
Yasmine LAKRIB
0
Reputation points
edited an answer 2024-05-15T13:48:44.32+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(211.20000000000002, 46%, 30%)' 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)
AbdallaMon
0
Reputation points
1 answer
Migrating On-prem Sql DB to Azure Managed Sql Instance
Hello, I have created recently Azure Managed Instance and looking some expert guidance as I need to restore on-prem Database first for testing but my database is in simple recovery mode as it's non-prod DB. Do I need to change recovery model to FULL then…
asked 2024-05-14T22:06:14.8033333+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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
391
Reputation points
commented 2024-05-15T11:28:29.0666667+00:00
Erland Sommarskog
102K
Reputation points MVP
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…
asked 2024-05-11T04:10:59.0033333+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, 89%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
Han Yang
0
Reputation points
commented 2024-05-15T11:05:37.2333333+00:00
Erland Sommarskog
102K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
How to pass ADF parameter values or System Function values as input parameter to a Stored Procedure that is dynamically invoked based on pipeline parameter based on an input json metadata?
As per this URL one can invoke any SP dynamically by passing any parameters. But the challenge is when you want to pass on a ADF system variable or value from any other ADF variable/parameter to the dynamically fed in Input parameter of SPs, there is a…
asked 2024-01-02T09:54:00.87+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(108.80000000000001, 48%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
George, Nitin Mathew
20
Reputation points
commented 2024-05-15T10:04:26.5933333+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(166.4, 79%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Arlind Tahiri
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Warning 26003 support files can not uninstalled
While uninstalling MS SQL showing warning 26003 , Support files can not uninstalled.
asked 2024-01-13T05:35:51.5933333+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, 79%, 10%)' 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)
Yogesh Kashid
20
Reputation points
commented 2024-05-15T09:26:52.7466667+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(131.20000000000002, 73%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Schreuder, Camiel
0
Reputation points
2 answers
I have a problem with the SQL server. The connection is disconnected. Sometimes I looked in the events. The code prints event 17886.
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="MSSQLSERVER" /> <EventID Qualifiers="49152">17886</EventID> …
asked 2024-05-14T06:51:54.7566667+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(281.6, 22%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
saleh ahmed
0
Reputation points
answered 2024-05-15T06:13:59.7066667+00:00
MikeyQiao-MSFT
575
Reputation points Microsoft Vendor
1 answer
I am facing Issues for data replication of specific tables (Bi-Directional) in SQL databases at two different regions hosted on Azure Cloud.
Hi, I have SQL Databases in Europe Region & USA Region hosted on Microsoft Azure cloud. I want to sync specific tables of both databases. I have researched about database replication approach (Transactional Replication, Snapshot Replication,…
asked 2024-05-09T18:23:13.1233333+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(115.19999999999999, 50%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Raj, Ritu
20
Reputation points
commented 2024-05-15T06:05:28.2666667+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,826
Reputation points Microsoft Employee
4 answers
How to restore SQL server 2019 database backup (.bak) to SQL server 2017.
Hi, In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. …
asked 2024-05-14T05:26:36.97+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, 83%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shyam Kumar
0
Reputation points
answered 2024-05-15T05:03:15.03+00:00
yunus emre ISIK
171
Reputation points
2 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.
asked 2024-05-13T16:40:04.5466667+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(16, 49%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tidiane TRAORE
0
Reputation points
commented 2024-05-15T03:24:51.8+00:00
LucyChen-MSFT
1,280
Reputation points Microsoft Vendor
1 answer
Encrypt a SQL session with PowerBI Desktop
I want to connect to a local SQL Server database, using Power BI Desktop. On the SQL Server instance encryption has been enforced. When I make the connection Power BI Desktop keeps telling that it cannot make a connection because encryption is not…
asked 2024-05-14T09:38:46.7366667+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(16, 74%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEV%3C/text%3E%3C/svg%3E)
Erik Verheuvel
41
Reputation points
answered 2024-05-15T03:16:05.0766667+00:00
ZoeHui-MSFT
33,386
Reputation points