Sean Lange (8/29/2013)

---

ScottPletcher (8/29/2013)

---

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+']')

That works fine until you have a table with the same name in more than 1 schema and you want "the other one". 🙂