MS SQL Server - Alerts

Author

Alerts

docsql

2006-01-18, 8:23 pm

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. The network admin team is
not ok with installing any mail client. Is there any other way to have
email alerts setup without installing any mail client?

Hilary Cotter

2006-01-19, 3:23 am

use http://www.sqldev.net/xp/xpsmtp.htm

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"docsql" <docsql@noemail.nospam> wrote in message
news:OLBxJoIHGHA.2444@TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
>up email alerts and reporting on the SQL server. The network admin team is
>not ok with installing any mail client. Is there any other way to have
>email alerts setup without installing any mail client?
>
>
>

Tibor Karaszi

2006-01-19, 7:23 am

You can use http://www.karaszi.com/SQLServer/util_smtp_alerter.asp. But I haven't looked at the code
for a long while now. If you want to use this and run into problem, I can provide you with source
code (VB.NET) so you can go in and fix stuff.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"docsql" <docsql@noemail.nospam> wrote in message news:OLBxJoIHGHA.2444@TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting up email alerts and
>reporting on the SQL server. The network admin team is not ok with installing any mail client. Is
>there any other way to have email alerts setup without installing any mail client?
>
>
>

Sponsored Links