Stored Procedure Created not supported in SQL SERVER 2000

Topics: General Discussion Forum, July and December Releases Forum, Service Factory Modeling Edition Forum
May 18, 2007 at 3:32 PM
Edited May 18, 2007 at 4:00 PM
Hi,

I created a project using Guidance Packages/Web Service Software Factory (ASMX).

I added a db connection, and created Business Entities, and stored procedures.

The database, which can get connected to successfully, is SQL Server 2000, but it seems that the stored procedure scripts, which are created, are only supported in SQL Server 2005, not 2000, since it has the following keywords which are not supported in 2000:

  • ERROR_NUMBER
  • ERROR_MESSAGE
  • TRY END

If in the next version you could add an option to create the stored procedures in a way that they are supported in 2000 as well, it would be great.

I am not sure whether the current version has it.

Thanks


Developer
May 18, 2007 at 10:49 PM
Thanks for the feedback and catch. This issue seem to be a good fit for posting it to the Issue Tracker section.