This is a tricky one. I haven't tried it myself, but this is how you might go about it. I'm sure some one provide a neater solution than this.
You could install auditing and track any SQL being run against the database. This is stored in sysaudits_0x where x is number refering to a table containing the details of an auditable event. By attaching an insert trigger to the sysaudits_0x tables it that runs an external stored via XP Server you could have an email of some other notification sent.
Like I said I haven't tried this so I don't know how difficult this to achieve, or whethe attaching a trigger to sysaudits is even going to work.