Viewing 2 posts - 1 through 3 (of 3 total)
maybe it is permission problem, i have tested and found:
1) get error
EXEC xp_sendmail @recipients = 'my@mail.com',
@query = 'SELECT * FROM INFORMATION_SCHEMA.TABLES',
@subject = 'SQL Server Report',
...
December 13, 2006 at 12:52 am
#677711
I have not made any changes to this server.
I have restarted the server but the problem still existed.
thks
December 13, 2006 at 12:10 am
#677707