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: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [email protected] with Subject:
unsubscribe
