Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Tim Mitchell Granting Execute Access to All Stored Procedures to a Given User RE: Granting Execute Access to All Stored Procedures to a Given User

  • December 13, 2006 at 5:42 am

    #677730

    I looked up the bol. What min(name) here do ?

    SELECT @procname = min(name)

    FROM sysobjects

    WHERE xtype='P' and name > @procname and name not like 'dt_%'

    Thanks.