If using windows accounts - then all you need to do is add the user to the database, do not create a login.  The login will be created only on...

You have a couple of options:

sp_describe_first_result_set

IF 1=0
  SELECT ... FROM ... WHERE  -- this should return and define all columns that would normally be returned

Is the instance setup as an FCI (failover cluster instance) - or AlwaysOn?

When installing an instance for FCI - the clustered resource will have an IP address and...

This isn't really that hard - the most difficult part is identifying 'duplicate' rows.  Using a CTE or derived table - add a row_number() and partition by tableID (and any...

Evict the DR node from the cluster - and verify the storage is available.  Install SQL Server exactly the same as you performed on the FCI nodes - that is,...

Were you logged into the system with a login/user that only has the role 'PaleoDataHost'?  If not - then whatever permissions the login/user was granted is what will be utilized. ...

What Edition of SQL Server?  If you installed the Express Edition - that does not support SQL Server Agent and the service will not start.

Here is one alternative:

   With validEmail (EmailAddress)
     As (
Select te.EmailAddress
   From #tblEmails       te
Except
Select tne.EmailAddress

Are you using temp tables - or are these permanent tables?  If permanent, then you are already dropping the table and recreating it every time...it probably would be better to...