Then either one of the responses given above...

Simply DROP the index you no longer wish to keep.

Are you working with Azure SQL databases (not managed instance)? Adding your user as DB_OWNER for each of the databases of interest should get you over the line.

All of my work is by remote desktop, and I find Windows does not manage multi-monitor RDP support very well. It frequently gets confused with windows placements, moving them...

Phil,

At this point everything is on the table!  Any info you can give on this would be appreciated.  We would be using ADF for this work as well.  It...

I suspect that encrypting the entire file after it has been created would be an easier process. Is that a possibility?

I'm curious about your setup for your...

You say that locking down security is not an option, but it should be.

Setting up a process such that your BIM only gets deployed from a VCS is the way...

Are you planning on basing your software purchasing decisions on the results? If not, why are you doing this?

I can't quite work out what's going on here.

It sounds like all of your data is coming from text files and SQL Server is not involved at all. Is that...

I work from home and use a single 49" Samsung gaming monitor, which I (virtually) split into three windows. Having got used to it, I would never choose to go...

I get this error an estimated 90% of the time. I know now to simply...

If you search other forums, you will see that this is commonly known as the 'silent truncation issue'. The most common workarounds appear to be as follows:

1. Do your length...

Interesting.

It would appear that the second and subsequent executions of declare @spec are completely ignored.

As there is no way (as far as I know) of destroying or amending a table...

Simply reading from a table that is being written to should not cause a deadlock. Are you sure that the read queries are causing the deadlocks?