The EXECUTE permission was denied on the object ‘sp_tables_info_90_rowset_64’

When trying to create a linked server and executing a “select * from” I recieved the following error: OLE DB provider “SQLNCLI11” for linked server “SERVERNAME” returned message “Unspecified error”. Msg 229, Level 14, State 5, Procedure sp_tables_info_90_rowset_64, Line 1 The EXECUTE permission was denied on the object ‘sp_tables_info_90_rowset_64’, database ‘mssqlsystemresource’, schema ‘sys’. Seems like […]

Read More