SQL Server error 195 when expanding any DB in Management Studio

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

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.
12,667 questions
0 comments
Accepted answer
  1. Dan Guzman 9,206 Reputation points
    2022-09-08T16:34:51.687+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest