Unable to view system stored procedures from .NET IDE and unable to debug SQL

[Andrew Gaskell]

Hi All
I installed MSDE on my Win2K machine. I can see the system stored
procedures just fine from a remote machine's SQL enterprise manager,
but when I use the .NET IDE, although I can connect to the local MSDE
databases, I can't see any system stored procedures in master. When I
attempt to debug any SQL, I get the error message:

cannot debug stored procedures because the SQL Server database is not
set up correctly or user does not have permission to execute
master.sp_sdidebug. Run SQL server setup or contact database
adminstrator.

....which almost certainly has something to do with me not seeing any
system stored procedures. I am a member of the local administrators
group on the machine.

Please help!

Thanks
Andrew

 

[Keith]

The IDE does not allow you to view or edit the system stored procedures.
Apparently, we might mess something up that way. ;-)

You'll need another tool for that. I keep the SQL client tools on my
machine just in case.

 

[Andrew Gaskell]

Ah right, as easy as that! I was worried there was something wrong with
my MSDE setup.

But what is the reason for the debug problem I mentioned below? When I
try to step into a stored procedure in the Northwind database, I get the
error message:

"cannot debug stored procedures because the SQL Server database is not
set up correctly or user does not have permission to execute
master.sp_sdidebug. Run SQL server setup or contact database
adminstrator."

Thanks
Andrew

The IDE does not allow you to view or edit the system >stored procedures.
Apparently, we might mess something up that way. ;-)

You'll need another tool for that. I keep the SQL client >tools on my
machine just in case.