SQL Server error 195 when expanding any DB in Management Studio

asked 2022-09-08T15:59:49.923+00:00
Saga 326 Reputation points

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,471 questions
No comments
{count} votes

Accepted answer
  1. answered 2022-09-08T16:34:51.687+00:00
    Dan Guzman 6,926 Reputation points

    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.


0 additional answers

Sort by: Most helpful