Thank you for the two responses. It looks like we have a problem with our fourth-generation tool, and that team is going to investigate. I was able to...

Thanks. I will use srvid and isremote to retrieve the local server.

So will the following select give me the 'local server':

select srvname

from master.dbo.sysservers

where srvproduct = 'SQL Server'

and srvname = datasource

and srvid = 0

and isremote = 0

Can I remove some of...

That's not enough when there are linked servers (or remote servers - not sure what the difference is, since we create linked server (sp_addlinkedserver) between two databases on the same...

Why does the status column for an IDENTITY column have a value of 128?

Is there a column in syscolumns or information_schema.columns that can tell us what columns are IDENTITY columns?

That link is very helpful. Is there a similar link that helps create a linked server for SQL Server?

Also, I successfully created a linked server for to an Oracle...

select * from admin.admin.cdba.dm2_user_tables

admin = linked server name

admin = database name

cdba = schema owner