Page 1 of 1
Has the Database Structure Changed?
Posted: Tue Apr 06, 2010 12:06 am
by igavemybest
Why do the database tables, when I do a new install, have my store/user name as a prefix to all the tables instead of dbo? I have some custom importers that use it, is there any way to change this?
Re: Has the Database Structure Changed?
Posted: Tue Apr 06, 2010 7:26 am
by jmestep
It must be something to do with your SQL user permissions.Here is how you change it:
http://www.mssqltips.com/tip.asp?tip=1396
Change Object Owner/Schema
To change the ownership of objects you can use the ALTER SCHEMA command for SQL 2005 or the sp_changeobjectowner for SQL 2000.
Example: change the schema for table Test from the dbo schema to schema TestSchema
--SQL 2005
ALTER SCHEMA TestSchema TRANSFER dbo.Test
--SQL 2000
sp_changeobjectowner 'Test', 'TestSchema';
Re: Has the Database Structure Changed?
Posted: Tue Apr 06, 2010 2:48 pm
by igavemybest
Yes, the DBA has changed something so the user has its own schema for some reason. Thx
