How database users see their objects in sql server I have a large SQL Server 2008 database that has many tables, stored procedures, and functions. This database also has several users. 

How can I make it so that each user, after connecting to the database via Management Studio, can only see his/her related objects in the object browser BUT can execute functions, stored procedures and select tables owned by other users?
Sounds like you need to employ some database schemas to separate out user objects:

http://msdn.microsoft.com/en-us/library/ms190387.aspx

A database schema is nothing more than a collection of objects within a database.  DBO and SYS are common built-in schemas in SQL Server.  You can create a schema that houses a user's objects (tables, functions, stored procs . . .) and assign a level of security to that schema (owner, reader . . . ).  These help especially in terms of object-level administration.