• Hi David

    As i say in my second post above, you simply call sp_dbmmonitorchangealert to set thresholds at a Database level. The very first paramater of sp_dbmmonitorchangealert is to specify the target database.

    Example from MSDN:

    EXEC sp_dbmmonitorchangealert AdventureWorks2008R2, 1, 30, 1 ;

    EXEC sp_dbmmonitorchangealert AdventureWorks2008R2, 2, 10000, 1 ;

    EXEC sp_dbmmonitorchangealert AdventureWorks2008R2, 3, 10000, 1 ;

    EXEC sp_dbmmonitorchangealert AdventureWorks2008R2, 4, 1000, 0 ;

    EXEC sp_dbmmonitorchangealert AdventureWorks2008R2, 5, 8, 1 ;

    Hope that helps

    Regards

    Jordon

    Knock Knock, Who's There?, sp underscore, sp underscore who?
    spid1, spid2, spid3....