Using SQL 2000 SP4. SQL Prompt 2.0.0.26

Have EM and QA open. SQLPrompt running in background.
Go into EM, create a new SPROC in the database that QA has an open connection to.
Switch to QA.
Type 'exec '
Intellisense box pops up, I type in 'dbo.SYS_'
Selection box filters down to the SYS_ sprocs, but the new one isn't listed.

I tried closing EM, QA and it still doesn't populate.
dsaxman
0

Comments

2 comments

  • dsaxman
    Tried it with a second SPROC and it still doesn't refresh the list. How often is the metadata refreshed?
    dsaxman
    0
  • Neil Davidson
    Steve,

    You can refresh the metadata by going to the options screen and clicking on 'Clear cache'.
    Neil Davidson
    0

Add comment

Please sign in to leave a comment.