SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
0 answers
How Can I set the right value according to comparison conditition
Hello, i have 2 tables , the first one is a referential of the quality services and the second is a historical tables as bellow the DDL : drop table if exists #oderstatus_quality create table #oderstatus_quality ( id int identity primary key, label…
![](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, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
2 answers
SQL Server Express 2022 Reinstall
Hi I have a question regarding the install process of SQL Server 2022 Express. I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled SQL…
asked 2024-04-19T06:14:14.86+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(224.00000000000003, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Francois Timms
0
Reputation points
answered 2024-04-25T07:16:22.57+00:00
Francois Timms
0
Reputation points
1 answer
DCI Client Level Reporting Not Available
Is there any plan to fix the following error: The item '/DCI/DCI_Client_Level' cannot be found. (rsItemNotFound) Get Online Help for the Digital Contact Data reporting at a client level? This error is consistent across many representatives and has been…
asked 2024-04-12T13:43:30.3566667+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(208, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHT%3C/text%3E%3C/svg%3E)
Hilton, Tyler
0
Reputation points
answered 2024-04-25T07:15:54.6766667+00:00
Greg Low
1,485
Reputation points Microsoft Regional Director
2 answers
One of the answers was accepted by the question author.
Syntax to PRINT the row counts using Dynamic SQL?
Hello, what would be the syntax to PRINT the row counts using Dynamic SQL (in my case here need to get the row counts via a Linked Server View) I would like to have this as a step in a SQL Agent job which after it runs it PRINTs the row counts in it's…
asked 2024-04-24T18:57:32.9433333+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(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,766
Reputation points
accepted 2024-04-25T07:07:17.2066667+00:00
techresearch7777777
1,766
Reputation points
1 answer
The 'Publish and Subscribe' feature does not work on SQL Server2019 installed using Docker technology on Linux
Database server information : Linux (Rocky 9.1) , Podman platform install (A kind of docker technology),SQLServer 15.0.4033.1(2019)，docker image downloaded from the microsoft website,The service startup command is: podman run --name mssql2019 --net=host…
![](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, 97%, 27%)' 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)
1 answer
Error loading report.rdlc,Unable to copy bin\debug\
Good afternoon again, I have already searched for information online, but I have not been able to find the error. The error is the following: An error occurred during local report processing. The report definition has not been specified, the file is not…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,827 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,798 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.
10,234 questions
asked 2024-04-24T20:48:56.4066667+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(134.4, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Roberto Carlos Melgar Dorado
40
Reputation points
commented 2024-04-25T07:04:37.24+00:00
Greg Low
1,485
Reputation points Microsoft Regional Director
0 answers
My emails have completely disappeared off my iPhone and I can’t get it back
I believe since the update I can’t access my Hotmail account and it displays the above messages, I have tried deleting and reinstalling but that haven’t worked my emails say connection to the server has failed
![](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, 14.000000000000002%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
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
asked 2024-04-24T12:17:54.3266667+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(124.80000000000001, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
sakib rahman
0
Reputation points
answered 2024-04-25T06:51:23.69+00:00
MikeyQiao-MSFT
485
Reputation points Microsoft Vendor
0 answers
analysis services pivot taking a long time to refresh
We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What…
asked 2024-04-24T14:37:25.1533333+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, 4%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tina Douglass
1
Reputation point
commented 2024-04-25T06:49:38.45+00:00
Greg Low
1,485
Reputation points Microsoft Regional Director
1 answer
Logic app to on-premise SQL server connectivity using service principle (Azure AAD)
Hi Team, Our Agenda is to connect On-premise SQL server using Logic app with SQL server connector. We successfully setup Azure AAD with On-premise SQL. Also, using SSMS we are successfully able to make connection to on-premise SQL using service…
asked 2024-04-23T10:59:34.03+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(96, 42%, 19%)' 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)
Yashwant Kumar Sahu
16
Reputation points
answered 2024-04-25T06:44:55.2533333+00:00
Greg Low
1,485
Reputation points Microsoft Regional Director
3 answers
One of the answers was accepted by the question author.
Locking comparison SQL Server 2017 versus SQL Server 2022
We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…
asked 2024-04-22T12:53:22.4133333+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, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Paolo Taverna
71
Reputation points
commented 2024-04-25T06:40:43.55+00:00
Greg Low
1,485
Reputation points Microsoft Regional Director
2 answers
how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on…
asked 2024-04-24T08:07:29.2066667+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, 38%, 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)
sharuk
0
Reputation points
commented 2024-04-25T06:32:54.17+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,271
Reputation points Microsoft Employee
3 answers
Microsoft sql studio - dark mode enabling.
do we have a dark mode on Microsoft SQL Server Management Studio ?, of so, can anyone help me on how to get that enabled.
asked 2024-04-23T22:11:21.2133333+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(70.4, 70%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
willjim
0
Reputation points
edited an answer 2024-04-25T06:26:57.6933333+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
2 answers
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named 'user' with columns 'username' and 'role'. The objective is to establish a security model where access to individual rows is controlled based on the role assigned…
asked 2024-04-24T11:39:39.74+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(140.8, 16%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lộc Nguyễn
0
Reputation points
commented 2024-04-25T05:44:27.98+00:00
Olaf Helper
40,741
Reputation points
2 answers
VIEW SERVER STATE vs DB role for DMV on master
Hi, I have a logging procedure that reads from the two tables on master: sys.dm_exec_connections sys.dm_exec_sessions I had to assign permissions to a group for correct execution: GRANT VIEW SERVER STATE TO [domain\mygroup]; but I didn't want…
asked 2024-04-24T08:29:59.1+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(268.8, 60%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alen Cappelletti
891
Reputation points
edited an answer 2024-04-25T05:29:02.2533333+00:00
LucyChen-MSFT
885
Reputation points Microsoft Vendor
1 answer
Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server
In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…
asked 2024-04-24T13:45:40.7233333+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(262.40000000000003, 27%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
ylycfj88
0
Reputation points
answered 2024-04-25T05:15:43.54+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
9,445
Reputation points Microsoft Vendor
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…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,602 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,691 questions
asked 2024-04-24T19:26:26.72+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(313.6, 95%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mark DeMichele
0
Reputation points
edited an answer 2024-04-25T04:51:16.41+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
27,266
Reputation points Microsoft Vendor
1 answer
SQL server backup in a 2019 VM to s3 using backup URL
Hi I have set up a Windows Server 2019 VM with SQL server 2016. I want to take the backup of SQL server in AWS S3. It should have monitoring and auditing capability and cost effective and secure. I have looked at below…
asked 2024-04-18T04:47:01.0433333+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, 25%, 27%)' 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)
Pradeep
21
Reputation points
commented 2024-04-25T02:58:23.2+00:00
LucyChen-MSFT
885
Reputation points Microsoft Vendor
3 answers
GDR upgrade path question
I have a SQL Server updated to version 15.0.4326.1, which is on the GDR path but on a GDR + CU version. Can I install the next update on the GDR path to go to version 15.0.2110.4 that is GDR only, or do I have to install the next GDR + CU update?
asked 2024-04-15T20:47:18.0366667+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, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ryan Schmitz
0
Reputation points
commented 2024-04-25T02:57:29.71+00:00
LucyChen-MSFT
885
Reputation points Microsoft Vendor
3 answers
Tail log backup
Are tail log backups supported only in Full Recovery model?
asked 2024-04-16T14:09:24.11+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(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
696
Reputation points
commented 2024-04-25T02:56:38.69+00:00
LucyChen-MSFT
885
Reputation points Microsoft Vendor