Should we alter our default replies to

"press F1 for solution", "press shift+F1 for urgent solution" :w00t:

GilaMonster (9/23/2010)

---

ALZDBA (9/23/2010)

---

Msg 8921, Level 16, State 1, Line 2

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check...

very, very sad indeed

use master

dbcc checkdb ( theotherdb ) with tablock

go

Msg 8921, Level 16, State 1, Line 2

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a...

that results into:

PAGE: (1:19170)

BUFFER:

BUF @0x000000008FFF0400

bpage = 0x000000008FC10000 bhash = 0x0000000000000000 ...

use Anotherdb

print db_id()

go

11

dbcc checkdb ( Anotherdb )

go

Msg 8921, Level 16, State 1, Line 1

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a...

Since you asked for it 😉

Msg 8928, Level 16, State 1, Line 1

Object ID 53575229, index ID 1, partition ID 72057594039697408, alloc unit ID 72057594043695104 (type LOB data): Page (1:507)...

Oh yes, Dev Edtn vs Ent Edtn in licensing terms will vary more than a decent hardwares cost.

GilaMonster (9/22/2010)

---

I am seriously contemplating submitting a...

... dev data ...

If you are using a sql server developer edition (2005/2008) have a look a database snapshots as they may come in handy to retain "the morning...

How's that for a party killer 😀

Another way is using SQLCMD.

btw The solutions you are looking for in this thread are actually only exporting / importing data.

It takes more to be considered a solid backup strategy...

Steve Jones - Editor (9/20/2010)

---

Doh! Just realized I didn't start the newsletter yesterday. That's what comes from being highly unwired and busy on the weekend.

Fortunately our new hardware will get...

Congratulations, Gail !

They should add "SSC black belt" for that number op points.

Please use convert(datetime, ...., format) when you want to handle datetime info.

Check books online for the correct format parameter to be used.