Post this in the Sql server 2005 for better responses.You posted this in sql server 7, 2000.

For the alerts u mentioned will have to create SP (stored procedures)

With regards

MJ