On 11/07/2010 12:28 a.m., Sandeep Chandra wrote: > 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.
You may have an issue with schema owners here. If you use a tool like SQL Management Console, you'll see the full names of tables, stored procs etc listed as owner.schema.tablename ISTR that users can have default owners assigned, & connections can define default schema. The usual default owner is "dbo" Regards _______________________________________________ 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
