When you talk size you do not mean the datafile size?

And export/import could be a means of defragmentation/index rebuilds and that should account for a little decrease in the...

I forgot you had to look at the extracted file(executable) and run it

All worked fine

Mike

Roles should be a bunch of privileges assigned to users.For a bunch of privileges to own a job may be an interesting feature.

My opinion "I am not sure roles...

I will assume sql server agent is started?

Mike

Do you by any chance have different versions

of sql server?

To express it differently I will like to be able to update MSDE and one of the things you need to do is to choose the version of sqlrunXX.ini .I...

I did the same on a trial edition and the version did not change.

Sp3a is "supposed" to be able to update trial editions but this did not .

I had no...

Thanks Simon could you expand please?

Are you having any specific problems after you select your database go to tools and double click SQL Query Analyzer

Mike

I really do appreciate your reply sql server books aside

can some one recommend a books which may not be subject related but gives you an...

Thanks for the responses guys.Back to the issue of books.

Any one with a book that probably made a great impact?

I do not have many of the desirable circumstances just listed...

Tried it out and it worked fine.

Just chose a test database to install the repository on

Thanks

Mike

Checked out one in Amazon called the logic of failure with by the same author with train reck on its cover.Recognizing and avoiding error in complex situations.

Let me know if...

Will try that out on a test system right away .The other tools from microsoft in the likes of killpwd.exe and storepro.exe have done a great job for me

Thanks

Mike

...

Manually sp_spaceused should be of use

Mike