XP SMTP how to grant execute permissions to sysadm

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

XP SMTP how to grant execute permissions to sysadm

Author

Topic

reddymade
Posting Yak Master

165 Posts

Posted - 2006-02-02 : 11:52:33

How to grant execute permissions to xp_smtp_sendmail to sysadmin


-- SQL Server 2000 needs to use instance aware Registry read 
if (charindex(N'8.00', @@version, 0) > 0)
begin
	exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'
end

grant execute on xp_smtp_sendmail to sysadmin

Thank you very much for the information.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources