Home Forums SQL Server 7,2000 Administration view the data from the sysmail_sentitems and sysmail_unsentitems and sysmail_faileditems without giving sysadmin role MSDB databasse RE: view the data from the sysmail_sentitems and sysmail_unsentitems and sysmail_faileditems without giving sysadmin role MSDB databasse

  • May 20, 2013 at 7:21 am

    #1616603

    sysmail_sentitems

    sysmail_unsentitems

    sysmail_faileditems these are the views in msdb and without giving sysadmin role MSDB databasse,

    how to access the data????

    Write a sql report that the user can run that executes these queries and presents the results in a friendly fashion. The account used in the datasource can have necessary role and doesn't have to be revealed to anyone and doesn't have to be the user's account.