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 →

How to capture query errors using SQL Server Extended Events

If you're troubleshooting SQL Server query errors , you'll already know Extended Events are highly useful and very effective method to capture SQL Server errors. To use the script you'll need appropriate privileges to create the Extended Event. You will also need to have some space available on the disk to store output files. I usually place them in the C:\tmp - although be careful just in case you fill the C:\ drive! The alternative is to use another drive. CREATE EVENT SESSION [CaptureErrors] ON SERVER ADD EVENT sqlserver.error_reported( ACTION(sqlserver.client_hostname,sqlserver.database_id,sqlserver.nt_username, sqlserver.sql_text,sqlserver.tsql_stack,sqlserver.username) WHERE ([severity]>=(10))) ADD TARGET package0.event_file(SET filename=N'C:\tmp\CaptureErrors.xel',metadatafile=N'C:\tmp\CaptureErrors.xem') WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=1... Read more →

How to troubleshoot SPN and SQL Server Windows return code: 0x2098, state: 15

Question:I see this error in the SQL Server Error Logs . How can I troubleshoot this issue? The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/myserver.net:50234 ] for the SQL Server service.Windows return code: 0x2098, state: 15. The start up account for SQL Server is a dedicated start up account Answer: As a starting point let's look at what MSDN has to say " To use Kerberos authentication with SQL Server requires both the following conditions to be true: The client and server computers must be part of the same Windows domain, or... Read more →