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.

Grant Fritchey (10/25/2010)

---

george sibbald (10/24/2010)

---

I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the maintenance plans....

You're very welcome. We're glad you figured it out.

Thanks for posting your solution. That will help other people in the future.

biscuit

George,

Apply patches is a good one. I forgot about that. If you think of anything more, please let me know.

I've got SQL Configuration and Surface Area Configuration down, but...

Hey, If I...

This is what the 2005 BOL states:

It might be working. Test a new login.

Bill,

You can't get good help without posting sample data, DDLs and code. The way to overset the privacy restrictions is to basically scrub your data and code. Make it generic...