if exists (select * from dbo.sysobjects where id = object_id(N'{objectQualifier}DMX_Log') and OBJECTPROPERTY(id, N'IsTable') = 1)
ALTER TABLE {databaseOwner}{objectQualifier}DMX_Log 
ALTER COLUMN Operation NVARCHAR (20)

GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Add'
WHERE [Operation] = '0'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Edit'
WHERE [Operation] = '1'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Delete'
WHERE [Operation] = '2'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Approve'
WHERE [Operation] = '3'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Lock'
WHERE [Operation] = '4'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Unlock'
WHERE [Operation] = '5'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Download'
WHERE [Operation] = '6'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Rollback'
WHERE [Operation] = '7'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Upload'
WHERE [Operation] = '8'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Undelete'
WHERE [Operation] = '9'
GO

UPDATE {databaseOwner}{objectQualifier}DMX_Log
SET [Operation] = 'Import'
WHERE [Operation] = '10'
GO


