Filter candidate list based on DB owner

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

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.

Thanks,

Max

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • Hi,

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

    Max
Sign In or Register to comment.