Hi Byron,

While this is technically possible, the SQL Server’s service account likely does not have sufficient permissions to access the media folders and files.

This webpage has some good info, though I wouldn’t add any columns to TMS tables.

https://stackoverflow.com/questions/11740000/check-for-file-exists-or-not-in-sql-server#answer-11740400

Best,

David


From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Pillow, Byron T
Sent: Tuesday, December 4, 2018 9:51 AM
To: [log in to unmask]
Subject: Query Media Records for Missing Files

Hello all,

Is it possible to run a query on media records that will return instances where a media file no longer exists at its specified path?

Kindest thanks!
Byron

BYRON PILLOW
Associate Curator
National Music Museum • www.nmmusd.org<http://www.nmmusd.org>

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.