December 22, 2009 at 12:20 pm
What do I need to do to set up? What disadvantages could happend?Thank you
December 22, 2009 at 12:34 pm
Krasavita (12/22/2009)
What do I need to do to set up? What disadvantages could happend?Thank you
I remember, this is not the first time I am suggesting you to find the information on Google and post issues / errors when encountered rather than you ask such questions and some one replies with a link to an article / blog.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 22, 2009 at 12:41 pm
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) the only way we could clear it was reboot the server. Restarting SQL Server would sometimes clear the problem, but usually a reboot was required. Partially resolved by rebooting the server on a scheduled basis, weekly iirc.
Actually setting up, not too difficult. The instruction are readily availble in the BOL (you know, the SQL Server Help System).
December 22, 2009 at 12:45 pm
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 be difficult at times to find it. BOL does have a search function that could help.
December 22, 2009 at 12:46 pm
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 a major pain and other solutions worked much better.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 22, 2009 at 12:49 pm
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 a major pain and other solutions worked much better.
I agree fully. An alternative is to upgrade to SQL 2005. Another is to use a homegrown mailer that employs smtp.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 12:51 pm
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 Collaboration Data Objects and I'm sure you will find plenty of possible links to useful (and not so useful) information.
December 22, 2009 at 1:03 pm
Lynn Pettis (12/22/2009)
BOL does have a search function that could help.
Can you help where to find Books Online ... and how many books are available... 😛 😛
Merry Christmas Lynn ... hope you had a great time last weekend with your daughter being back for Christmas.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 22, 2009 at 1:11 pm
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 a major pain and other solutions worked much better.
I agree fully. An alternative is to upgrade to SQL 2005. Another is to use a homegrown mailer that employs smtp.
Here's a starter page:
http://support.microsoft.com/kb/312839
And another:
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=SQL2000CDOSysMail
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 1:14 pm
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 a major pain and other solutions worked much better.
I agree fully. An alternative is to upgrade to SQL 2005. Another is to use a homegrown mailer that employs smtp.
Here's a starter page:
http://support.microsoft.com/kb/312839
And another:
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=SQL2000CDOSysMail
I knew I knew you would give a link and the OP is happy clicking links and reading, and that's bringing more and more of such questions....:-P 😛 😛 Never mind, just kidding.....
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 22, 2009 at 1:18 pm
Bru Medishetty (12/22/2009)
Lynn Pettis (12/22/2009)
BOL does have a search function that could help.Can you help where to find Books Online ... and how many books are available... 😛 😛
Merry Christmas Lynn ... hope you had a great time last weekend with your daughter being back for Christmas.
It's nice having her home. She took us out to dinner last night. She was craving Chipolte (there isn't one in San Angilo TX apparently).
She leaves on January 1st. Not looking forward to that at the moment.
Merry Christmas, Bru, and a Happy New Year too!
December 22, 2009 at 1:20 pm
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 a major pain and other solutions worked much better.
I agree fully. An alternative is to upgrade to SQL 2005. Another is to use a homegrown mailer that employs smtp.
Here's a starter page:
http://support.microsoft.com/kb/312839
And another:
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=SQL2000CDOSysMail
I knew I knew you would give a link and the OP is happy clicking links and reading, and that's bringing more and more of such questions....:-P 😛 😛 Never mind, just kidding.....
I did it just for you and Lynn 😀
Reading material is always good. Krasavita, if you go and read the articles and still have questions - don't hesitate to formulate those questions in this forum. Please be specific with your questions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 1:23 pm
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 a major pain and other solutions worked much better.
I agree fully. An alternative is to upgrade to SQL 2005. Another is to use a homegrown mailer that employs smtp.
Here's a starter page:
http://support.microsoft.com/kb/312839
And another:
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=SQL2000CDOSysMail
I knew I knew you would give a link and the OP is happy clicking links and reading, and that's bringing more and more of such questions....:-P 😛 😛 Never mind, just kidding.....
I did it just for you and Lynn 😀
Reading material is always good. Krasavita, if you go and read the articles and still have questions - don't hesitate to formulate those questions in this forum. Please be specific with your questions.
Be as detailed and concise as possible as well. It will definitely help us help you.
December 22, 2009 at 2:19 pm
I see the necessary high velocity pork has already been flung on this one... moving on...
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply