Bloqueando OS Baús Duppers de
ESSE Código de Execução nao Analizer consulta SQL UMA Vez Por Garantia ª Semana.
Selecione a DB MuOnline hum
copie e cole o Código:

SE EXISTE (dbo.sysobjects SELECT * FROM where id = object_id (N '[dbo]. [Trg_CheckSameID]' OBJECTPROPERTY e) (id = 1 N'IsTrigger ')) desencadear Qaeda [dbo]. [Trg_CheckSameID] VAI SE EXISTE (select * from dbo.sysobjects where id = object_id ('[dbo]. [AllItemsLog]' N OBJECTPROPERTY e) (id, N'IsUserTable ') = 1) drop table [dbo]. [AllItemsLog] VAI SE EXISTE (* selecione um dbo.sysobjects Partir de onde id = object_id (N '[dbo]. [Copylog]' OBJECTPROPERTY e) (id, N'IsUserTable ') = 1) drop table [dbo]. [Copylog] vai CRIAR] dbo [TABLE. [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) NÃO Chinese_PRC_CI_AS 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) Pará [items_type] CONSTRAINT [DF_CT_ITEM_itemid] DEFAULT (0) Pará [items_serial], CONSTRAINT [DF_CT_ITEM_itemrole] DEFAULT ('') Pará [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 ()) Pará [copy_date] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO