Due to an unfortunate incident, an SQL Update which was in progress got interrupted, and as a result, one of my views in my master database is a bit unhappy. When I start my SQL Server up from the command line I get this error:
Error: 4502, Severity: 16, State: 1.
View or function 'sys.dm_os_sys_info' has more column names specified than columns defined.
I know there is a system stored procedure known as sp_refreshview, but when I run it like this:
EXECUTE sp_refreshview 'sys.dm_os_sys_info'
I get the error:
Msg 15165, Level 16, State 1, Procedure sp_refreshsqlmodule_internal, Line 55
Could not find object 'sys.dm_os_sys_info' or you do not have permission.
I am presently running my SQL Server using the T902 switch, so that the script "sqlagent100_msdb_upgrade.
sql" does not run and prevent the database from coming online. I need to fix the abovementioned error prior to re-running this script.
Can anybody suggest a fix that I can apply to overcome the error