Make system tables accessible
If there is a way to access the system tables, I've missed it.
Would be a useful feature though.
-
I can fix that particular error by changing sys to dbo, but then the problem will be querying master.sys.all_parameters. I might just disable schema querying for SQL 2000.
-
randy_astle commented
FYI:
It's working on SQL Server 2008 but consistently failing on SQL Server 2000. (Which is probably to be expected since access to the system data is done differently in those databases.)
And, there is probably no real need to provide backward compatibility with SQL Server 2000. -
randy_astle commented
FYI:
The first database I tried enabling this feature on (a SQL Server 2000 database) failed to connect with this error:"(Error: Invalid object name 'master.sys.sysobjects'.)"