Thanks Gail. Good article, although this doesnt make me very hopeful for a move anytime soon.

There are no openings in my company, and even if there were, there are no...

will the tab delimited file created here be Unicode UFT-8 or ANSI though?

cant use excel as it doesnt save in the correct encoding, and also there are hundreds of thousands of rows so its not that efficient to use excel.

also excel is...

found the reason, there was a constraint on the 2nd table, which has a cascade delete enabled.

It wasnt showing up in profiler so i was stumped. I can sleep now,...

I tried using profiler but it showed up nothing. Thats why i am confused as to how the row is being deleted in the 2nd table.

Oxford, no, never lived there! Why do you ask?

This is already implemented in production, so i cant modify it. there are temp tables (#tablename) in teh sproc, and updates are done on tables joined to these temp...

stupid me, just figured it out, 70-432 and then 70-450.

So I detached my db, and using a hex editor i zeroed out a few entries.

when i try to atach the db i get this error:

Msg 824, Level 24, State...

great stuff. thanks guys.

awesome. Thanks for the quick reply.

actually, just found this in an MSDN article:

A table cannot be enabled for compression when the maximum row size plus the compression overhead exceeds the maximum row size of 8060...

no testing done. im at home without access to a windows pc with sql server installed.

i read it in MCTS 70-432 exam training kit by microsoft press. just want to...

so what happens in the case of a power outage? is sql server able to recover without intervention, as long as the storage media is ok? there will be some...

cool, so just to spell it out for myself, before restarting the physical server its always best practice to stop the sql service first so it has less recovery work...