MCITP

MCITP

Tuesday, September 11, 2012

To grant execute permission on all Stored procedure inside a database


Use databasename

select 'Grant Execute on ' + name + ' to loginame'
from sysobjects where xtype in ('P')

No comments:

Post a Comment

Followers