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.