Send email using sql stored procedure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aish
    New Member
    • Sep 2005
    • 5

    Send email using sql stored procedure

    I want to send email using sql stored procedure.my code is work fine in my local sqlserver account. when I use my online sql server it display this error.

    EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OASetProper ty', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.

    How canI solove this problem?
  • Kinshuk
    New Member
    • Dec 2005
    • 1

    #2
    you should have SYsAdmin permissions to execute sp_OAcreate

    Comment

    Working...