Is it possible that "information_schema.schemata" does not allways work
correctly in MSDE Sql-Server.
I have built an Explorer that will find the Servers (MSDE and SQL-Server
2000) and then should list the Databases found.
For the SQL-Server the results are always correct but not for MSDE.
Mostly Databases are missing allthough the results are often diffrent.
Selden are all of them there, mostly my two Database are effected in some
ways.
Different results when called without any changes on the server. Sometimes
even one of the four
basic Databases is missing. Timeout cannot be the problem since the missing
databases are different.
They all show up on Enterprise Manager and MSDE Manager.
On SQL Query Analyzer however I get the same wrong results.
Databases are missing in the TreeView and in the results of
"information_schema.schemata" when run.
Due to the fact that it also happens in QA I am wondering if the is a
general problem that I need not bother
me if it is known.
Mark Johnson, Berlin Germany
mj*****@mj10777.de