如何利用OBJECT_DEFINITION系统函数进行SQL Server 2005代码存档

IF OBJECT_ID('CodeArchive','U')>0
      DROP TABLE CodeArchive



CREATE TABLE CodeArchive

(
      ArchiveID INT IDENTITY(1,1) PRIMARY KEY,
      ObjectName SYSNAME,
      ObjectDescription VARCHAR(60),
      ObjectType CHAR(2),
      ObjectDefinition VARCHAR(MAX),
      ObjectID INT,
      CreationDate DATETIME,
      ModifiedDate DATETIME,
      EntryDate DATETIME DEFAULT(GETDATE())

)



INSERT INTO CodeArchive

(
      ObjectName, ObjectDescription, ObjectType, ObjectDefinition,
      ObjectID, CreationDate, ModifiedDate

)

SELECT 
      so.name, so.type_desc, so.type, OBJECT_DEFINITION(object_id), 
      so.object_id, so.create_date, so.modify_date    

FROM
      sys.objects so

WHERE
      so.[type] IN('C', 'D', 'P', 'FN', 'R', 'RF', 'TR', 'IF', 'TF', 'V')