Hi

We have a number of documents references in our SQL Database and i would
like to occasionally run a script directly from Query Analyser to identify
missing documents.

The database holds the UNC Path \\servername\sharename\document.doc

Is this possible?

Thanks
B

I'm sure there is a method for writing a T-SQL script that can run from
Query Analyzer and iterate through a cursor while checking for the existence
of files located on the server.

However, for this type of general programming stuff, I would instead suggest
using the Windows Scripting Host. Perhaps write a VB script that queries the
list of documents into an ADO recorset and then uses the FileExists method
of the File System Object. This can be run from a workstation using a UNC
path or run directly on the server via Remote Console.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsoriWindowsScriptHost.asp

http://www.4guysfromrolla.com/webtech/101399-1.shtml

http://msdn.microsoft.com/msdnmag/issues/01/05/sqldmo/


Show quoteHide quote

convert flat file to native file format for bcp
Query Help: Counts & Sums
Disappearing data (happens rarely)
Year To Date?
trying to do some weird math in an update statement