SQL Server 2000
Q1: I have an ini file that I need to read via t-sql. the only way I was able to get it to work was to use the QGREP command with xp_cmdshell and querying the results.
Works great but messy and if fat figure Freddy changes the ini file and put a space somewhere it doesn't belong the command will fail.
Does anyone have another way to read an ini file via t-sql?
Q2: This is easy. How to get xp_sendmail to work with a global distribution list. Microsoft states:
"...The xp_sendmail system extended stored procedure may not be able to resolve a personal distribution list"
Notice that I an using a Global list and by global I mean, this list is sitting on our Exchange server for all to see and use.
Has anyone ever used xp_sendmail with a distribution list?
Thanks in advance for any help
Well Done is better than well said
- Ben Franklin
