There's an option in management studio to disallow changes that require dropping and recreating the table (which is exactly what management studio will do in this case). By default it...

I'll...

Bear in mind that in Simple a checkpoint will only truncate the log to the beginning of the oldest active log segment. Any open transactions will keep a log segment...

It'll be defined earlier in the plan. There's probably a compute scalar operator somewhere.

If you want some details, post the plan (as a .sqlplan file, zipped) and we'll take a...

Please post queries, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

I don't know what's in that bmp file, because I'm not downloading 2.5 MB to look at a...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic845222-357-1.aspx

Restore it from scratch.

You cancelled the restore part way through so the entire database was not restored. That cannot be brought online. Drop it, get a fresh backup and...

Again I'm going to ask for your definition of 'first row'. First by what criteria? Of do you just mean 'any one row, reagardless'?

Steve Jones - Editor (1/10/2010)

---

Gail,

where was that from? It's interesting, and worth a little writing. I certainly have felt that way sometimes. Someone pinged me this weekend with an "urgent"...

Please don't cross post. It just wastes peoples time and fragments replies. Especially when you post one 6 hours after the other. 6 hours is not long to wait, especially...

Problem with involving money is that walking away is no longer an option, there is a commitment to provide a solution, because the person is paying for it, and it...

Since you're not even willing (it appears) to answer my very simple questions, I'm quite happy to leave this to your highly qualified indian developers. I have better things to...

Firstly, why are you storing two numbers in varchar columns? Second, why are you storing a date split into two columns? What's wrong with a datetime column with a constraint...

But a SELECT Count will only return 1 row if there's no grouping, so why the top?

Do you want to count the distinct values in the top 50, or are...

Temp tables are either per-connection or global. There's no concept of a per-user temp table.

What you can do is give each user their own schema, set that as their...