Where do...

Some sample data would help, both good and bad, along with the expected results based on the sample data.

Good to know. Thank you. Have you thought about writing this up as an article for ssc? You should.

Colorado Springs, CO USA is where I call home. Born and raised in Colorado.

CirquedeSQLeil (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

CirquedeSQLeil (12/22/2009)

---

CirquedeSQLeil (12/22/2009)

---

GSquared (12/22/2009)

---

There are detailed instructions online at MSDN.com for setting this up, and the pros and cons of doing so.

In my own experience, it was...

Hey, this is the BEST place to waste time. I enjoy my time out in the desert!

Bru Medishetty (12/22/2009)

---

Can you help where to find Books Online ... and how many books are available... 😛 😛

Merry...

Bru Medishetty (12/22/2009)

---

CirquedeSQLeil (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

Our good old friend has another doubt anyone care to answer ?

http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

Recollect some of his / her famous threads.

Lock Pages in Memory

How to see password

How...

I would also configure the maximum memory for SQL Server to 20 GB (20480 MB), leaving 4 GB RAM for the OS. Are there any other applications running on...

CirquedeSQLeil (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

CirquedeSQLeil (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

Our good old friend has another doubt anyone care to answer ?

http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

Recollect some of his / her famous threads.

Lock Pages in Memory

How to see...

CirquedeSQLeil (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

Our good old friend has another doubt anyone care to answer ?

http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

Recollect some of his / her famous threads.

Lock Pages in Memory

How to see password

How to know...

IIRC, Collaboration Data Objects is the way many people went for sending emails from SQL Server 2000. Not sure how much info BOL has on CDO, but just Google...

Curious I am, have you even bothered looking in Books Online before jumping out here on SSC? Lot of good information is available in there, even if it can...

SQL Server 2000, SQL Mail, requires a MAPI compliant client be installed on the server (i.e. Outlook, not Outlook Express).

Can hang causing emails not to go, and (in my experience)...

Full circle. You may want to look at Service Broker. Start by reading about it in BOL.