<ul><li>SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases</li><li>This toolkit includes everything from listing account permissions and linked servers to creating flexible backup solutions and querying server version details.</li><li>List SQL account login type</li><li>List SQL Database Account Access and Permissions</li><li>List Server Principal Objects and Granted Permissions for Each Principal (Filtered by Role)</li><li>List All User, Groups, and Users with Their Associated Groups</li><li>List Linked SQL Servers and Their Logins</li><li>List of Non-System SQL Databases with Online Status</li><li>Backup and Restore Database to New Location and Name</li><li>Backup All Online User Databases to Network Location</li><li>List of Accounts with Type and Status (Enabled/Disabled)</li><li>SQL Server Version Information and Details</li><li>Send Email Using SQL Server Database Mail</li></ul>

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

Discover more