It prevents schema changes to the table without dropping the trigger.

It prevents DDL changes to the table without dropping the trigger

As an option one could use a check constraint instead to enforce the business rule however in the scenario described a lookup table is a better option as, as you...

Did someone change the server to Windows Authentication?
EXEC master.sys.xp_loginconfig 'login mode'

The easiest way i know is to use Registered Servers in SSMS. Add all your servers to a group and run a query.
SELECT name, type_desc, is_disabled, create_date,...

In google I typed in:
"sql server how much space does a null take up", This was the top result:
https://stackoverflow.com/questions/3731172/how-much-size-null-value-takes-in-sql-server

You could create a server role for alter any database. If this is your development server you may want to use a login created from a domain group and add...

Make a list of accounts you want to retain SysAdmin and add these logins to a CTE (values or union all).
Using Registered Servers add all the servers to a...

Individually create 3 contained logins, one for each of the 3 databases with the same creds.

You could write a .bat or PS script and execute on a schedule using Window Task Scheduler.

Maybe column level encryption would work for this.

Powershell is a good option as well for importing and exporting CSV files to and from SQL Server tables. If i have a weird file to...