I landed here researching the same error as mentioned by some users above "The file name is not valid. The file name is a device or contains invalid characters"

It was...

nevermind, i registered using the same way as jcourtsql and no issues found.  thanks for this post.

Hi @jcourtjrSQL

I have SQL Server 2017 on Azure VM with Windows 2016.  Have two ports opened for SQL Server and the kerberos config tool is suggesting the same...

• This reply was modified 5 years, 2 months ago by  jaincs.

which issue is occuring. the deferred updates or the unique constraint violation.

In my case it was unique constraint violation on CT table though. the CDC capture job was...

Yeah, indeed. This is different. I had thought the underlying cause could be "deferred updates" but I was wrong. In my case, I discovered that this is...

I am having a similar issue. However, not sure about the fix. I am getting an error message which looks like this:

Cannot insert duplicate key row in object...

This will not kill the sessions that are running queries from another database on the same instance.

Nice example. One word for this scenario is "parameter sniffing".