We are running an application that has hit a limit of 5000 records. Thought it might be because we are using SQL Express. We purchased full version of 2008 R2, installed, backed up and restored the DB. Still we can only see 5K records when I know there are over 15K. Is there some maintenance I can perform on the DB, do see an option to shrink? The DB has been running for some years now and no tuning or maintenance has been performed.
Guess it could be the application that is the limitation. Going to check with the vendor.
Meanwhile would like thoughts from anyone!