I am using VB Express 2005 with an SQL Express 2005 database. I had filled it with an equivalent of 10 years of data to check performance. I have deleted the data and need to compact the database to shrink the size of the database file.

I have searched extensively but am unable to find any useful information on it. Can somebody please help?

Greg