# MSSQL Schema owner issues **URL:** \ **Category:** Archived Topics\ **Created:** [March 4, 2011, 11:23pm UTC](https://forum.inductiveautomation.com/t/mssql-schema-owner-issues/2729 "2011-03-04T23:23:35Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![TimE](https://avatars.discourse-cdn.com/v4/letter/t/ee59a6/32.png) [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Post date:** [March 4, 2011, 11:23pm UTC](https://forum.inductiveautomation.com/t/mssql-schema-owner-issues/2729/1 "2011-03-04T23:23:35Z")
I need to tap into the expertise on this forum… Computer 1 Windows Server 2008 MSSQL Server 2008 R2 (This is where all my data is) Ignition 7.2.3 Computer 2 Windows XP FactorySQL (Writes to computer 1) Computer 3 Windows XP (My desktop) MS SQL Server Management Studio Database name is PMIServer If a table is created from Computer 1 it shows up in MSSQL as: PMIServer.dbo.tablename If a table is created from Computer 2 it shows up in MSSQL as: PMIServer.BPIHQ\tim.tablename If a table is created from Computer 3 it shows up in MSSQL as: PMIServer.tim.tablename Within the Ignition designer I can access all tables created from computer 1 by using the table name. If the tables were created by the other two computers I have to specify the owner in my query. How can I create tables from each of these computers and have the owner set as ‘dbo’ so I don’t have to put my name in the query? ---
**Author:** ![tailfire](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Post date:** [March 28, 2013, 2:31am UTC](https://forum.inductiveautomation.com/t/mssql-schema-owner-issues/2729/2 "2013-03-28T02:31:25Z")
If it was anything like the issue I ran into, you might check the advanced properties. Check the box for Include Schema in Table Name ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/574212dadcf6b875a67dca616bd9277f91071e9f.png)