topic Re: Records Shown in ArcCatalog/ArcMap but not in SQL Server 2008 in Data Management Questions

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

FaisalBukhari — Sun, 15 Jan 2012 06:06:33 GMT

I am Using SDE 10 and SQL Server 2008 R2.

we are using SDE default version for adding,editing and deleting etc.

I have add some new records into my existing SDE featrure class by using ArcEditor and using SDE.default version by code , the process is running well without error and the added reocords was shown 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 compress the SDE database too but no success

Thanks in advance

.

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

ModyBuchbinder — Sun, 15 Jan 2012 06:46:40 GMT

Hi Faisal

If you are working in version environment the records are not added to the base table until you compress you geodatabase.
Even then if anybody is looking on the layers the records from the delta tables (A & D) might not be written into base.
You can check the �??move to base�?� checkbox when you register the layer as version or work without versioning at all.

Have Fun
Mody

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

FaisalBukhari — Sun, 15 Jan 2012 08:26:51 GMT

Hi Faisal

If you are working in version environment the records are not added to the base table until you compress you geodatabase.
Even then if anybody is looking on the layers the records from the delta tables (A & D) might not be written into base.
You can check the �??move to base�?� checkbox when you register the layer as version or work without versioning at all.

Have Fun
Mody

Thanks dear moody i already compress geodatabase but no success
my layers is already version "SDE.default" how can i check the �??move to base�?� checkbox is checked or not

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

ModyBuchbinder — Sun, 15 Jan 2012 08:41:48 GMT

When you open feature class properties in general tab it is written in the version group on the bottom of the page.

Mody

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

FaisalBukhari — Sun, 15 Jan 2012 09:00:33 GMT

When you open feature class properties in general tab it is written in the version group on the bottom of the page.

Mody

Thanks

that i know but my layer is already versioned but my ? again
where i can find whether i check the �??move to base�?� checkbox is checked or not