How to view MS SQL Server 2000 objects in MS SQL SMS 2008 R2 Express similarly to viewing them in QA?

Question

SQL

Unfortunately, SMS 2008 R2 Express refuses to display SQL 2000 database objects , citing lack of rights to sysusers .
The administrator is reluctant to grant rights to select .
Is it possible to add functionality to the SMS 2008 environment to work with the SQL 2000 database in Object Explorer , similar to the standard Query Analyzer bundled with the 2000 version.
I work under Windows 7 , which already leads to problems during the QA installation itself (now it is under a virtual machine along with VB6). But, the main reason for this issue is that it is simply more convenient in the new environment. A nice bonus would be the appearance of auto substitution.
I put a trial version of the program from Red Gate and everything worked fine, so it was quite feasible, but I did not find free software solutions. I made an application to the management for the purchase of the product, but this is only for the next year and it is not a fact that they will approve it.
I will be grateful for the answers. Thank you!

Answer 1

Unfortunately, I don’t know the full solution to the problem, but I want to warn you:
In any case, auto-substitution will not work on a bunch of MS SQL Server 2008 R2 client and MS SQL Server 2000 server. This requires 2008 and the client and server.

Answer 2

Solution : change the database administrator ;)
Actually, I don't understand why THAT admin resisted access to the required fields so much. We don't need all sysusers ! Now everything works.
And, yes, auto-substitution and other intelligence goodies do not work as expected.