These are excellent articles about SMO written from 2012-2015.

It would be great to have an update to PowerShell Core and SqlServer instead of SQLPS. Many links are to sites that...

Is this code appropriate for 2023? An update would be great.

@Toby Harman, I am not sure what meaning IGNORE_DUP_KEY would have for a PRIMARY key which must be unique. See also, https://stackoverflow.com/a/2594283/447901

@sql Simon, the #invalid_db_objects table does not have a column custom_error_message in it.

Sorry, yes, the original post contains a custom_error_message column. I was trying to incorporate the code...

• This reply was modified 1 year, 8 months ago by  paul.hermeneutic.
• This reply was modified 1 year, 8 months ago by  paul.hermeneutic.

At the prices they charge for the...

Is anything here part of ISO/IEC 9075:2016 (ANSI X3.135)? https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/

What parts of the SQL standard has Microsoft not yet implemented?

• This reply was modified 2 years, 3 months ago by  paul.hermeneutic.

If there are multiple files, an analysis of ROBOCOPY would be interesting with various /MT settings.

No one here knows what level of detail is required in your organization.

My first thought would be to add annotation text into the package. That documentation would live...

Sorry, I figured it out.
I had not put User:MyBool into the Read/Write setting.