The checkpoint, the log writer, QSL agent might be running. Is there some reason you want to know? Books online probably has a list.

No idea. What's the context?

I don't think this will work, but I'm not a deep enough thread programmer to know. Better to store the value in a db, like SQL Server

If file recovery doesn't do it, call MS. They might get you to a stable state. Also, do a full backup of your db file (the .mdf) right now. That's...

I'll clarify that I misworded the question The dependencies was supposed to be the correct one in my reading of BOL and the...

Short answer is I edited #2 to be correct and #4 to be incorrect. I didn't change the flagging since its a slightly bigger pain in my arse and someone's...

I did swap them around. Easier than changing the answer.

grumble, grumble, html encoding junk.

Apologies, somehow my link got encoded into nonsense. I edited it and it should work now.

I'd go with Remy's first suggestion.

After rereading the question and BOL, I agree with a number of people that #2 is the correct answer. I have corrected that fact and awarded points back to those...

Add a ROUND()?

SELECT cast( round((CONVERT(varchar, CAST(SUM(val) AS money),1)),0) as int) AS [Offered]

from mytable

No way I know of.

You have a few cases that you need to handle. An OR will do it, but there may be better ways (more efficient). So you need to handle

- people...

Beta 3 is not out. There are two post Beta 2 builds, called Community Technical Previews (CTPs) that are intermediate builds. You can get them from Beta.ms.com or MSDN. There...

I like the idea of MySQL. I think PostgreSQL is a better product, more mature, but advances occur rapidly in both products, so that might not be the case. I...