Truncate Table Error Cannot find the object

How to avoid the SQL Server Truncate Table Error Cannot find the object? In SQL Server, to clear the full content of a table, the fastest way is to run a truncate Table query. The Truncate is different from the Delete From query because it empties all the lines in the table without a Where clause, it’s a database definition language SQL operation. In reality more access is needed to perform a Truncate on a table to avoid errors.

How to avoid the SQL Server error : Cannot find the object YourTable because it does not exist or you do not have permissions?

Let’s assume the table exists in the database! Then it’s a privilege error. Indeed you get this error message if you don’t have the right level of permissions to see or to manipulate the table.

Executing the query “TRUNCATE TABLE dbo.YourTable;” failed with the following error: “Cannot find the object “YourTable” because it does not exist or you do not have permissions.”
Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly.

GRANT ALTER ON [dbo].[YourTable] TO [SQLUser]
GO

Second solution is to use a DELETE instead of the TRUNCATE

If the DELETE performance allows to use it then use a statement like this one instead:

DELETE FROM [dbo].[YourTable];

We have seen how to avoid the SQL Server Truncate Table Error Cannot find the object, check out other common SQL Server Errors.

Be the first to comment

Leave a Reply

Your email address will not be published.


*