All,
there seems to be an issue when using squirrel-sql on windows with SQL
Server 2000.
Steps to reproduce error as follows:
- Connect to a SQL Server 2000 instance
- Click a table in the database explorer
- Click the 'info' pane to view metadata
- The 'remarks' property has a corresponding null value
Having run SQL Profiler, it seems as though the information for this
pane is fed by a call to a stored procedure called
'sp_tables'
This procedure is a Microsoft one and will never return a value as
defined online at:
http://msdn2.microsoft.com/en-us/library/ms186250.aspx
We would like to use Squirrel in our organisation and this error is
causing us problems as there seems to be no other way to view the
metadata for a table.
Any ideas how to quickly correct this?
Thanks
Ben
|