external name in a trigger

[junkmail]

Can someone tell me why I am getting a syntax error on the following
statement?

External Name sqlserverproject1.sqlserverproject1.Triggers.fs_trigger1


Msg 156, Level 15, State 1, Procedure fs_tr_add, Line 17
Incorrect syntax near the keyword 'External'.

 

[SimonSellick]

You haven't shown enough of your script to determine what the parser is expecting to see. I get that message if I start a statement with the line you have posted but not if I include it in a CREATE PROCEDURE statement (although it then complains about an extra '.' in the method name).

 

[junkmail]

I have it working now..Thanks.