declare @s varchar(8000)
set @s='
create procedure protestb
as
select * from test.dbo.databletest'
use ReportServer
exec(@s)
set @s='
create procedure protestb
as
select * from test.dbo.databletest'
use ReportServer
exec(@s)
gocreate procedure sp_test
as
begin
exec('use test exec(''create procedure sp_test1
as
select * from sysobjects'') ')
end
goexec sp_test
godrop procedure sp_test
gouse test
goexec sp_test1
godrop procedure sp_test1
go