Stored Procedures in MSSQL

[Tom D'Souza]

In MSSQL, how can one grant execute permissions (at the admin level) for stored precedures like xp_sendmail, xp_stopmail etc...to other users?

 

[James Hokes]

Tom,

If you want to use EM, look in 'master' under 'Extended Stored Procedures'

For ISQLW, look at BOL for GRANT.

James Hokes

In MSSQL, how can one grant execute permissions (at the admin level) for

stored precedures like xp_sendmail, xp_stopmail etc...to other users?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VG9tIEQnU291emE=?=,

Please remove the public.word.newusers group from any follow-ups to this message. It has absolutely nothing to do with MSWord...

In MSSQL, how can one grant execute permissions (at the admin level) for stored precedures like xp_sendmail, xp_stopmail etc...to other users?

Cindy Meister