Why? What are you trying to achieve here?

Gary T (3/1/2010)

---

"SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x22412a3d; actual: 0x2241223d). It occurred during a read of page (1:246058) in database ID 20 at offset...

I don't have a problem with using identities. What I do have a problem with is using identities as the only unique identifier of the entire table.

When the primary...

If you query sys.databases, what's the state_desc of the DB that you cannot access?

No. Where did that syntax come from? Looks like maybe Oracle.

if not how...

Well, I was asking for the largest single table so I could make...

There's no info on the MS website for two reasons:

The exam format changes from time to time

The exact format isn't mean to be public information

In my PASS session on statistics, I asked the audience for the largest table anyone had worked with....

One gentleman had a 100 billion row table. He wouldn't tell me what...

That's a little extreme, don't you think?

There are documented ways (and scripts) to rebuild msdb. eg here - http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx

Sure, a reinstall will fix it, but you'll have wasted all...

Two things that you may want to read:

Managing Transaction Logs[/url]

http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

JohnnyDBA (2/28/2010)

---

1) Is there some kind of serverproperty that returns this version number of the databases it will generate or do I just need to know this list? Is...

The biggest problem you are likely to have is drivers. A 64-bit SQL Server cannot use 32 bit ODBC/OLEDB drivers, hence you need to ensure that there are 64-bit drivers...

The general rule is that you can always upgrade (so 611 onto a server with databases in 612 or 655) but you can never downgrade.

There's a partial list here: http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/28/database-version-vs-database-compatibility-level.aspx...

I'm waiting for a second opinion from an expert on corruption. Please be patient.

CirquedeSQLeil (2/27/2010)

---

Paul White (2/27/2010)

---

I had noticed that too, but thought 'Welsh Corgi' had...