• see this article: http://www.sqlservercentral.com/articles/alerts/89885/ on how to create an alert. From SSMS you can script the actions just before clicking the final [OK] or you can script the object when it is created.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **