I was able to successfully use xp_sendmail on my SQL 7/Windows NT 4 server. It worked like a champ. Then we switched to Windows 2000 for the server using the same SQL 7 and xp_sendmail no longer executes. When I try a very simple call to xp_sendmail via the Query Analyzer (xp_sendmail...
I'm very new to SQL. No training yet. I'd appreciate guidance on the following. Once per day, I'd like SQL to examine records in a table and send email if certain conditions are true. I'm trying to set up a 'reminder' system to bug my intranent content...
How do you use the SET EPOCH command. I cannot find it in my old books. We are doing a system rollover and it finds the system date fine, but when we have data entry into a date field and you enter 00 into the year it assumes 1900.<br>
<br>
TIAFYH ---<br>
<br>
Lori
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.