This just in: the DBAs who work at the corporate mothership have recommended logs and tempdb on E drive, and data and indexes in separate files on F drive....

Matt Miller (6/10/2008)

---

I'm not sure I follow - you mention 6 physical drives, mapping to 4 logical drives, and yet the policy it to allow only 2?

Still - how did...

Why do people always say, "take them out and shoot...

Do you mean is the login a member of a group that is denied permissions anywhere? No, the login is a member of the local administrators group on both...

Thanks, Eric, that really helps.

I tried the copy database wizard to copy one DB from SS2000 to my laptop that has SS2005. I get this error:

While trying to find...

How big is your CSV file? If it's relatively small, and you are writing an app anyway, why not just write some code in the app to suck up...

IF (@return_the_error > 0)

RETURN @return_the_error

Also, consider this when trying to create a table:

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.tables where table_name = 'Fred')

BEGIN

create table fred (col...

Truncated? Do you mean you were expecting 8000 characters and got less? What does your input data look like?

Matt Miller (2/27/2008)

---

...which goes to highlight what worries me most about these kinds of tests: people with only the foggiest idea of the purpose for these, reading results they...

I think that was W.C. Fields.

More Groucho:

"Don't leave in a huff, leave in a hurry. If you can't leave in a hurry, leave in a taxi."

From The Suspect, by John Lescroat:

The albacore will have their vengeance.

My first job after college was for a US govt agency. Different divisions of the agency could elect to pay overtime, give comp time, or nothing for working over...

There's a command line version of bcp. See BOL.

Thanks very much.