Sql certificate chain was issued by an authority that is not trusted

How to solve the certificate chain was issued by an authority that is not trusted? Why the certificate chain was issued by an authority that is not trusted? Read more →

Trace flag 902 in SQL Server and Error 574

What is Trace Flag t902?How to check trace flag in SQL Server? Read more →

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 →