sananthakumar (4/13/2010)

---

I am using Sp_Send_DbMail to send the mails. Everything works fine. But When we try to change the from address from code it wont allow and also through the...

jcrawf02 (4/12/2010)

---

Jason Shadonix (4/12/2010)

---

I don't expect bleeding edge up to date, but at least teach current stuff. At a bare minimum this should be centered around SQL 2005 (IMO)....

I don't expect bleeding edge up to date, but at least teach current stuff. At a bare minimum this should be centered around SQL 2005 (IMO). I would...

Lynn Pettis (4/12/2010)

---

CirquedeSQLeil (4/12/2010)

---

Where is that one? I...

Good point. I don't mean to suggest it's not OK to ask for help. Just...

Jeff Moden (4/12/2010)

---

This is precisely why I don't trust people with letters after their names. Tell your friend to do his/her own work and to earn the degree instead...

Interesting. Just out of curiosity, what is the masters program in? Seems like some pretty basic SQL questions for a masters-level class.

In that case, what degree or cert...

I wonder if you can write a quick and dirty VB or C# front-end or CLR type of thing to accomplish this.

george sibbald (4/7/2010)

---

Jason Shadonix (4/7/2010)

---

Why do you say that? Is there a reason you wouldn't want...

Neat! I didn't know that!

--to enable compression

sp_configure 'backup comp', 1

go

reconfigure

go

Just curious but I don't recall reading anything within the TechNet article that mentioned a hierarchy requirement when doing WITH command. Why compression must come...

Why do you say that? Is there a reason you wouldn't want to compress a backup...

I don't have COMPRESSION first in my list of options either...

Are you talking SQL authentication or Windows authentication here?