I am looking at a report for upgrade compatability on sql server and seeing the following error:
Table sysobjects has changed or does not longer exist after SQL Server 2005. Using it may cause errors. For more details, please see: Line X, Column Y.
We are moving to SQL server 2016 what would I need to replace sysobjects with.
The portion of the stored proc that is generating the above 110 compatibility message looks as follows:
SELECT name FROM sysobjects
Many of the system tables from earlier releases of SQL Server are now implemented as a set of views. These views are known as compatibility views, and they are meant for backward compatibility only. The compatibility views expose the same metadata that was available in SQL Server 2000. However, the compatibility views do not expose any of the metadata related to features that are introduced in SQL Server 2005 and later. Here you can find the list of System Compatibility Views
Besides, if you search in google for sysobject/other "old" system table, the first thing that will be written there is that the table is deprecated, use new_ system_view instead, this way you can find the new one