To be honest, that's not really enough information to base any useful advice on.   There's a lot more to take into consideration, and on a volunteer basis and for free,...

Don't really know for sure, but I suspect that the enabling of encryption of data in transit may require that.   Not sure exactly why.

No clue, but push comes to shove, you can create an ALTER DATABASE command to change the default collation and use that script prior to any tables being created.

I chose to take the chance and help out, so here you go:
CREATE TABLE dbo._1UPDATE_SITE_DESC_list (
    RowNum int NULL,
    SITE_ID uniqueidentifier NULL,
    [ACTION] varchar(255) NULL
);
INSERT INTO dbo._1UPDATE_SITE_DESC_list...

And if that doesn't do it, you may just need to add some DENY permissions to the role or roles in question.

On the assumption that you are correct about what you see, I don't see why you couldn't create a role that has the necessary ALTER rights for specific schemas, and...

In particular, is it possible to have a right parenthesis ")" within the text being captured?   Based only on your post, there's no way to know if there are going...

This would be a lot easier to help with if you could post some sample data and the necessary CREATE TABLE and INSERT statements.   You will want to know if...