you will need to find a way to query secpol.msc for the correct value then.

There is a way around this, but it will NOT add any null values into the index, so if you constaintly use the column for queries which relies on the...

Did you have a column which was of a blob type outside of filestream at some point?

Enforce it via group policy

For assistance on posting code and data, please see the link in my signature on the topic.

If there isnt a collumn that contains error, then it wont be that problem.

Does the database need to done online? Can you not setup logshipping for example and then...

Thats one to investigate, never used multicast.

Within the same DFT, just drag in another flat file source and another destination and mapp the two.

So 2 Flat File Sources, pointing to the same Flat File Connection Manager,...

Yup, the upgrade advisor would be where I would start as well.

Deprecation Final Support and compatability level are two different things.

Compat Level tells SQL that certain commands behave in a certain way, Deprecation Final Support is for things which are...

Ensure you do what you do in the same job step, no telling what may happen if it moves step and gets a different spid while its in single user...

Yep that is correct.

ROLLBACK IMMEDIATE, will force any connections in that databases to stop executing and rollback what they where doing if they where in the middle of a transaction

SINGLE_USER...

The above will do exactly the same as what you are trying to do, just it is the new way of doing it.

ALTER DATABASE myDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

What version of SQL are you running?

What is the purpose of the task at hand, do you just want to boot people out or are you setting the DB into...