Viewing SQL Server system procedures?

  • Thread starter Thread starter Dave Veeneman
  • Start date Start date
D

Dave Veeneman

Does MSDE include SQL Server's system procedures? If so, can I view/execute
them from the Server Explorer in VS.Net? If so, how? Thanks
 
Hi Mary,

No, it doesn't by default.
You will have to go to Tools/Options, Database Tools/Server Explorer and
check "Show system objects".
Optionally, do a refresh in Server Explorer
 
Thanks for the amplification. However, you still won't see them unless
you also create a connection to the master database because that's
where the system and extended stored procedures happen to live...

-- Mary
MCW Technologies
http://www.mcwtech.com
 
Back
Top