SQL Server 2000 Trigger Problem

[deboeck]

Hi,

 Adding a trigger on a table (with Operations in the context menu of a table) generates a "create trigger" statement in the DDL which has no "GO" statement in front. SQL Server 2000 does not accept a "create trigger" statement which is not the first line in a batch.
 Does there exist a work around for this behaviour ?

Thanks,
Bart

[JohnWSaundersIII]

I had the same problem, though I had it with "CREATE PROCEDURE" commands. I was in the process of sending a support request about this, when I realized that the DDL commands were separated by "\n;\n", and that there is a text box in the "GENERATE DDL" dialog which says "Use ; as SQL Separator".

If I replace the ";" with "GO", then I get the right DDL. Perhaps this will help you.

[deboeck]

Hi John,

 Thanks for the tip. It seems to me that this functionality should be present whenever SQL Server is selected. What do you think ?

Regards,
Bart

I had the same problem, though I had it with "CREATE PROCEDURE" commands. I was in the process of sending a support request about this, when I realized that the DDL commands were separated by "\n;\n", and that there is a text box in the "GENERATE DDL" dialog which says "Use ; as SQL Separator".

If I replace the ";" with "GO", then I get the right DDL. Perhaps this will help you.

[JohnWSaundersIII]

Yes, I think that should be the default, since it's what SQL Server wants by default.