how to encrypt 500 stored procedures?

• boris_shvartsman

  Mr or Mrs. 500

  Points: 552

  More actions

  November 28, 2003 at 3:29 pm

  #59860

  without seing psycologist?

  lalafafa

  if one wants it.. one will justify it.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  December 1, 2003 at 6:05 am

  #484101

  Declaring a cursor with all the sp names, and then execute sp_helptext for each one.

  DECLARE @sp AS SYSNAME

  DECLARE curSP CURSOR LOCAL FOR

  SELECT name

  FROM sysobjects

  WHERE xtype = 'P'

  ORDER BY NAME

  OPEN curSP

  FETCH NEXT FROM curSP INTO @sp

  WHILE (@@FETCH_STATUS = 0)

  BEGIN

  PRINT 'Scripting sp ' + @sp + '...'

  EXEC ('EXEC sp_helptext ' + @sp)

  FETCH NEXT FROM curSP INTO @sp

  END

  CLOSE CurSp

  DEALLOCATE curSP