Maybe there is an easy way to use something like  "where environment <> 'PROD' " in update and delete statements?

We do manual restore tests.
I wrote a script to random select the database and the point in time to restore. Otherwise we might select the databases that are easy to...

We have an Enterprise Service Bus system running as a Windows service under the local system account. When this system connects to a database because someone of the finance department requests...

You probably have an old version. In the newest version a line is added to send the html-file as an attachement. When you open the attachment you will see the...

I ran the script on 2 servers with MSX (Multi-Server Management) and received 2 emails, maybe you can collect the data from all the servers on the MSX-server and later...

Yes i did load that version.

On the second line your comment says: Mutually exclusive with the first line. So if the third line has the same code as the second...

I've been waiting very long for a script like this.

I used the alternate link to download the script and had to remove the third of these 3 lines:

,@query_result_no_padding = 1...

40 servers, all virtual.

When @filecounter = 0 we only see the value of @BackupFilePattern. The next line is --EXEC(@BackupFilePattern).

When you remove the -- you will see why @filecounter = 0.

Kees