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<ky...@harrissoftware.com> > To: NZ Borland Developers Group - Delphi List<delphi@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<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 >> > > _______________________________________________ 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
