Srs.,
Cansei de procurar e resolvi criar por conta uma rotina que gere o script ddl de todas as procedures, funções e views!!
Segue o codigo:
1º -> Cria as tabelas
CREATE TABLE [dbo].[OBJETOS](
[idi] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[OBJETOSTXT](
[COLUNA] [varchar](8000) NULL
) ON [PRIMARY]
GO
2º-> Cria a procedure:
create proc P_GERA_DDL
as
declare @min int
declare @max int
declare @nome varchar(100)
declare @sqlstr varchar(400)
declare @sqlstr2 varchar(400)
declare @database varchar(100)
declare @data varchar(100)
insert into OBJETOS
select name from sysobjects
where xtype like 'P'
or xtype like 'FN'
or xtype like 'V'
select @min=MIN(idi) from OBJETOS
select @max=MAX(idi) from OBJETOS
while (select(@min)) < @max
begin
select @nome=name from OBJETOS
where idi = @min
set @sqlstr = 'insert into OBJETOSTXT
exec sp_helptext '+@nome
exec (@sqlstr)
insert into OBJETOSTXT
select 'go'
insert into OBJETOSTXT
select '--==============================================================--'
select @min = @min + 1
end
select @database=db_name()
select @data=replace(replace(convert(varchar(100),GETDATE(),113),':',''),' ','')
set @sqlstr2= 'exec xp_cmdshell ''sqlcmd -d '+ @database+' -Q "select * from OBJETOSTXT" -W -o C:\'+@database+'_'+@data+'.txt'''
exec(@sqlstr2)
truncate table OBJETOS
truncate table OBJETOSTXT
go
MCP: Designing and Implementing Databases with Microsoft® SQL Server™ 2000 MCP: Installing, Configuring, and Administering Microsoft® SQL Server™ 2000 MCP: Managing and Maintaining a Microsoft Windows Server 2003 Environment MCTS: Microsoft SQL Server
2005 - Implementation and Maintenance MCTS: Microsoft SQL Server 2008 - Implementation and Maintenance MCTS: Configuring Microsoft Windows Vista Wireshark Certified Network Analyst
