dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Copy-SqlSysDbUserObjects

This command copies ALL user objects (tables, stored procs, functions, etc) in ALL system databases, hence the pluralized command name. This is useful for DBA’s who keep their maintenance tasks in system databases, and for the model database.

Get-Help

From PowerShell, execute Get-Help Copy-SqlSysDbUserObjects -Detailed for more information on this function.

Source Code

Want to see the source code? View Copy-SqlSysDbUserObjects.ps1 on GitHub
 

Related commands