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

Filter candidate list based on DB owner

GearBahxGearBahx Posts: 6
edited June 4, 2007 8:17AM in SQL Prompt Previous Versions

I'd like to know if there is a way to "filter" the candidate list or the objects being caches so that, for example, only the objects belonging to "dbo" are shown. We have a large database that contains many humdreds of "scratch" tables that belong to users other than dbo. This, in turn, is causing very slow performance with SQL Prompt. If I could filter out these tables, I believe performance would vastly improve.




  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Max,

    I think you may be able to set permissions on your schemas in SQL 2005, and that would filter the list to the objects you have permission to, based on the schema. I don't know what you could do in SQL 2000.

    We can add this as a suggestion for a future version of SQL Prompt.
  • Options

    That could in effect work, but the problem is I am the DBA and have permissions to all objects ( and really need to keep it that way ). I guess I'll have to wait for the next version...

Sign In or Register to comment.