How to temporary disable SQL Prompt?

psg1234psg1234 Posts: 3
edited June 5, 2013 7:00AM in SQL Prompt Previous Versions
Hi!

Is there any way to temporary disable SQL Prompt?

In some cases I don't want to allow SQL Prompt to retrieve DB schema information and so on.
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    You can only disable SQL Prompt to stop it from suggesting completely. In version 4 and lower, you could exclude certain databases, but the reasoning behind that was performance-related. Since version 5 increased the performance and decreased the memory usage, it wasn't so important to exclude the databases any more.
    · Share on Twitter
  • psg1234psg1234 Posts: 3
    Thank you, Brian!

    In this case I have additional questions :)

    May SQL Prompt affects to SQL Server performance on high-loaded production DB? For example, because of schema locks or something like this?
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    I don't think so - it's only going to do select statements on the information schema tables of the database.
    · Share on Twitter
  • VictoriaVictoria Posts: 1
    I also have this question. I am using a local instance of SQL 2012 to connect to a SQL 2000 instance at a remote location using VPN. Almost every query I run gives me an error. I would like to rule out SQL Prompt as the cause of the errors, so I would like to be able to temporarily disable it. Is there any way to do this?
    -Victoria
    · Share on Twitter
Sign In or Register to comment.