/* Sunday, February 15, 200903:29:38 PM User: sa Server: NOTEBOOK 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.Vpay_mt_Staff ADD DefLang int NULL GO ALTER TABLE dbo.Vpay_mt_Staff ADD CONSTRAINT DF_Vpay_mt_Staff_DefLang DEFAULT 0 FOR DefLang GO COMMIT UPDATE Vs_DefaultAccess SET DefaultName='[G3] -' WHERE DefaultNo=3 and DefaultType='G'