Forums » General Discussion

Thread: Object Explorer doesn't show all stored procedures

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List Point your RSS reader here for a feed of the latest messages in all forums

Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
jaybonk_218

Posts: 1
Registered: 6/14/10
Object Explorer doesn't show all stored procedures
Posted: Jun 14, 2010 9:54 AM 		 
  Click to reply to this thread Reply

I created a procedure and when I went to view it in the object explorer tab for procedures, it wasn't visible in the list.  This is the only procedure in this particular database, but if I do a select from information_schema.routines it shows up, along with the list of procedures in other databases.

I've dropped and created the procedure a number of times, each time it says executed successfully, and shows up in information_schema, just not in the object explorer.

Pages: 1
Back to Thread List Back to Thread List
Threads: [ Previous | Next ]
Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums