We ran in to a similar problem with a Group Managed Service Account

The solution was found in

http://mssqlwiki.com/2013/12/09/sql-server-connectivity-kerberos-authentication-and-sql-server-spn-service-principal-name-for-sql-server/

*by giving read servicePrincipleName and write servicePrincipleName rights to the...

This is not a replacement to track complete history of changes (who dunnit) but more a 'do i have the latest version'-tool(replication/synchronisation)

To track changes I usually add a trigger and...

You're missing several other solutions

3. using UDF, coalesce and a subview

ALTER FUNCTION dbo.Concatenate_Functiebenaming (@ID_Personeelslid INT)

returns varchar(200)

as BEGIN

declare @STR varchar(202)

...

This also happens a lot while executing cross database procedures

E.g. Trigger calls procedure in other db to update lookuptable

possible solution: run the procedure asynchronously (in a new connection)

This is what I meant with the mail_queue table and an agent that sends periodically

http://stackoverflow.com/questions/530320/how-to-execute-spsenddbmail-while-limiting-permissions/536028#536028

Your drop code drops all default constraints

Your create code creates only some constraints /*e.g. datetime where col name like '%Last%Date%' */

I think if you'd want to do something like this...

I repeat my remark.

Be carefull calculating weekend days as datepart(dw, @date) in (1,7)

Under some language settings day 1 of the week is monday. e.g. when you connect to the sql...

Don't forget that sunday isn't first day of week everywhere.

Some people start with monday (sunday is the 7th day):D