SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,328 questions
2 answers
Multiple Users Read/Write to same SQL record
Hello, I have a pretty simple database that is read and written to through an asp.net c# website. Users see a grid with data and they can open a record to make changes. More than one user can open that same record, and what I am finding out is that when…
asked 2024-07-11T20:52:39.55+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(3.2, 38%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBF%3C/text%3E%3C/svg%3E)
Byrd, Frank
0
Reputation points
commented 2024-07-22T08:38:56.6633333+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
3 answers
Database User dbo is orphaned- How to fix
Hello All All feedback is welcome ALTER USER [dbo] WITH LOGIN = [ww] GO Msg 15150, Level 16, State 1, Line 14 Cannot alter the user 'dbo'.
asked 2024-07-18T14:38:25.7933333+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(230.39999999999998, 35%, 32%)' 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)
Stephen Keogh
20
Reputation points
commented 2024-07-22T08:34:57.9666667+00:00
LucyChenMSFT-4874
2,985
Reputation points
0 answers
SQL Split from Multivalue
Hello I have field contains like this vd:07/21/2024 19:47:13 07/21/2024 19:43:21 07/21/2024 19:20:59 07/21/2024 19:03:13 07/21/2024 19:15:35 07/21/2024 19:08:38 07/21/2024 19:27:32 07/21/2024 19:24:04, vn:10_JKT01 09_JKT02 06_JKT03 01_JKT04 05_JKT05…
asked 2024-07-22T08:30:07.9066667+00:00
Handian Sudianto
4,471
Reputation points
asked 2024-07-22T08:30:07.9066667+00:00
Handian Sudianto
4,471
Reputation points
4 answers
Unable to shrink Tempdb.
DBCC SHRINKFILE: Page 9:2444056 could not be moved because it is a work table page. when trying shrink tempdb facing this issue, we have any solutions for this without restarting SQL services can we shrink thempdb.
asked 2024-07-14T12:46:22.3833333+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(195.2, 91%, 28%)' 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)
Raghavendra Royal
0
Reputation points
answered 2024-07-22T08:27:34.59+00:00
Raghavendra Royal
0
Reputation points
2 answers
After install last CU KB5037331 wrong version detected
We install last CU SQLServer2019-KB5037331-x64.exe on our cluster but defender still detect vulnerable version. When i check registry yes there is not upgraded info in registry after install SQLServer2019-KB5037331-x64.exe. SQL is fully updated. This is…
asked 2024-07-22T05:00:21.29+00:00
Belan Marek
51
Reputation points
commented 2024-07-22T08:22:09.8333333+00:00
Belan Marek
51
Reputation points
1 answer
One of the answers was accepted by the question author.
Power BI Report Schedule Refresh Error
In the report server database est connection is successful but whenever doing schedule refresh its not connecting. throwing error like "an error occurred within the report server database. this may be due to a connection failure, timeout or low disk…
asked 2024-07-19T08:55:53.56+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(32, 97%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
Zubeyr Aydogan
20
Reputation points
accepted 2024-07-22T08:01:04.98+00:00
Zubeyr Aydogan
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Why are the database rows are getting deleted automatically sql
I got a copie from a comany to to make a projet and i createt a table in the database and some times wenn i log in on the pc all the rows from the table are delete it happent to me 3 times now last time was Friday an now monday and it is not a trigger…
asked 2024-07-15T09:58:47.7266667+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(41.6, 4%, 14%)' 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)
Gabriel Gomes Aguiar
20
Reputation points
commented 2024-07-22T08:00:36.88+00:00
Gabriel Gomes Aguiar
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Unable to download SQL Server Master Data Services Add-in for Excel Plugin
Does anyone know of a working download link for the SQL Server Master Data Services Add-in for Excel? I receive an "Internal Server Error" when attempting to download from both the Microsoft Learn and Microsoft Download Center links. Any…
asked 2024-07-16T10:24:45.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(131.20000000000002, 27%, 22%)' 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)
Harsh Thakkar
20
Reputation points
accepted 2024-07-22T07:55:57.0866667+00:00
Harsh Thakkar
20
Reputation points
2 answers
Copy Database - Performance
Hello, We need to create a new copy of a database on a different server using the PowerShell command "New-AzSqlDatabaseCopy". Will running this command impact the performance of the live database, especially if other jobs or queries are…
asked 2024-07-17T06:49:52.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(140.8, 39%, 23%)' 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)
Rohit
226
Reputation points
commented 2024-07-22T07:49:46.6833333+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
1 answer
SQL Server Cumulative Updates with Azure Update Manager
Does the Azure Update Manager only apply GDR updates fro SQL Server? Or can it apply the CU as well?
asked 2024-07-18T15:27:11.3433333+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(192, 90%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ashlynn Speight
0
Reputation points
commented 2024-07-22T07:48:38.86+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
3 answers
How to fix the issues all settings or connections are good place find the screenshot below
How to fix the issues all settings or connections are good place find the screenshot below
asked 2024-07-18T13:05:13.5866667+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, 73%, 29%)' 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)
Anandhswarupp
65
Reputation points
commented 2024-07-22T07:47:21.2933333+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
1 answer
SQL Server version upgrade
Hi Want to upgrade(rolling upgrade) from SQL 2017 on Win 2016 to SQL 2022 on Win 2022 and it is configured with AG . Please provide me the complete steps. Whether we can upgrade to SQL 2022 on Win 2022 and having Always on AG without Widows Failover…
asked 2024-07-18T08:50:09.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(99.2, 45%, 19%)' 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)
SVA
116
Reputation points
commented 2024-07-22T07:45:13.1633333+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
2 answers
One of the answers was accepted by the question author.
Error Microsoft SQL server connector 3:1466 Execute failed: network error Io exception : connect ion refused no future information
I have verified the connections on SQL server all are good but throwing mentioned error . Error Microsoft SQL server connector 3:1466 Execute failed: network error Io exception : connect ion refused no future…
asked 2024-07-18T11:50:04.3366667+00:00
Anandhswarupp
65
Reputation points
accepted 2024-07-22T07:30:40.39+00:00
Anandhswarupp
65
Reputation points
3 answers
Cluster error
Cluster with Alwayson unreachable: Errors: 00000ef4.00000a74::2024/07/17-13:51:50.791 ERR [API] AccessCheck[AndAuditAlarm] failed. status = 0x00000005 00000ef4.00000a74::2024/07/17-13:51:53.512 WARN [API] s_ApiOpenResourceEx: Resource Scaleout Master…
asked 2024-07-17T15:53:45.3366667+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(230.39999999999998, 32%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dario Bodini
1
Reputation point
commented 2024-07-22T07:04:02.11+00:00
LucyChenMSFT-4874
2,985
Reputation points
1 answer
Application unable to connect to Listener intermittently on port 1433
We have a named instance that's running on a dynamic port, with a Listener specified on port 1433. All application strings only specify the listener IP and port. A scheduled job connects to the listener once a day, but it sometimes fails with the error…
asked 2024-07-21T04:05:37.09+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, 43%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Amisha Bhadauria
0
Reputation points
commented 2024-07-22T06:50:48.7233333+00:00
LucyChenMSFT-4874
2,985
Reputation points
2 answers
One of the answers was accepted by the question author.
"Incompatible" project
(Relatively new to SSIS so apologies if this is an easy one) I set up a data flow in the community version of VS as a proof of concept. Then moved to the enterprise version but opened the old project before installing SSIS and of course it said the…
asked 2024-07-16T14:40:52.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(268.8, 2%, 36%)' 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)
Lusk, Colin
0
Reputation points
accepted 2024-07-22T06:37:42.3233333+00:00
Lusk, Colin
0
Reputation points
0 answers
Customer Best Practices Assessment: exclude checks/false positives
Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…
asked 2024-07-19T09:42:13.16+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(243.2, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Berend Broekhoff
0
Reputation points Microsoft Employee
edited a comment 2024-07-22T06:32:02.71+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
14,381
Reputation points Microsoft Employee
1 answer
Transaction replication is getting failed for creating snapshot with message as "Prefetch objects failed for Database"
This issue "Message: Prefetch objects failed for Database " has been happening everytime I run the snapshot after 96% completed I was getting this issue (I need to wait for 5 hours for this). What ever .bcp files got created in storage account…
asked 2024-07-12T11:33:24.7133333+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(310.4, 26%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Ravi Padakanti
0
Reputation points
commented 2024-07-22T06:31:26.2733333+00:00
LucyChenMSFT-4874
2,985
Reputation points
2 answers
Replication in-place upgrade is failing from 200R2 to 2016
Hi All, We are doing upgrade from SQL 2008R2 to SQL 2016, during upgrade replication feature is failing. Its asking to check SQL Logs, we checked SQL logs and there is no errors. Let me know how to proceed on this. Error: Feature: …
asked 2024-07-12T05:16:47.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(259.20000000000005, 57.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CK
61
Reputation points
commented 2024-07-22T06:31:00.62+00:00
LucyChenMSFT-4874
2,985
Reputation points
1 answer
I am making a connection to mssql using typeorm and getting error
Hi, I am trying to create connection to my mssql server using typeorm in node 20 application. I am getting socket hang-up error, the connection gets created if I set encrypt to false. I tried all tls configuration and everything but I am not able to…
asked 2024-07-11T13:58:53.66+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(73.60000000000001, 12%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kasthuri C M
0
Reputation points
commented 2024-07-22T06:30:20.5633333+00:00
LucyChenMSFT-4874
2,985
Reputation points