Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: Running trigger t-sql as the sa

    How does one run the following command in the context of the sa account while logged in as themselves (not sa). The "SQL Authentication" user does not have access to master.


    EXECUTE master.dbo.xp_sendmail @recipients = 'hi@hotmail.ca', @subject = 'Script fired!', @message = 'Hi'

  2. #2
    Join Date
    May 2002
    Posts
    299
    Quote Originally Posted by access_dude
    How does one run the following command in the context of the sa account while logged in as themselves (not sa). The "SQL Authentication" user does not have access to master.


    EXECUTE master.dbo.xp_sendmail @recipients = 'hi@hotmail.ca', @subject = 'Script fired!', @message = 'Hi'
    sql2k does not support runas. You have to wait for yukon.
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •