Viewing 3 posts - 1 through 4 (of 4 total)
I found @query parameter a little bet an logical in xp_sendmail. @recipient, @subject etc. have their place there. One way to get around it is pass query as a parameter...
October 23, 2003 at 4:31 pm
works fine on sql2000.
SENDEMAIL:
DECLARE @MailSubjectVARCHAR(1000)
SET @MailSubject = (@var1 +' '+ convert(varchar,datepart(mm,getdate())) + '/' + convert(varchar,datepart(d,getdate())) + ' ' + right(convert (char(19), getdate(), 100), 7))
IF @EMAILADDRESS IS NULL
...
October 23, 2003 at 1:12 pm
Try to use linked server itself, not your development machine.
October 23, 2003 at 1:01 pm
Viewing 3 posts - 1 through 4 (of 4 total)