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...

Do you do spicy chili or non-spicy?

kajf (10/22/2010)

---

I thank you both very very much for all help and think this is it!

However, if you find any error's or suggestions on improvement I'm all ears.

For example the...

For dtsconfig files, you can do a Windows Explorer search on the directory and it should be able to search inside the files for the account name in question. Just...

Chili!

We're having a chili cooking contest for lunch today. It's gonna be fun. I LOVE my workplace... @=)

Hee!

kajf (10/21/2010)

---

Following your instructions I applied an outer join (of course my way might be wrong). For simplicity I have not include the WHERE #AC_Temp.C IS NULL statement to show...

kancherla.ks (10/21/2010)

---

i have to select a column from a table which has all these 80 words so i am planning to write this using LIke.

please suggest me if you...

Kaj,

Did you understand my comments about how to recode for the simple solution?