Any views contained within are my personal views and not necessarily Microsoft policy or the policy of Sta-home Health & Hospice, Inc.All posts are provided "AS IS" with no warranties, and confers no rights.
In Recovery by Paul RandalSQL Skills by Kimberly Tripp
Creating an EDW for CBI SeriesGetting Data from Point A to Point B
For years I have been writing alerts to let either myself of someone else know that there is a problem somewhere so that it can be fixed before it becomes a major issue. Now, over the years I have boiled my alerts down into a few generic types. And while I will keep you guessing as to the types of alerts themselves, I will give you the code to one of them for your review.
Now, I can just about assure you that this code will not work on your system as is. You will need to modify it to fit your needs. Things like who gets the alert, your database names, the actual name of your 401k deduction and benefit codes, etc.
I hope that most of it is understandable for most people but as always if you have any questions feel free to drop me a line, (just remember to put GPUG) in the subject line.
Here is the link to the code on the GPUG Share My Code
this later,