Where did the Stored Procedure pane go?

[Vayse]

Hi
Using my Office 2000 ADP on a newer PC, which has Office XP. But now all the
stored procedure pane is gone, and the stored procedures are in the Query
pane. Hmm, also realised that its now a View pane anymore.
This isn't too bad, except I don't to see the system stored procedures in
there. For example, dt_addtosourcecontrol. How do I hide such Sps? They used
not appear in Office 2000.
Thanks
Vayse

 

[CyberDwarf]

Try Tools=>Options=>View uncheck "System objects"

HTH

Steve

 

[Vayse]

No, had tried that already and it doesn't help. Actually tried unticking and
ticking againm just in case, but no luck.

 

[Norman Yuan]

It should work.

If you tick and untick the said checkbox, and watch the Table Pane, you
would see system tables show or hide. You do not see changes in Query Pane,
it is because there isn't system objects for that pane in the database you
currently connected. For example, you mentioned dt_addtosourcecontrol SP in
OP, that SP is in Master database, you won't see it when your ADP is
connected to other DB.

At least, that checkbox works on mine ADP.

 

[Vayse]

Yep, its a bit strange. I had the ADP on a different machine, where the SQL
server also was. No problems there, though I see those SPs were there.

I switched to a Office 2003 PC, copied across the ADP and created a new SQL
server db to which I restored a backup.

On the new PC the Sps are again in the SQL db. But I can't not see them.
On the old Office 2000 PC, switching the View System on/off does work as
expected.

Btw, is there anyway of moving all the SPs to their own pane? Like in the
2000 version.