Tcp port is already in use.How do I check if a port is already in use?

how do I check if a port is already in use? Read more →

How to fix Invalid comparison due to NO COLLATION

Unusual no collation error on a SQL Server 2017 Read more →

Error Message:The UPDATE statement conflicted with the REFERENCE constraint

During an UPDATE statement on a particular row on a SQL Server table , this error message appeared: Error Message:The UPDATE statement conflicted with the REFERENCE constraint "FK_My_Constraint". The conflict occured in database "MyDB",table "dbo.MyTable". The statement has been terminated The initial input value was incorrect , so I needed to update the value - but there was a foreign key constraint in place to retain integrity between the tables. The way to fix this issue is to temporarily disable the FOREIGN KEY constraint - change the values and the set the FOREIGN KEY constraint again. SQL Server has a... Read more →

Error Message: The RPC server is unavailable during SQL Setup

Question: I have received a server from the server build team and I've started a Server set up. During the set up process , I'm getting an error message Error Message :The RPC server is unavailable How cam I fix this issue? Answer: I have seen this problem in a few situations. Typically it arises when I'm using a Domain account as a service set up account. For example - I may have a service account as a member of the MYDOMAIN domain. If the server cannot connect to a valid DNS server , where the sql server service account... Read more →

String or binary data would be truncated

What is string or binary data would be truncated The statement has been terminated? Read more →