I created a trigger. I can see it has been properly created under the table I wanted. Then, after I refreshed the Triggers branch, I can now see there is that new trigger that I just created. Double clicking on it goes in update. However, the update syntax fails :
ALTER TRIGGER [dbo].[AcronymUpdate]
The [dbo].[AcronymUpdate] syntax is red highlighted saying "Invalid object name 'dbo.AcronymUpdate'.
This is from the default functionality of SQL Server. Anyone would know why it fails?