Hi all, I have Management Studio v18.11.1 with SQL Server backend version:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Whenever I try expanding any of the databases listed in the explorer I get the following message:
TITLE: Microsoft SQL Server Management Studio
'HAS_PERMS_BY_NAME' is not a recognized function name. (Microsoft SQL Server, Error: 195)
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-195-database-engine-error
I tried the link, but got a 404. Searched for this error and found lots of fixes, but all involve specifying the owner of the function. In my case, I am just expanding the DB, not calling any function. What can be causing this?
I realize that these DBs sit on an old version of SQL Server. Could this be the problem?
Thank you for your time and assistance. Saga