Using SQL Server 2000 and creating a remote system monitor. I'm writing a small .NET app that retrives basic data from the remote sql server by connecting to the remote SQL Server using a standard TCP/IP connection. On each of the remote servers, I want to check to see if a directory exists. Is there sometype of system stored procedures that I can query and pass the drive/directory as a parameter?
Thanks
Kirk