Does the SQL Server service start under a local account or a domain account?

John

So you're trying to show all books that have been order at least twice? Change books.* in the first line to books.bk_no. That will give you a list...

How efficient is nuclear after you take into account building and decommissioning over the lifetime of the reactor, and extracting the fuel from the uranium ore? And do we...

British Summer Time ended last Sunday (28th October) and so now we're back to GMT. However, the time of this post shows up as BST.

John

It's worse than that. Certain events, such as restoring a database or changing it to or from read-only status, will cause the counters for that database to be removed....

Ah, now that's a different error message. If a column in one of your tables has the IDENTITY property, that means that the value in that column is automatically...

It's just an alias for the derived table. You could also use S, T, CatsAndDogs or (almost) anything you choose.

John

Gary

I don't think those parentheses are valid syntax, although that doesn't explain the specific error that you got. Have you checked which user owns the table ACHBatches in the...

Nicholas Cain (10/30/2007)

---

I do not believe that the answer is correct.

The question was the fastest way to delete every row in a table.

Delete and truncate are not the same thing.

Should...

Surely "American capitalism at its finest" would see the tickets priced at a level such that the number of people willing to pay for them is equal to the number...

Russ

I'm not clear exactly what you're trying to do - what is the T-SQL that you're running? It may also help if you give us the table and SP...

Jonathon Prosper (10/25/2007)

---

I think it might get a bit messy around the interface between BC...

Garbage in, garbage out. If you don't know when or whether...

Can we have more questions where the answer is in the title of the question!

John

Yes. I work in the north of England... if I were based in London then I'm sure I could beat US salaries. And don't forget we Brits don't...