What are the challenges you face when working across database platforms? Take the survey

enable\disable SQL prompt based on server?

JCaesarRDJCaesarRD Posts: 2
edited April 10, 2007 2:03PM in SQL Prompt Previous Versions
Is it possible to enable or disable SQL Prompt based on the server connection being made ?

Due to the extra resources being used, a request has been made that our developers only connect to production databases with the product off or uninstalled. For development and test servers it is not an issue.



  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    Thank you for your post into the forum.

    There is an option in SQL Prompt that you can set so that SQL Prompt ignores Servers and databases.

    Click on SQL Prompt in the SSMS / Query Analyzer toolbar. In the menu that appears select options. Next select the Connections Tab.

    In the bottom half of the window, you have the ability to configure Servers and Databases to be ignored by clicking on the 'New' button. You can set the option to Ignore 'all databases on server' or a 'Specific database'.

    Hopefully this is the option you are looking for.

    Eddie Davis
    Technical Support Engineer
    Red Gate Software Ltd
    E-Mail: support@red-gate.com
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.