[DUG] MSSQL and Schemas

[Peter Ingham]

On 11/07/2010 12:28 a.m., Sandeep Chandra wrote:
> Hi
>
> I have got a MSSQL(2005)  database that has objects in a schema. Things work
> fine on development machine but when I try to put the database on another
> machine I am not able to run the stored procedures belonging to the schema.

You may have an issue with schema owners here.

If you use a tool like SQL Management Console, you'll see the full names 
of tables, stored procs etc listed as owner.schema.tablename

ISTR that users can have default owners assigned, & connections can 
define default schema.

The usual default owner is "dbo"

Regards