[DUG] MSSQL and Schemas

[Kyley Harris]

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 <Steve at 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_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
>>
>>
> _______________________________________________
> 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
>



-- 
Kyley Harris
Harris Software
+64-21-671-821