Options

Qualifying Object Names crashes with large amount of objects

kevine323kevine323 Posts: 58
edited October 5, 2011 6:39AM in SQL Prompt Previous Versions
I'm trying to use the "Qualify Object Names" feature of SQL Prompt with a database that has 2200 tables and over 27,000 stored procedures (some encrypted) and screen hangs on "Connecting to <database>". Any ideas?
Kevin Eckart
Database Administrator
USA Truck, Inc
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/
· Share on Twitter

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies for inconvenience caused.

    Qualify Object names option is used to Qualify object names in the current open Query window.

    Can you kindly let me know how big is the query? And what happens if you select your database before using this feature?

    Can you also email me the screenshot where SQL Prompt hangs?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.