No System stored procedures in MSDE install

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew Gaskell (agaskelluk_at_yahoo.com)
Date: 07/15/04 

Date: 15 Jul 2004 14:30:54 -0700

Hi all
I installed MSDE on my Win2K machine. I then ran the SQL scripts to
create PUBS and NWIND. These created ok and I can connect to them and
navigate the tables using the .NET IDE. However when I try to debug a
stored procedure in NWIND I get the errror:

"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
administrator"

I then looked in the System Stored Procedures via the .NET IDE and I
couldn't see any system stored procedures at all! Are these not
installed by default? Or perhaps my installation is corrupt?

Please help!

Thanks
Andrew

Relevant Pages

  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 Cluster install Error
    ... Source File Name: datastore\cachedpropertycollection.cpp ... then the components installed successfully until "SQL server ... Installation of package: "patchRS2000" failed due to a precondition. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS 2003 Windows Update Question
    ... In lieu of fixing Microsoft, though, a CD-R copy of the installation ... media ain't a bad idea. ... the client has SQL 2000 installed but no media for it. ... and install SBS 2003 Premium with SQL 2000. ...
    (microsoft.public.windows.server.sbs)
  • Re: error while installing a new named instance
    ... SQL has issues with cluster installs when you have a login open on any of the remote nodes. ... And yet another is that teh remote node may not be able to "see" the installation source. ... Error Code: 0x80070002 ... Bootstrap\LOG\Files\SQLSetup0009_CLSNODE1_.NET Framework 2.0.log" to cab file ...
    (microsoft.public.sqlserver.clustering)