Sometimes you need to investigate emails being sent from SQL Server. This query the last 100 items.
Create a SQL Server database snapshot dynamically without having to write the file names and paths. This script generates a snapshot of your database with two variable inputs; database name, and snapshot name appended. The snapshot will be named @SourceDatabase + '_' + @SnapshotAppend. So for example 'DemoDb_Snap_20180810.ss'. You can also override the file path … Continue reading Create SQL Server Database Snapshot Dynamically