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...

what do you mean it can see the SQL Server? You can log in? If you can log in, SP2 has nothing to do with it. It would be a...

I'd use the Apex tool or another as documentation is best done by a tool.

Just insert permissions

set identity_insert mytable on

insert mytable (myidentity, myvalue) select @myid, @myval

set identity_insert off