How to retrieve data from syscomments table?

• Ezhilan

  Ten Centuries

  Points: 1319

  More actions

  August 23, 2007 at 1:59 am

  #176131

  Hi,

  I have executed the following query...

  select text from syscomments where id = 2099048

  This is to retrive the Code in the procedure.

  I could see only portion of the 'procedure' in the output.

  /********/

  text

  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  CREATE PROCEDURE dbo.dt_displayoaerror

  @iObject int,

  @iresult int

  as

  set nocount on

  declare @vchOutput varchar(255)

  declare @hr int

  declare @vchSource varchar(255)

  declare @vchDescription varchar(255)

  exec @

  (1 row(s) affected)

  /**************/

  How can I retrieve the entire code of the procedure using syscomments table.

  Regards,

  Ezhilan

• Vladan

  SSC-Insane

  Points: 22072

  More actions

  August 23, 2007 at 2:20 am

  #728809

  If you are running this in QA, go to Tools>Options>Results and set Maximum characters per column.

• Ezhilan

  Ten Centuries

  Points: 1319

  More actions

  August 23, 2007 at 2:32 am

  #728812

  Thanks...

  Its working fine..