Auto-complete in the Editor doesn't show System Object stored procedures (from the users DBO and SYS) in the master database:
1. Connect to the master database.
2. Open the Editor.
3. Type 'exec', then hit Ctrl-Period. The names of schemas, databases, and extended stored procedures will appear, but not the regular stored procedures in the master database, such as 'sp_help' etc.
Or alternatively type 'xp' and hit Ctrl-Period, and the extended procedures will be shown. However, typing 'sp' and hitting Ctrl-period will not display anything.
Please disable:
Tools | Options | Editor | Code completion | Statement completion | 'Exclude System Objects' - then the objects for the DBO user should be shown.
However, this option doesn't work on objects that belong to the user SYS.
STATUS:
Waiting for a fix to be released in a future version of Toad for SQL Server.
