Problem with SQL Profiler and Sql Prompt

grothag

I am trying to run trace on a database, but there are so many queries from Sql Prompt that I can't use trace at all (repeating same queries all the time, 3-5 queries per second). Why is Sql Prompt querying database so much ? How can I turn that off ? Turning off management studio is not an option.

chriskelly

SQL Prompt is refreshing the local cache of information so that the Code Completion and Expand Wildcard features can give you the most accurate results.

The simple way to turn this off is by disabling SQL Prompt. Simple navigate to the SQL Prompt menu and select "Disable Code Suggestions".

chriskelly

Additionally, there is a SQL Prompt labs feature which allows you to disable the refresh. This means that the various functionality remains enabled, but that you have to manually refresh the local cache.

http://sqlprompt.posterous.com/auto-ref ... ions-72662