Ok, here is my issue. I have a few different Schemas that have some common tables in each. I want to use a stored procedure to Select items from these tables, however, I don't want to have to create multiple stored procedures for each schema. Is it possible to create the procedure under the dbo schema and have it execute against the users default schema? The strange thing is that I have a couple SP doing inserts by this method and they work fine, however when I try to execute a Select Statment, it seems to run against the dbo schema rather than the users default schema. I hope I have explained myself enough here, and thanks for any help.

Edit: I am using SQL Server 2005.