ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,585 questions
0 answers
How can I convert from SQL Server ORDER BY [Date] ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW to LinQ Query?
I have a SQL query and want to convert it to LINQ. It would be great if some experienced people could help. CREATE TABLE [dbo].[tbl_payment]( [Id] [int] IDENTITY(1,1) NOT NULL, [Companyid] [int] NULL, [Date] [datetime] NULL, [PaymentAmount]…
![](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(300.8, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
SQL Server Filestream error message The system cannot find the path specified
Using SQL Server 2022 Standard Edition. SQL Server runs on Windows Server SRVSQL. The software client runs Windows Server SRVAPP. When i run our software client on Windows Server SRVSQL the Filestream Documents can be saved in the SQL Server. If i run…
asked 2025-01-28T14:45:08.91+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
96
Reputation points
commented 2025-01-31T11:42:48.9033333+00:00
Paolo Taverna
96
Reputation points
2 answers
SSRS Subscription issue - fail with permission issue
HI, I am facing issue with SSRS subscription, it use to work for different user but I have changed the user/owner and it is not working. It is giving below error and the new user has same role as old user. The user used for shared…
asked 2021-10-25T09:36:16.163+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, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Eshwar
196
Reputation points
answered 2025-01-31T10:41:49.08+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(182.40000000000003, 62%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nathan Bolstad
0
Reputation points
1 answer
Geo Replication,Failover Group and DB Copy, DB backup and restore
Hello Everyone, As I and my team already know that, When you re-enable geo-replication between DB1 (the primary) and DB2 (the secondary), the replication process begins asynchronously. The time it takes for DB1 to replicate changes from DB2 after…
asked 2025-01-31T05:39:44.91+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(147.20000000000002, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Aryaa Kotian
0
Reputation points
answered 2025-01-31T06:20:44.3233333+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, 69%, 29%)' 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)
Sai Raghunadh M
2,155
Reputation points Microsoft Vendor
1 answer
ssis is missing
I can not find the SSIS toolbox option on my ssis project. Tried restarting VS and machine many times, pls help
asked 2025-01-30T14:50:46.8+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(272, 45%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Sin X
20
Reputation points
answered 2025-01-31T06:17:34.3833333+00:00
Olaf Helper
45,776
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL sort varchar
i have table contain of ip address, how we can sort the ip address from .1 to .254? If i sort by asc then the result is not sequence like below pic. After .1 then jump to .102 not to .2 The field using varchar,
asked 2025-01-31T01:09:17.6233333+00:00
Handian Sudianto
5,666
Reputation points
commented 2025-01-31T05:23:57.3066667+00:00
DBG
2,301
Reputation points
1 answer
What is MARS commection
Hi, ALL, I thought that MARS connection is for the following scenario: SELECT field1 FROM table1 WHERE SELECT field2 FROM table2 WHERE table2.field1 = table1.field1_value As you can see there are 2 open statements for which MARS is a solution, Apparently…
asked 2025-01-26T22:47:42.9533333+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(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
46
Reputation points
commented 2025-01-31T03:24:42.8333333+00:00
Igor Korot
46
Reputation points
1 answer
How to migrate from SQL Server 2016 to Azure SQL DB
I plan to migrate 1.2 TB Database from SQL 2016 (on Proem) to Azure SQL DB. What is the best way to migrate from on-prem to Azure DB? Can I take a full backup and restore it on Azure SQL DB?
asked 2025-01-28T20:35:11.6866667+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(0, 0%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
chuck DM
101
Reputation points
commented 2025-01-31T01:27:07.02+00:00
Sai Raghunadh M
2,155
Reputation points Microsoft Vendor
0 answers
Content of directory on path 'https://stsxxxxxwus01.dfs.core.windows.net/stsexxxxxxxc/production/xxxx xxxxx/xxxxxxx/d_xxxxx/_delta_log/*.*' cannot be listed.
I receive this error message intermittently when I run a query against a storage account from SSMS. It works most of the time but at certain times, it fails. I find it's been failing a lot more now than before and I know it's not a permissions-related…
asked 2025-01-27T14:10:19.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(256, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
Olujimi Adebiyi
0
Reputation points
commented 2025-01-31T00:40:12.22+00:00
Olujimi Adebiyi
0
Reputation points
1 answer
Restoring backups from a Standard tier DTU based Azure SQL Database
I am testing an environment. I have SQL server (serverless) and database using standard DTU model in UK south region, as it's a very small database. I set the backup storage to globally redundant. It seems that when I try to create a database in UK…
asked 2025-01-28T17:31:53.6266667+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, 69%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tim Herman
45
Reputation points
commented 2025-01-30T23:16:21.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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
2,425
Reputation points Microsoft Vendor
3 answers
Best practices for joining tables of different collation property database
Hi, I am trying to join two tables of databases present on same server but with different collation property and getting following error: What are the best practices to join tables of different databases present on same server but with different…
asked 2025-01-30T10:48:40.5633333+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(291.2, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Priya Jha
876
Reputation points
answered 2025-01-30T22:40:37.0866667+00:00
Erland Sommarskog
116.1K
Reputation points MVP
0 answers
How can I get any Registry Entry for SSMS 21 where I can modify any plugins.
For all the versions till SSMS v20, there is registry entry as follows: Computer\HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\<SSMS.Version>.0_IsoShell_Config\ where we can configure customized items like menu, toolwindow,…
asked 2025-01-30T12:36:16.67+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(288, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vaibhav Pol
15
Reputation points
commented 2025-01-30T22:36:05.4633333+00:00
Erland Sommarskog
116.1K
Reputation points MVP
0 answers
How can I get any Registry Entry for SSMS 21 where I can modify any plugins.
For all the versions till SSMS v20, there is registry entry as follows: Computer\HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\<SSMS.Version>.0_IsoShell_Config\ where we can configure customized items like menu, toolwindow,…
asked 2025-01-30T12:36:16.67+00:00
Vaibhav Pol
15
Reputation points
commented 2025-01-30T22:36:05.4633333+00:00
Erland Sommarskog
116.1K
Reputation points MVP
1 answer
self join in ssis
HI Expert, If i want to run pipeline for table1 which has self join with same table and updating flag on created and updated on target table... how this this can be done in ssis
asked 2025-01-30T18:20:16.8766667+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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
1,350
Reputation points
commented 2025-01-30T22:30:30.4366667+00:00
Erland Sommarskog
116.1K
Reputation points MVP
0 answers
Why is retrieving data on the new server slower than on the old one?
I have customer with Application and Data Servers. Users access the Application Server which obtains the data from the Data Server. Recently, a new Application Server was introduced to replace the original. The old Server was a Windows Server 2008 R2…
asked 2025-01-22T16:36:52.1333333+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, 41%, 10%)' 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)
Torquinian
1
Reputation point
commented 2025-01-30T22:25:18.51+00:00
Erland Sommarskog
116.1K
Reputation points MVP
0 answers
Microsoft Report Builder - Full width summary row in a child group
I have an SSRS report containing a parent and child row group. At present, this displays as: I want to add a summary row to the "Child Group" but have it span the entire row. For example: I also want the data for the "Parent Group" to…
asked 2025-01-30T13:01:55.2366667+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(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
181
Reputation points
commented 2025-01-30T18:26:12.5033333+00:00
Peter Bishop
181
Reputation points
5 answers
How to list all features installed without run SQL Server setup?
How to check which feature are installed without run the SQL Server setup? I mean, how can I list what was marked to install when running the SQL Server setup inside apkzity? That include Instance features and Shared Features.
asked 2024-02-08T14:29:56.7166667+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, 81%, 16%)' 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)
ahmedbark
0
Reputation points
commented 2025-01-30T18:00:07.2366667+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(67.2, 79%, 16%)' 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)
ThisIsUsername22
0
Reputation points
1 answer
Where can I obtain tracefmt.exe?
I need tracefmt.exe to look at MSDTC logs. I've tried the Windows SDK and WDK but no joy. Anyone tell me exactly where I can find this tool please?
asked 2025-01-30T14:31:35.0833333+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(147.20000000000002, 11%, 24%)' 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)
Saransvan
106
Reputation points
commented 2025-01-30T16:32:08.23+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(121.6, 38%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gustavo Garcia Manzano
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Configure SSIS Catalog task is failing in deployment pipeline with file not found error
Hi I have built a deployment pipeline in Azure DevOps that deploys an SSIS project to a SQL Server 2019 instance using an Azure Pipelines agent running on the same server. The pipeline has two tasks: Deploy the SSIS project using the SSIS Deploy task…
asked 2025-01-30T15:32:41.98+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, 32%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Julian Hicks
0
Reputation points
accepted 2025-01-30T16:24:37.6666667+00:00
Julian Hicks
0
Reputation points
3 answers
How can I get all the failure SQL queries logs o
I want to track all the failure SQL in the log metrics, how can i get the output
asked 2025-01-29T13:45:01.7433333+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(275.2, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Robert Antwi
0
Reputation points
commented 2025-01-30T14:52:14.2466667+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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
1,065
Reputation points Microsoft Vendor