[DUG] MSSQL and Schemas

[Neven MacEwan]

  does this help

http://weblogs.asp.net/steveschofield/archive/2005/12/31/change-schema-name-on-tables-and-stored-procedures-in-sql-server-2005.aspx

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