Database objects are not listing

• 
  Same problem
  
  1) SQL Prompt works fine in Visual Studio 2005 for both SQL Server 2000 and SQL Server 2005
  
  2) SQL Prompt works fine in Visual Studio .NET 2003 for both SQL Server 2000 and SQL Server 2005
  
  3) SQL Prompt works fine in SSMS for SQL Server 2005 only. For SQL Server 2000 it works in master database only.
  
  4) SQL Prompt doesn't work in Enterprise Manager.
  
  5) SQL Prompt works fine in QA for SQL Server 2005 only. For SQL Server 2000 it works in master database only.

  nICE May 24, 2006 13:05

  - 0 +
• 
  I had this same problem trying to use sql prompt on sql server 2000 with 6.5 compatible tables. Unfortunatly the app that I support uses that compatibility mode.

  gottfoo May 25, 2006 12:06

  - 0 +
• 
  Is this getting any attention? I am also experiencing this problem with 6.5 compatability in Query Analyzer.

  rchern May 31, 2006 13:00

  - 0 +
• 
  SQL Prompt won't work in 6.5 compatibility mode.

  Neil Davidson May 31, 2006 13:21

  - 0 +
• 
  Hi there,
  
  
  Thanks for reporting this. I'm sorry to say that this isn't something we're going to be able to fix in SQL Prompt version 3 since we'll be using some of our own pre-existing libraries that don't support 6.5 compatibility mode. It may or may not work in 70 compatibility mode, but we also do not officially support this. I apologise as this obviously doesn't help you at all, but it's down to some differences in the way the meta-data is stored and represented in SQL Server 6.5 and 7.0 that we don't support the corresponding compatibility modes under later versions of SQL Server.
  
  
  Kind regards,

  Bart Read June 02, 2006 05:29

  - 0 +

Add comment

Please sign in to leave a comment.