How can we help you today? How can we help you today?

How to temporary disable SQL Prompt?

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.
psg1234
0

Comments

4 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • psg1234
    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?
    psg1234
    0
  • Brian Donahue
    I don't think so - it's only going to do select statements on the information schema tables of the database.
    Brian Donahue
    0
  • Victoria
    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
    0

Add comment

Please sign in to leave a comment.