Ok, I won't change any of the tables in model as I just noticed it holds quite alot of necessary info, as a matter of fact I won't change any of the model data, but I would like it to be of a reduced size as 5MB is too much.
So I went to db shrink, backed it up first, shrunk it, great, it is now 1.38MB just enough for the info it holds.
I then went to create a db from asp.net script, and it no longer creates it gives this error:
Error: Could not obtain exclusive lock on database 'MODEL'. Retry the operation later. CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
Hummmm I said, right, went to EntMan and created a db there no problem, but from script I can't, restored model from backup, it's back at 5MB, and I can't still create db from script, what's going on?
Advise please.
Edited by theSCIENTIST - 16 October 2006 at 5:36pm