Has the Database Structure Changed?

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

[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';

[igavemybest]

Yes, the DBA has changed something so the user has its own schema for some reason. Thx