Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-04-28 : 15:59:41
|
| How to check , whether sql mail is configured or not using TSQL in sql server 2000?------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 16:04:37
|
| You could try running any of the xp stored procedures for SQL Mail and see if you get an error. Check out xp_startmail and xp_sendmail for starters.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-28 : 16:37:26
|
| Are there any system tables or log tables , that get created when you enable sql mail? I need to write a script check this across multiple servers?------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-28 : 22:10:21
|
| Not as I know of. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-29 : 09:16:53
|
| ok. Thanks------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
SQL mail in SQL 2000