Tag: sp_executesql

Msg 4701, Level 16 trying to truncate table through Linked Server

I was trying to truncate a table on a remote server using a Linked Server and received the following error:

Msg 4701, Level 16, State 1, Line 6
Cannot find the object "bill" because it does not exist or you do not have permissions.

Read on to see how I solved this issue.

Continue reading Msg 4701, Level 16 trying to truncate table through Linked Server
Advertisement