topic Records Shown in ArcCatalog/ArcMap but not in SQL Server 2005 in Data Management Questions

Records Shown in ArcCatalog/ArcMap but not in SQL Server 2005

AryaWardhana — Wed, 19 Jan 2011 00:06:48 GMT

Dear All,

First
I`m Using SDE 9.3 and SQL Server 2005.

I have add Records into my existing SDE featrure class using ordinary load from arccatalog, the process is running well without error.
and the added reocords was shown beatifully in arcmap and arccatalog.

But, when i access the SDE feature class table using SQL server and list the records, the records what i just add, wasnt shown at all. please tell me what a hell happen to my feature class.

i have browse to all the webiste and couple said that i have problem with my versioning, but as far as i know, didnt set my versioning at all, (i not sure 100% i have set or not my versioning, because i`m new using this sde).

Please help me.

Re: Records Shown in ArcCatalog/ArcMap but not in SQL Server 2005

CherylCleghorn — Wed, 19 Jan 2011 14:30:06 GMT

Arya

I suspect that the feature class (FC) is registered as versioned. So let's check to see if your feature class is registered as versioned:

In ArcCatalog, right click on the FC and select properties

If the FC is registered as versioned then the edits are managed in user versioning (delta) tables which the native database does not have direct access to when querying the business (or base) table with SQL.

The following link provides information on registering data as versioned:
Registering data as versioned

The next link defines the delta (adds and deletes) and base tables:
Essential versioning vocabulary

Hope this helps

Regards
Cheryl