Hi all. Are you aware of an apparent issue with the Database Browser window? When I set up a connection to Sql Server 2000 and then try to connect to it I receive the following error in the Output window...
-------------------- Connection failed: 'SCHEMA_NAME' is not a recognized function name.
Query: SELECT SCHEMA_NAME(udf.schema_id) AS PROCEDURE_SCHEMA, udf.name AS PROCEDURE_NAME, CASE udf.is_ms_shipped WHEN 0 THEN N'PROCEDURE' WHEN 1 THEN N'SYSTEM PROCEDURE' END AS PROCEDURE_TYPE FROM sys.all_objects AS udf where udf.Type = 'P'ORDER BY PROCEDURE_SCHEMA, PROCEDURE_NAME -------------------
This query is particular to stored procedures and appears to be suited toward SqlServer 2005 (or higher) I'm guessing that the other object type queries are correctly versioned, but this one seems to not be.
Also, I'm a little puzzled that it is trying to retrieved the procedures even when I have both user and system procedures UNchecked in the browser properties form.
Any thoughts on how to rectify this? I need to test this on Sql2000 and would very much like to use the browser rather than fat fingering in the table names in the Query Designer.
Thank you for your query regarding the Sql Server 2000 connection issue.
Also, thank you for pointing out that the query is SqlServer 2005 or higher specific. That will help us narrow down the issue.
Unchecking the user and system procedures, only removes them from the view. The application still retrieves all the metadata it needs at connection time.
We are working to resolve the issue. Please check back with us shortly for a resolution.