I went ahead and created a table in one of the databases and since the USP I attached earlier looks over the server then generated a notification right away and sent it to me.

-- =====================================================

to me

Audit DB Mgmt Event Occured::

ApplicationName Microsoft SQL Server Management Studio - Query

DatabaseName ADMIN

DBUserName dbo

EventSubClass Alter

HostName D003951

LoginName johne

NTDomainName

NTUserName

ObjectName dbo

OwnerName dbo

ServerName companySQL

SessionLoginName johne

StartTime 2013-12-11T12:28:17.190

Success 1

TextData create table removemenow (field1 int null)