SQL 2005 error retrieving stored params list

Riccardo · Post by **Riccardo** » Wed 13 Jul 2005 09:25

Looking at SQL Server profiler output, in order to get the stored procedure parameter list, you reference a table "master.dbo.spt_provider_types" that is no more present in the latest pre-release of SQL Server 2005 (June CTP).
Yesterday I was in Microsoft Italia and they confirmed that the above table is removed, since it was an undocumented feature.
We tried to work with database in compatibility mode 80 but it did not work because you reference a master table.

Please, let me know if you need more detail to reproduce the problem.

Thanks.

Ikar · Post by **Ikar** » Fri 15 Jul 2005 06:22

Thank you for information. We are working on SQL 2005 support now.

Ikar · Post by **Ikar** » Fri 15 Jul 2005 08:00

> What do you mean? MySQL Server 5 ist NOT running. I'm just trying to use the
> embedded server.

EmbServer acts the same as standard - writes file with error messages.
Usually this file is placed in subfolder data and has err extention.