>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?

That is because SSMS doesn't refresh its Intellysence.
If you execute the code you will get no errors.