Getting rid of all the "dbo." ?

In SQL Server Management Studio (2005) pretty much everything has
"dbo." in front of it in the treeview.
Is there any way to change the preferences so it won't show the owner
prefix like that?
When you have 200 SPs, it is nice to be able to type "US" on the
keyboard and have it jump to all the "Users_..." stored procedures,
rather than having to use the most to scroll down the list.Right-click Stored Procedures, select Filter and specify the desired filter
settings, like name, schema or creation date.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"cmay" wrote:

> In SQL Server Management Studio (2005) pretty much everything has
> "dbo." in front of it in the treeview.
> Is there any way to change the preferences so it won't show the owner
> prefix like that?
> When you have 200 SPs, it is nice to be able to type "US" on the
> keyboard and have it jump to all the "Users_..." stored procedures,
> rather than having to use the most to scroll down the list.
>|||"cmay" <cmay@.walshgroup.com> wrote in message
news:1149455680.161538.217900@.c74g2000cwc.googlegroups.com...
> In SQL Server Management Studio (2005) pretty much everything has
> "dbo." in front of it in the treeview.
> Is there any way to change the preferences so it won't show the owner
> prefix like that?
> When you have 200 SPs, it is nice to be able to type "US" on the
> keyboard and have it jump to all the "Users_..." stored procedures,
> rather than having to use the most to scroll down the list.
>
If you click on the containing folder, you can use the summary view to do
what you want.|||It looks like that would allow me to filter down the list of SPs, but I
can't remove the "dbo." from the name as they are displayed.
If I wanted to jump to all my "WorkItem_" SPs I could go in and filter
it as you suggest, but it would take a lot longer to do that than to
scroll down to the "W"s in the list.
I am just trying to find a way to use the keyboard shortcuts.
I guess I could type "dbo.Work" and it will do the same, its just
unnecessary in my mind to put DBO before everything and have no way to
alter how they are viewed.
Thanks anyway.
Ben Nevarez wrote:[vbcol=seagreen]
> Right-click Stored Procedures, select Filter and specify the desired filte
r
> settings, like name, schema or creation date.
> Hope this helps,
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "cmay" wrote:
>|||Yea I guess I didn't think of that. I could do that.
A lot of times the summary window isn't open when I want to browse to a
new object, but I guess F7 will bring it up.
Michael D'Angelo wrote:
> "cmay" <cmay@.walshgroup.com> wrote in message
> news:1149455680.161538.217900@.c74g2000cwc.googlegroups.com...
> If you click on the containing folder, you can use the summary view to do
> what you want.