Reg sp_helptext

• venkat1.v

  Newbie

  Points: 8

  More actions

  October 14, 2009 at 11:30 pm

  #136685

  Hi all,

  i need a help reg sp_helptext.when we use the sp_helptext command we wiill be getting only the procedure containg the logic we have written. bt i need to get even the grant permissions also from the procedure.for ex i need a command to retreive the procedure along with grant permissions like

  create procedure test

  {

  ----

  }

  GRANT SELECT ON [dbo].[procedure name]TO [web]

  GO

  Please help me out in this issue.would be really helpful.:-)

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  October 15, 2009 at 2:04 am

  #1066122

  You can try to change this:

  http://www.sqlservercentral.com/scripts/64793/

  Add a join with sys.sql_modules to include the object definition.....

• venkat1.v

  Newbie

  Points: 8

  More actions

  October 15, 2009 at 4:19 am

  #1066159

  HI dmoldovan,

  COuld u plz explain,bcos i tried tat sys_modules but i need it for a particlar exact procedure.could u plz explain if u don mind ??