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