I turn it off just because I've read that since it's OFF by default at installation, it's best to leave it that way. Also (I read) having it on...

This is what has worked for me. This code is embedded in a S/P and runs on a schedule and gives me a CSV like clockwork every night. ...

Thanks, guys.

I was able to solve my own problem of weeding out the dupes by rewriting a subquery.

I had used a table alias in a...

Lowell, I would love to learn more about set-based coding but this seems to require a cursor.

I'm in a legal case management system. Each case is a Matter, matters...

I don't believe we should have to work extra time beforehand to get our promised vacation time unhampered by calls from work.

But when things don't work out that way, it...

We have no plans to upgrade to 2012. For us, there is so discernible business benefit to doing so.

We have a mix of applications running both 2005 and 2008,...

I still don't know the structure of the dimglobalkeys Table, so I still can't help much. You should always post as much information as you can in the body...

Can you give example data showing the CSV data, and how that should go into the SQL Server table?

I was speaking to my nephew while visiting for Easter. He is in school for electrical engineering. One point that came up is the story of how the...

Damn! I was ready to run out at lunch and buy a pair!

I'm with Jeff. This is very cool stuff butvery ominous, too. I do have a SQL utility user pwd that I've lost, so this will be useful. ...

@lowell,

Thanks for the quick answer. Yes, a rookie mistake. (pause for hanging head in shame)

Is there a word for having to learn so many fine points...

This is a related question, hoping someone on this thread can answer it.

I've had a working bcp process for months that creates a CSV file on a network drive. ...

I work as a sole programmer for a law firm doing both ends, front and back. I've been with SQL Server since around 2000. Before that I had...

I don't think Bill Nicolich intended to redefine the word technology as much as point out that making technology is what humans do, and limiting the definition of the word...