[DUG] MSSQL and Schemas

[Sandeep Chandra]

I have had enough with schema thing, I would like to drop this schema and 
transfer objects for this schema to the default schema. Could anyone please tell 
me how to do this?

Regards

Sandeep



----- Original Message ----
From: Kyley Harris <Kyley at harrissoftware.com>
To: NZ Borland Developers Group - Delphi List <delphi at delphi.org.nz>
Sent: Mon, 12 July, 2010 5:12:42 PM
Subject: Re: [DUG] MSSQL and Schemas

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

_______________________________________________
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