Creating ESRI_OID in SQL Server

Question

I have read-only access to a non-spatial SQL server. The table I want to use doesn't have object IDs, needed for queries, while another table shows the ESRI_OID field ("shows" as it really isn't in the table). How do I get the ESRI_OID field to show in the table? Also, I'm unable to Register with Geodatabase. If I were to have a new OID field added to the SQL table, what do I tell the database administrator, create a random number field?

Thanks,

Scott

bixb0012 · Accepted Answer

There are a couple tools, or more, in the Layers and Table Views toolset that should work for you:  Make Query Table, Make Query Layer.  These tools will create virtual key fields, i.e., ESRI_OID, for you.