I have a client with a SQL-based application. They are running SQL 2005 Express on a WindowsXP workstation (it wasn't my installation, just my mess to try to clean up). One of the data files stores pictures and it has reached the 4GB limit. I cannot open the application, as it errors out, so I can't delete records that way.
The application vendor has quadrupled their maintenance/support fees, so the client has not renewed.
The data file with the pictures is not critical data.
Is there any good way to be able to delete records from this file?
If not, is there any good way to "refresh" the data file, delting its contents?