Here's an idea: let the proc get the schema name for you :-), then you don't even have to type it in at all!

create PROC [dbo].[sp_getrecords]

(

@TableName sysname

)

AS

declare @SchemaName sysname

select top (1) @SchemaName = SCHEMA_NAME(schema_id)

from sys.objects

where

name = @TableName and

type in ('u', 'v')

exec('select * from ['+@SchemaName+'].['+@TableName+']')