Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: xp_sendmail with @query parameter

    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

    #479383

  • RE: xp_sendmail with @query parameter

    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

    #479360

  • RE: Linked server and Windows Authentication

    Try to use linked server itself, not your development machine.

    October 23, 2003 at 1:01 pm

    #479358

Viewing 3 posts - 1 through 3 (of 3 total)