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

  • Thread starter Thread starter Andrew Gaskell
  • Start date Start date
A

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
 
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.
 
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. ;-)
Click to expand...
You'll need another tool for that. I keep the SQL client >tools on my
machine just in case.
Click to expand...
 
Back
Top