Bloqueando OS Baús Duppers de
ESSE Execute Código não SQL Query Analizer UMA Vez nd Semana Garantia por.
Selecione um DB MuOnline
copie e cole o Código:

Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [trg_CheckSameID]') e OBJECTPROPERTY (id = 1 N'IsTrigger ')) desencadear queda [dbo]. [trg_CheckSameID] GO se existe (select * from dbo.sysobjects where id = object_id (N '[dbo]. [AllItemsLog]') e OBJECTPROPERTY (id, N'IsUserTable ') = 1) drop table [dbo]. [AllItemsLog] GO se existe (selecione * a partir de dbo.sysobjects where id = object_id (N '[dbo]. [copylog]') e OBJECTPROPERTY (id, N'IsUserTable ') = 1) drop table [dbo]. [copylog] vai criar] TABLE [dbo. [AllItemsLog] ([items_id] [int] IDENTITY (1, 1) NOT NULL, [items_type] [binary] (1) NOT NULL, [items_serial] [binary] (4) NOT NULL, [items_acid] [varchar] ( 10) COLLATE Chinese_PRC_CI_AS NOT NULL) ON [PRIMARY] GO CREATE TABLE [dbo]. [copylog] ([copy_id] [int] IDENTITY (1, 1) NOT NULL, [copy_acid] [varchar] (10) NOT NULL COLLATE Chinese_PRC_CI_AS [copy_whdata] [binary] (1200) NOT NULL, [copy_date] [datetime] NOT NULL) ON PRIMARY] GO [ALTER TABLE [dbo]. [AllItemsLog] ADD CONSTRAINT [DF_CT_ITEM_item] DEFAULT (0) para [items_type] CONSTRAINT [DF_CT_ITEM_itemid] DEFAULT (0) para [items_serial], CONSTRAINT [DF_CT_ITEM_itemrole] DEFAULT ('') para [items_acid] GO CREATE INDEX [IX_CT_ITEM] ON [dbo]. [AllItemsLog] ([items_type], [items_serial]) ON [PRIMARY] GO ALTER TABLE [dbo]. [copylog] ADD CONSTRAINT [DF_CopyLog_copy_date] DEFAULT (getdate ()) para [copy_date] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO