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

SQL Prompt not working on Read Only database

Hey,

Long time user of SQL prompt, currently working on a mess of a database that I could really use some help with. Unfortunately the database is in read-only mode and this seems to be the reason that SQL prompt is no longer able to make suggestions. Anyone know a workaround?

Many thanks,

Tim
Timothy Jeffreys
0

Comments

1 comment

Sort by
  • Jon_Kirkwood

    Hi @...

     Thank you for reaching out on the Redgate forums regarding your SQL Prompt inquiry.

     

    SQL Prompt should have no issues providing suggestions from a read-only database. 

    My initial reaction is perhaps your user permissions on that database don't meet the requirements:

    • User granted SELECT & VIEW DEFINITION on a database

    List of all permissions required for SQL Prompt functionality available here:

    https://documentation.red-gate.com/sp/getting-started/requirements/sql-server-permissions

     

    Ideally, you would need to check if this is the case and determine if someone is able to temporarily revoke the read-only state to apply the permissions.

     

    If you are unable to change these permissions, then I am not aware of any direct workarounds. 

    You may need to clone the database to a copy you can modify the permissions, and then use it for suggestions in your code.

     

    Jon_Kirkwood
    0

Add comment

Please sign in to leave a comment.