When I upgarded to Toad for SQL Server 5.0, Code Completion stopped working.
WORKAROUND 1:
1. Go to 'Tools | Options'
2. Select 'Editor | Code Completion'
3. Make sure 'Auto list member' is checked on the right-hand-side
WORKAROUND 2:
If the option is checked try the following.
1. Close out of Toad
2. Go to 'C:\Documents and Settings\<user>\Application Data\Quest Software'
3. Rename the existing 'Toad for SQL Server 5.0' to 'Toad for SQL Server 5.0_OLD'
4. Launch Toad again
5. When prompted to migrate settings select cancel
