[DUG] MSSQL and Schemas

[Sandeep Chandra]

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.

On Development machine I have a stored procedure MySchema.MyStorProc and it is 
running fine without me adding schema name to exec command (exec MyStorProc). 
If I run the same command on another machine I get error saying "Could not find 
stored procedure MyStorProc" but if I exec it like "exec MySchema.MyStorProc" 
then it runs fine.

I don't know much about schema's other than that they are like namespaces.

Not sure what I should do to resolve this issue as I don't want to change the 
source code to include the schema name in front of all the stored procedure 
calls, any help would be highly appreciated.

Regards

Sandeep