Debug Stored Procedure SQL 2005 & Visual Studio 22005

[malfster]

Hi all,

I'm trying to debug a SQL Stored Procedure in a SQL 2005 database (beta release 3) using Visual Studio (beta release 2). I can't connect from Visual Studio to the db using the .NET data provider for SQL Server driver, but I can connect when I use the .NET data provider for OLE DB. However when I browse my stored procedures and right click them, I do not get the debug options I expect to see.

I can however browse stored procedures within a SQL 2000 db and do get debug options when I right click.

I have given myself all the admin rights I can think of but still no joy. Anyone got any ideas?

Thanks
Alastair