SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,636 questions
0 answers
Query structure for WHERE EXISTS for Linked Server with Lookup Table?
Hello, I have a Linked Server which my target is a VIEW and also have a local DB Lookup TABLE which contains just one Column with multiple records/values. I would like to get all of the records from the Linked Server VIEW which has multiple Columns…
asked 2024-04-18T19:33:57.04+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
asked 2024-04-18T19:33:57.04+00:00
techresearch7777777
1,766
Reputation points
1 answer
ASP SQL connection string to Windows Server 2022 Datacenter Azure Edition
I have an ASP website residing on a Windows Server 2022 Datacenter Azure Edition. The website is linked to a SQL database on the same server. When trying to log in, the connection fails with message "Exception:Thrown: "A network-related or…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
926 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,243 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,636 questions
asked 2024-04-18T17:46:52.3166667+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, 4%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Product Support
0
Reputation points
answered 2024-04-18T18:13:41.6333333+00:00
Vahid Ghafarpour
17,700
Reputation points
1 answer
Looking for guidance on integrating third-party data into our domain
Hi, My company's transactional system is MS Dynamics 365. We need to import various third-party data into our domain. I'm a Power BI developer but have been assigned this project. I'm looking for guidance on a suitable database and integration tool. …
asked 2024-04-18T16:54:37.4433333+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, 21%, 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)
Anon101
51
Reputation points
answered 2024-04-18T17:56:31.9666667+00:00
Amira Bedhiafi
14,806
Reputation points
0 answers
cleanup old transactional replication snapshot files
I have a transactional replication between a publisher and a subscriber where the subscriber also acts as the distributor. I am facing storage issues as old snapshot files are not being auto cleaned up after successful application via distributor. I…
asked 2024-04-18T17:46:01.6433333+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, 55.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abimbola Adeniran
21
Reputation points
edited the question 2024-04-18T17:46:32.64+00:00
Abimbola Adeniran
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Could not locate statistics error when reading data from seondary node in an alwayson using linked server
Hi, Seeing below error when reading data from seondary node in an alwayson using linked server. Please advise if there is a permanent fix for this instead of dropping and recreating the statistics individually. DBCC execution completed. If DBCC…
asked 2022-01-12T13:30:06.823+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, 95%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Kranthi DBA
221
Reputation points
commented 2024-04-18T17:37:26.5433333+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(300.8, 46%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Cüneyd Tanrıverdi
0
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Server fails to start on Ubuntu 22.04
I created a new instance of Azure VM running Ubuntu 22.04 just to reproduce this issue. I'm following this guide to install the SQL server on my freshly deployed VM. There should be definately enough resources to run it with 8GB RAM and 2 CPU cores. I…
asked 2024-04-18T09:23:20.59+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, 26%, 29%)' 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)
Sebastian Meckovski
0
Reputation points
accepted 2024-04-18T17:03:50.9066667+00:00
Sebastian Meckovski
0
Reputation points
0 answers
database engine services (mssqlserver) failed
when i tried to update sql sever i get this error and i tried to run it as adminstor still get the some error what can i do please
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,032 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,636 questions
asked 2024-04-18T16:19:38.3533333+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, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES2%3C/text%3E%3C/svg%3E)
Salma 20210413
0
Reputation points
asked 2024-04-18T16:19:38.3533333+00:00
Salma 20210413
0
Reputation points
2 answers
SQL Authentication
when logging into sql manangement studio via windows authentication, i used to be able to drop down to select the server i wanted to log into. Now, it only saves the last one i logged into, with no option to see the others i logged into previously. It…
asked 2024-04-18T15:21:50.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(134.4, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Marie A
0
Reputation points
commented 2024-04-18T15:45:31.3533333+00:00
Alex Burlachenko
0
Reputation points
2 answers
How to update sequence of person if he has relative
Currently RelativeID is blank in database. Ho I can update the RelativeID from sequence. If any Empid has relative then should update the unique RelativeID starting from 1. If someone has two relative then RelativeID will be 1 and 2. If someone has three…
asked 2024-04-17T22:26:20.6+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(188.79999999999998, 13%, 28%)' 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)
Martin Kevin
221
Reputation points
commented 2024-04-18T15:32:03.6133333+00:00
Martin Kevin
221
Reputation points
1 answer
Could you please suggest the list of software needed to register and use a custom component in data tools tool box using VS2019 in x64
Issue Description: Facing issue in setting up and running SSIS in debug mode in VS2015 that can recognize 64-Bit C# custom components in Data Tools Tool box. Created MyCustomComponent.dll by referencing below dlls. Took the dlls from…
asked 2024-04-08T12:34:26.1366667+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(316.8, 78%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
SAILANATHAN Balaji
0
Reputation points
commented 2024-04-18T15:30:27.1433333+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, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
47,711
Reputation points
5 answers
SQL Server Reporting Services is spewing logs - This may be due to a connection failure, timeout or low disk condition within the database.
On SQL Server Reporting Services, all of a sudden logs are full of : library!WindowsService_0!16e4!04/16/2024-13:52:26:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the…
![](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, 5%, 19%)' 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)
2 answers
Migrate Azure SQL server instance to SQL managed instance
Dear forum, We're planning to migrate our DBs on a SQL server instance to a SQL managed instance. We're focussed on migration our dev/test instance first before doing production. The back-ups are done using the Azure Recovery Vault service. We would like…
asked 2024-04-18T13:26:25.6633333+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, 14.000000000000002%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
NIJSTEN Stephen
60
Reputation points
answered 2024-04-18T14:09:24.83+00:00
Alex Burlachenko
0
Reputation points
3 answers
how to connect remotely to sql server
i have followed all the instructions mentioned in websites to enable remote connectivity to sql server. i am still not able to connect to the server. what could be the possible reason?
asked 2024-04-17T09:56:06.1966667+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, 9%, 33%)' 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)
Aratrika Kundu
0
Reputation points
answered 2024-04-18T14:04:26.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(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' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
8,176
Reputation points Microsoft Employee
3 answers
Merge Replication Web Synchronization with SQL Express subscriber
our publisher is in SQL Server 2012 enterprise and our subscription machines are running SQL Express 2012. We are trying to setup a sync between a Server X(in a corporate network) and an external machine with SQL Express installed. We are tried merge…
asked 2021-04-30T17:02:57.457+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, 38%, 10%)' 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)
Vikas Pillai
26
Reputation points
edited a comment 2024-04-18T13:53:12.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(35.2, 64%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
almuatacim hamouda
0
Reputation points
5 answers
One of the answers was accepted by the question author.
Upgrade SQL server 2014 to 2019 after lift and shift to Azure
Hi, We are planning to do in-place upgrade SQL server from 2014 to 2019. The server is lift and shifted to Azure so is updating the server same as updating on premise server or is there anything different. please provide suggestions. Thank you
![](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, 94%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
1 answer
How connect from AWS DMS to a remote Microsoft SQL Server using windows authentication as login method
Hi I need to connect to a remote server, this server allows only windows authentication, when I try to connect usign python Im able to log in and run queries using pymssql from my computer on the company domain. import pymssql conn = pymssql.connect( …
asked 2024-03-15T16:44:11.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(115.19999999999999, 90%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Javier Rendon
0
Reputation points
answered 2024-04-18T12:46:59.4566667+00:00
Greg Low
1,155
Reputation points Microsoft Regional Director
0 answers
I am unable to set up SQL server on my system. Tried SQL 2019 and the latest one. Nothing works, tried everything but it just doesnt work out
Hi there, I have been trying install and make SQL server work on my personal system. I wanted to learn and learned the basics from various sources> Now I need to practice with various datasets. Been trying to install SQL 2019, 2022 but nothing works.…
asked 2024-04-14T14:03:31.9633333+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, 69%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVY%3C/text%3E%3C/svg%3E)
vibhu yasha
0
Reputation points
commented 2024-04-18T12:40:20.51+00:00
Greg Low
1,155
Reputation points Microsoft Regional Director
1 answer
Index statements on Transactional Replication
I read that in Transaction replication, create/alter/drop index statements are not replicated. Is it true?
asked 2024-04-18T07:51:36.7066667+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
676
Reputation points
answered 2024-04-18T12:37:59.9133333+00:00
Greg Low
1,155
Reputation points Microsoft Regional Director
1 answer
Insert statement not inserting value for one field in sql database
I have one existing table, now I have added one new field. When I try to insert value in that field it's not insert that value. its storing null value. This is very odd issue I am facing.
asked 2024-04-18T10:13:16.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(35.2, 82%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rajesh Bargode
20
Reputation points
commented 2024-04-18T12:27:41.5966667+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(307.2, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZB%3C/text%3E%3C/svg%3E)
Zahid Butt
556
Reputation points
2 answers
One of the answers was accepted by the question author.
SSMS v18.3 "Trust Server certificate" option
On one server , I have set ForcedEncryption to True. I have also attached server certificate to service account, with service account having read rights on certificate. Everything working as expected. When I query sys.dm_exec_connections, I see Encrypt =…
asked 2024-04-17T18:31:14.69+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(105.60000000000001, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mudit Gupta
61
Reputation points
accepted 2024-04-18T12:20:05.16+00:00
Mudit Gupta
61
Reputation points