I fix the security by using inherit from the top data and log file security, then the database showed up.

But today I restart the server, it has the issue again,...

Thanks all, that is very helpful

Thank you, very helpful

Thanks!

Thanks.

Thanks, so when in what situations we should run update usage?

Thanks, does udpateUsage need to be run after I changed the database compatiblity from 2005 to 2008?

I see it uses statistics to calculate the counts, does it mean I have...

SGT_squeequal (5/23/2012)

---

Also if you want to make full use of the new functionality in SQL2008 you will need to update your database comparability level to 100, then do a complete...

Thanks, I know this is good to do all, what I am concerned is:

we are going to migrate databases to new server, we want to pull off the current...

Thanks!

Thanks, how about URLroot?

You need to run the SSRS config and give it the new server name, so if it was SSRSServer and its now SQLSSRSServer then you give it SQLSSRSServer as the...

I have a question about this, for example we have a big database about 100GB, and it has to move to another new server, when doing the restore, I may...

I have another question about this.

Instead of making the gradeServed format like K-05, how can I make the format like a string with each grade in order and no...

You are right, thanks for all the help.