SQL Server error 195 when expanding any DB in Management Studio

Question

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

Answer 1

I realize that these DBs sit on an old version of SQL Server. Could this be the problem?

Correct. SQL Server 2000 has been out of support for many years so using newer versions of SSMS against unsupported database may experience errors like this and functionality will be limited.