Use this:

declare @rc int

exec @rc = master.dbo.xp_smtp_sendmail

@FROM = N'servername@domain.com',

@TO = N'emailaddress',

@cc = N'emailaddress',

@priority = N'HIGH',

@Subject = N'Job failure',

@Message ...

How about UPDATEUSAGE and CHECKDB?? Do we need them?

when we execute any sql or stored proc will the results get cached, if so is it cached in the disk or...

I went ahead to check all the sql jobs in that server and also upon talking to user's they were saying that the system slows down every sunday PM, so...

Nightly is fine....

SQLBill (3/25/2008)

---

oooo bad, bad, bad set-up.

The database is in FULL recovery mode which requires the logs to be backed up if SQL Server is going to shrink them. Since...

It runs based on extended stored procs, without bounvcing the sql services can we stop the process? Thx.

Want to automate keeping the two in sync, there is no primary key, but there is a ID field that's unique.

Actually our old dba has taken daily full db backup's and tran log backup's are evry 5 hrs, I am new to backup's and we are planning to redo backup's...

Thanks, I shall take full db backup and then subsequent tran log backup's after changing the recovery model from Simple to Full.

Carolyn Richardson (3/18/2008)

---

If I ever alter the recovery model to Full from Simple the first thing I do is take a full backup, before even thinking of taking a log...

After changing the recovery to Full, I take tran...

custnumber field is unique.

Actually it's GreatPlains DB, surprisingly theer's no PK, I do'nt work much with GP and pl. do'nt ask me why there's no PK.

So far I was able to get the lastname:

left(custname, (charindex(',',CUSTNAME,1)-1)) as [LastName]

How do I get the firstname??

No it's not consistent, but most of the times it's either:

1. lastname, firstname MI

2. Lastname, Firstname, MI

There are some data issues, just for now let's consider the above combination...