The suggested code only works if all your dbs are on the same instance. You have to re-run this for every instance you have if the databases are split between...

Informational is not an error. It's just giving you information. It's not even a warning.

Are you having problems?

There are lots of big names. If I were you, I'd google it and compare prices, options, and hardware requirements.

I can definitely attest to Gail's comment here. But I don't advise restarting until you've exhausted...

I take it you weren't running into issues before you started processing on a batch level?

What else is running when you're doing this?

TempDB holds the result sets of your...

So far as I know, MS Bing is not native to SQL Server, so does not have any procs designed for it. If there's an add-on or extended proc that...

I don't even understand the poll.

Also look up the following in Books Online:

ALTER PROCEDURE

CREATE PROCEDURE

DROP PROCEDURE

It's not a prestige thing for me. It's a "be nice to have a door to shut when people are having an impromptu conference right outside your workspace (at the...

Thanks, Gail. I just wasn't sure if R2 was being treated as a separate version or as the "upgrade" to the regular 2k8.

Datetime settings usually default to what is set in your server / database collations. That's what you need to check.

Not quite sure how to check it off the top of...

Do you have a workspace mapped to your local drive?

If not, you need to define your workspace, map it to your local drive. If you already have a folder where...

Chances are the comma is what's making the insert not work properly. You need to either regenerate your csv file with different delimiters, regenerated it with text qualifiers (so the...

I seen that movie. It did not end well.

Forget about all that. He has an office.

Oooohhhh.