MSSQL - Fix Error - No item by the name of 'schema.Orders' could be found in the current database 'Company', given that @itemtype was input as '(null)'.

Watch this example on YouTube


Msg 15225, Level 11, State 1, Procedure sp_rename, Line 418 [Batch Start Line 0]
No item by the name of 'schema.Orders' could be found in the current database 'Company', given that @itemtype was input as '(null)'.


To Fix is replace

exec sp_rename 'schema.Orders', 'Orders2'

With

exec sp_rename 'Orders', 'Orders2'