Cool to know it exists.  Thanks for putting that together and showing the comparisons!

To...

There are a lot of reasons... The biggest one is: beeing forgotten. Or for example, when one database comes from a completely different server but the login is beeing...

i added the update one for users that have a different Id than the login on the server.

 INSERT INTO ##tbl_db_principals_statements (stmt, result_order)
   SELECT...

Ever get anywhere with this?  I came across https://techcommunity.microsoft.com/t5/sql-server-support/getting-cross-domain-kerberos-and-delegation-working-with-ssis/ba-p/318361 that explains it, but falls short of identifying what is needed for constrained delegation.  TIA.

Thank you for the script. Very useful!

One issue I have discovered is that the type level permissions syntax is incorrect. The script shows this: IF... GRANT EXECUTE ON [schemaName].[typeName]...

Hi Steve,

Are there additional changes to the script if it will be ran on an Azure SQL Managed Instance aside from adding the type 'E' and 'X' (E =...

Unfortunately, this isn't designed to run that way since it is generating print statements.  It...

Hey all.  There have been quite a few comments recently, and some edits provided by Andrew G last year (I'm a bit behind, eh?).  I am reviewing these and will...

What a time to be alive, Jeff!  We all need to start branching out, I feel.

Seems like SSC moved to a new editor on the backend, and the attachments didn't come along.   I published the zip to https://github.com/fuixx217/whatever so you can download from...

Good write-up, Steve.  I like that once you have the session defined the way you like, you can script it out, and I think it might actually be easier than...

This thread is ancient, but I was having this same exact issue on a SQL 2012, windows 2008 R2 OS machine.  By looking at the C:\Users\<username>\AppData\Local\Temp\SqlSetup.log file after trying to run...