Hi Sandeep, I don't use MSSQL, but I did have to do a job with it a few years back and got caught out with the customer's db being set to case sensitive which affected all objects - just a thought,
Steve > -----Original Message----- > From: Sandeep Chandra [mailto:[email protected]] > Sent: Sunday, 11 July 2010 12:28 a.m. > To: NZ Borland Developers Group - Delphi List > Subject: [DUG] MSSQL and Schemas > > 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 > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.830 / Virus Database: 271.1.1/2939 - Release > Date: 07/10/10 18:36:00 > > _______________________________________________ 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
