Each user on the database can have a default database they log into.. on each database you can also set the default Schema that its used by the login when accessing the database..
by default its dbo.. when its dbo, you must explicitly prefix any other schema by name.. there is a routine you can call to change the default schema for each user on the database. On Mon, Jul 12, 2010 at 4:52 PM, Stephen Barker <st...@webdata.co.nz> wrote: > 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:sandeep_gro...@yahoo.com] >> 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: 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 >> 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: 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 > -- Kyley Harris Harris Software +64-21-671-821 _______________________________________________ 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
