Tuesday, 10 July 2018

SQL Server : Shrink Multiple Database Logs at once

Here is the script to shrink multiple Database at once. Here Cursor is used for iterating to all Databases. You can also use sp_MSforeachdb


Happy Coding !!!

No comments:

Post a Comment

SQL Audits

1. sys.server_audits What it is: Lists all server-level audit objects . An audit is the top-level object that defines: Where to wri...