no its missing the values in the system views in the master database, I have been trying to add these manually but I can not gettin this error Ad hov updates to system catalogs are not allowed. I turned on sp_configure 'Ad Hoc Distributed Queries' but still unable to add. Thanks in advance
GRANTORGRANTEETABLE_CATALOGTABLE_SCHEMATABLE_NAMEPRIVILEGE_TYPEIS_GRANTABLE
dbo public masterdbo spt_valuesSELECT NO
SELECT TOP 1000 [GRANTOR]
,[GRANTEE]
,[TABLE_CATALOG]
,[TABLE_SCHEMA]
,[TABLE_NAME]
,[PRIVILEGE_TYPE]
,[IS_GRANTABLE]
FROM [master].[INFORMATION_SCHEMA].[TABLE_PRIVILEGES]
with out these values in the view we are unbale to select the database properties
gettting error Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server, Error:208)