MSSQL Schema owner issues

Archived Topics
1

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?

2

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