/* Wednesday, February 25, 20095:46:14 PM User: sa Server: VIEWSONIC Database: retDataFile Application: */ /* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/ BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION GO ALTER TABLE dbo.Vpos_mt_Terminal ADD Remark1 varchar(100) NULL, Remark2 varchar(100) NULL, Remark3 varchar(100) NULL, Remark4 varchar(100) NULL, Remark5 varchar(100) NULL, Remark6 varchar(100) NULL, Remark7 varchar(100) NULL, Remark8 varchar(100) NULL, Remark9 varchar(100) NULL, Remark10 varchar(100) NULL GO COMMIT select Has_Perms_By_Name(N'dbo.Vpos_mt_Terminal', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_Terminal', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Vpos_mt_Terminal', 'Object', 'CONTROL') as Contr_Per