[DUG] MSSQL and Schemas

[Neven MacEwan]

  Sandeep

It sounds  the default schema is not correct for the login you are using

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.
>
> 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
>
>
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
>
>