question

Saga-3468 avatar image
0 Votes"
Saga-3468 asked Saga-3468 commented

SQL Server error 195 when expanding any DB in Management Studio

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://docs.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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DanGuzman avatar image
1 Vote"
DanGuzman answered Saga-3468 commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks! I will see if I can get the server updated. Saga

0 Votes 0 ·