SQL Server Stored procedures and Triggers for the Broken Link Validator
The following stored procedures can be used during or after publishing to trigger the Broken Link Validator. Doing this would enable you to check the newly published content and immediately notify an author if any broken links are found.