Check Re: Dbcc checkdb Message #859433
,

>How I make to execute a Script using SQL-DMO?
>Sample Script:
>
>

>if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TabelaPrecos_V]') and OBJECTPROPERTY(id, N'IsView') = 1)
>drop view [dbo].[TabelaPrecos_V]
>GO
>
>SET QUOTED_IDENTIFIER ON
>GO
>SET ANSI_NULLS ON
>GO
>
>/****** Object:  View dbo.TabelaPrecos_V    Script Date: 10/05/2004 08:41:33 ******/
>CREATE VIEW dbo.TabelaPrecos_V
>AS
>SELECT     TOP 100 PERCENT dbo.PRODUTOS.ProdNome, dbo.PROD_PRECOS.ProdPrecPreco, dbo.PROD_PRECOS.ProdID, dbo.PROD_PRECOS.TabelaID,
>                      dbo.PROD_PRECOS.ProdPrecID, dbo.TAB_PRECOS.FilialID
>FROM         dbo.PRODUTOS INNER JOIN
>                      dbo.PROD_PRECOS ON dbo.PRODUTOS.ProdID = dbo.PROD_PRECOS.ProdID INNER JOIN
>                      dbo.TAB_PRECOS ON dbo.PROD_PRECOS.TabelaID = dbo.TAB_PRECOS.TabelaID
>WHERE     (dbo.TAB_PRECOS.TabelaStatus = 0) AND (dbo.PRODUTOS.ProdStatus = 0)
>ORDER BY dbo.PRODUTOS.ProdDesc
>
>GO
>SET QUOTED_IDENTIFIER OFF
>GO
>SET ANSI_NULLS ON
>GO
>
>