[DUG] MSSQL and Schemas

[Stephen Barker]

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_groups at 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 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
> 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
> 
>