I'm trying to come up with a way to use a C# program(either console or windows service) that gets called from a sql job running every 10 mins that checks a DB table for an entry and if so it triggers of a notiification window on user machine with a message.
Have you read the article I posted earlier on debugging a service? You can also put debug versions of your service out there and attach to it and debug like any windows application to see what happens.
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.