The caches are flushed whenever a restore occurs. This includes restores of transaction logs.

It might be something to worry about if you're using the secondary as a reporting server, but...

You get points from correctly answering the Question of the Day as well.

If you open a query window...

Read the entire of this kb article carefully. Especially the section "Effects of Execution of DBCC SHRINKDATABASE or DBCCSHRINKFILE While Tempdb Is In Use"

http://support.microsoft.com/kb/307487

What do you mean? How are they different from what?

Dave Winchester (2/18/2010)

---

Thanks for the response. My question about the CreatedDate, CreatedBy...columns - was more along the lines of "Should I have them?" in a social networking site with 100K+...

GilaMonster (2/18/2010)

---

Gianluca Sartori (2/18/2010)

---

I've been spending some time trying to make it return rows in a different order, but I did not succeed. Does anybody have a script to do...

Gianluca Sartori (2/18/2010)

---

I've been spending some time trying to make it return rows in a different order, but I did not succeed. Does anybody have a script to do that?...

If I'm reading the q correctly, he wants the data in the identity order, but...

Did you detach it?

DB doesn't have to be accessible. Just listed as a database in SQL (ie must be listed in elect name from sys.databases )

Logical order of the index - yes

Physical order of the data - no

Order that...

We don't even know if there is any corruption there. There's nothing I could see in the errors posted that...

If the recovery model is full and the recovery model has not been changed since that full backup, if no one has ever truncated the transaction log and if the...

Locks get applied to any table...

If you try to connect via management studio, what error do you get?