I need to tap into the expertise on this forum…
Windows Server 2008
MSSQL Server 2008 R2 (This is where all my data is)
(Writes to computer 1)
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?