Problems with alter trigger
EsioN
Posts: 103
Some of my trigger has blank line before the create trigger statement.
For these trigger, SP3.5 doesn't show me the code. They are listed in alter trigger <trigger list), but the code doesn't appear.
Thanks.
For these trigger, SP3.5 doesn't show me the code. They are listed in alter trigger <trigger list), but the code doesn't appear.
Thanks.
Comments
Can you paste an example of what you mean please? I can't see any reason why a blank line before the CREATE TRIGGER would cause a problem.
Thanks,
Bart
Principal Consultant
bartread.com Ltd
And look, if I use the following statement, but with alter table, with the blank lines before the statement, when I refresh the cache. SP35 now can show the trigger code, but doesn't show the blank lines
**********************
CREATE trigger AMZ_Delete on dbo.ARMAZEM
for DELETE
as
select * into #inseridos from inserted
select * into #deletados from deleted
execute dbo.pr_Grava_Log 'ARMAZEM'
@ERROR <> 0 GOTO Erro
return
ERRO:
begin
ROLLBACK TRANSACTION
@servername)
RETURN
end
*******************************
Cheers,
Bart
Principal Consultant
bartread.com Ltd