Filter candidate list based on DB owner
GearBahx
Posts: 6
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
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
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.
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