[fdo-trac] #76: ODBC: SQL Server 2005 system views appearing in schema description

[FDO]

#76: ODBC: SQL Server 2005 system views appearing in schema description
-----------------------------+----------------------------------------------
   Reporter:  anonymous      |       Owner:  gregboone
       Type:  defect         |      Status:  new      
   Priority:  major          |   Milestone:  3.3.0    
  Component:  ODBC Provider  |     Version:  3.2.0    
   Severity:  2              |    Keywords:           
External_id:                 |  
-----------------------------+----------------------------------------------
 A recent change allowed views can be seen from a DescribeSchema command in
 the ODBC Provider.  In most data sources, this is fine.  However, with SQL
 Server 2005, dozens of system views are new visible.  These add clutter to
 the visible results and can be a performance problem.  MapGuide has even
 been observed to time out on a DescribeSchema.

 The problem does not occur with SQL Server 2000 because that version does
 not offer system schemas in the results of the ODBC "SQLTables" function.
 With SQL Server 2005, this function returns results including the "sys"
 and "INFORMATION_SCHEMA" schemas, which contain the offending views.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/76>
FDO <http://fdo.osgeo.org/>
Feature Data Objects