C#

using System.IO;

_watcher = new FileSystemWatcher();
_watcher.Path = folder;
_watcher.IncludeSubdirectories = true;
_watcher.NotifyFilter = NotifyFilters.LastWrite | NotifyFilters.DirectoryName | NotifyFilters.FileName;
_watcher.Changed += new FileSystemEventHandler(OnChanged);
_watcher.Created += new FileSystemEventHandler(OnChanged);
_watcher.Deleted += new FileSystemEventHandler(OnChanged);
_watcher.Renamed += new RenamedEventHandler(OnRenamed);

Rob Philpott wrote:

Sql Server 2005

Rob Philpott wrote:

managed stored procedures in C#, so you could use some mechanism like Remoting to send an update from your managed proc to the listening process. You'd then need to link your managed proc into the trigger.

<br />
            decimal d = 100.0000m;<br />
            string s = string.Format("{0:000.00}", d);<br />
            Console.WriteLine(s);<br />

<br />
100.00<br />

<br />
String strUnitPrice = String.Format("{0:#,##0.00}", 100.3456);<br />

static void Main(string[] args)
{
    if (args.Length != 0)
    {// Evaluate the comand line arguments.
        for (int index = 0; index < args.Length; index++)
        {
            if (args[index] == "/?")
            {
                // Print out help to console
                return;
            }
        }
        // No known command line argument received so show error and preferably help to
    }
    else
    {
        // No command line arguments so run your application as usual

    }
}

if(args.Length > 0) // check if there are arguments to prevent exception<br />
{<br />
  if(args[0] == "/?")<br />
  {<br />
     // you code<br />
  }<br />
}

string GetCurrentProcessName()
{
    return Process.GetCurrentProcess().ProcessName;
}