I've used the Sql compliance manager from Idera at the last company I worked for. https://www.idera.com/productssolutions/sqlserver/sqlcompliancemanager

It is quite expensive - I think we paid around £6000 per monitored...

USE [msdb]

GO

EXEC msdb.dbo.sp_update_job @job_id=N'<JOB_GUID>',

@notify_level_email=3

GO

Running the following will set the job to send an alert when it completes.

See attachment for screen shot of doing it through the GUI.

The following query should show the file sizes of the data and log files and the amount of space used.

SELECT RTRIM(name) AS [Segment Name], groupid AS [Group Id], filename AS...

You can set the notification of the job to email the operator when the job completes -(i.e if it fails or succeeds).

I'm sure there are other ways, but you could execute a procedure on startup (information here https://msdn.microsoft.com/en-us/library/ms181720.aspx or http://zarez.net/?p=1566 ) which ran the code SELECT HOST_NAME() and emailed the result....

Is the storage setup different for each server?

info.sqldbamail (6/8/2015)

---

If i have a FULL backup on Sunday evening @ 8:00 PM and succeeding a Differential backup @ 7:00 AM everyday(MON,TUE,WED,THU,FRI) with this LOG Backup for every 4 hours...

I'm sure you have had your questions answered, but if it helps, I use the following query to check my backups are running ok:

SELECT DISTINCT

...

Logging in as a local admin you wont be able to browse the domain I expect. If you type in the new login search box domain\username and hit the...

You're creating the master key and certificate on the Database. You need to create it on the server, so run the first two commands on the master database. ...

Not sure how this has got to the top of the list since I asked it to years ago. Just to confirm, the bug was the issue and the hot...

Even better! Thanks.

I understand the second query more than the first, but will study it in more detail to understand how it is working.

Thanks again.

Pefect! That's what I need. Thank you so much.

Thanks for the help.

Your first query, shows the same results as my query - the problem being for Gate5, where the job id is 1 and process id is 10,...

The only time I see users creating thier own schemas, is when they haven't had "dbo" set as their default schema. In that case, creating objects will cause a schema...