I have a synonym on a base table. The base table is changed as per some logic. Somehow I am unable to trucate the table using the synonym.
If synonym is defined on the base table, and if I say
"trucate table dbo.<synonym>", it gives error as.
Msg 1088, Level 16, State 7, Line 1
Cannot find the object "<synonym name>" because it does not exist or you do not have permissions.
I do have permission on the synonym, as I am the database owner.
Any updates from you guys is welcome.