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

Filter candidate list based on DB owner

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
GearBahx
0

Comments

2 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • GearBahx
    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
    GearBahx
    0

Add comment

Please sign in to leave a comment.