Latest Contributions by AsrujitSengupta

Tamara, You cannot upgrade a sde gdb to 10.1, without having Desktop 10.1. To upgrade the gdb to 10.1, you will have to install Desktop 10.1. As far as for compatibility, YES the Desktop 10.0 clients can work with a sde 10.1 gdb. Client and geodatabase compatibility: http://resources.arcgis.com/en/help/main/10.1/index.html#//003n00000008000000 The above link mentions: 1. ArcGIS 10 can open and edit a 10.1 geodatabase. Be aware, though, that the ArcGIS 10 client will not have access to 10.1 functionality and will not be able to edit data, such as network datasets or mosaic datasets, that are using 10.1 functionality. 2. Your ArcGIS 10 clients should be patched to at least service pack 2 if you will be connecting to a 10.1 geodatabase. When you make a connection between releases�??for example, if you connect from ArcGIS for Desktop 10.1 to an ArcSDE 9.3 geodatabase�??the functionality available to you is limited by the lowest release number. In this example, you would not have access to functionality available in 10.1 since the geodatabase is still at the 9.3 release. Similarly, though ArcGIS 10 clients can open, query, edit, and save data in 10.1 geodatabases, they cannot open datasets with 10.1 functionality. For example, you cannot access file geodatabases that were compressed using ArcGIS 10.1, the editor tracking fields in 10.1 feature classes will not be populated when connecting or editing from 10 clients, and you cannot use 10.1 network dataset or mosaic dataset functionality Regards, ... View more

Cole, I don't know if this can be a valid answer to your questions, but you can simply "Copy/Paste" or "Export/Import from XML Workspace Document" the data to maintain the OBJECTIDs if desired... Its only the Import/Export process which changes the OBJECTIDs.... Just might help! Regards, ... View more

Yunkex, I think you can simply perform this task using your ArcCatalog interface. From ArcCatalog, create a folder connection and browse to the folder where your SDC dataset is stored. Right-Click on the SDC Feature Class and use the "Export to Shapefile" option to get the desired Shapefile. ** You didn't provide the version of ArcGIS you are using. The workflow above is suggested for 10.1. NOTE: If converting large amounts of data, it's probably best to use a geodatabase format for space efficiency and better capabilities; shapefiles are useful for interchange among different vendors' spatial data processing products. Regards, ... View more

Ben, Open SQL Server management Studio--> Connect to the Instance-->Expand Databases-->R-Click on the required database-->Properties-->Permissions-->Select the user you want to revoke the permissions from--> Scroll down in the permissions list below and revoke the permissions under the "GRANT" tab here. Mainly, the user shouldn't have: CREATE FUNCTION CREATE PROCEDURE CREATE TABLE CREATE VIEW Hope this helps! Regards, ... View more

Make sure you have the recent database backup before trying anything...:) ... View more

Laura, The Domain ownership can be changed by using the following workaround: 1. Export 'Domains' owned by 'User1' to tables using 'Domain to Table' tool 2. Import/Create 'Domains' from the tables created in step 1 using 'Table to Domain' tool connected as the new owner 3. Remove original 'Domains' owned by 'User1' from the field 4. Assign newly created 'Domains' in step 2 to fields from which they were removed in step 3 5. Delete the 'Domains' owned by 'User1' Finding domain owners using SQL: http://resources.arcgis.com/en/help/main/10.1/index.html#//006z000000ts000000 --SQL Server SELECT items.Name AS "Domain Name", items.Definition.value('(/*/Owner)[1]','nvarchar(max)') AS "Owner" FROM dbo.GDB_ITEMS AS items INNER JOIN dbo.GDB_ITEMTYPES AS itemtypes ON items.Type = itemtypes.UUID WHERE itemtypes.Name IN ('Coded Value Domain', 'Range Domain') There are actually some Ideas submitted for these purposes, which you can have a look at: Domain Management Toolset: http://esri.force.com/ideaView?id=087300000008Hzc&returnUrl=%2Fapex%2FideaList%3Fc%3D09a300000004xET%26category%3DGeodatabase Add Change Domain Owner Tool: http://ideas.arcgis.com/ideaView?id=08730000000c1vc Regards, ... View more

Laura, The number of GDB tables in a 10.1 sde geodatabase has reduced to 6. Have a look at this link for the detailed information on these tables: System tables of a geodatabase in SQL Server http://resources.arcgis.com/en/help/main/10.1/index.html#//002q00000080000000 GDB_ITEMS Items are any object used in the ArcGIS system that can be indexed and searched, including tables, domains, topologies, and networks. The GDB_ITEMS table maintains information about all the items stored in the geodatabase. Hope this helps! Regards, ... View more

Jamal, This is by design. Please have a look at the below link for more details: [ NIM040283 - Using GP tool (create replica) to create replica and set ALL_ROWS for expand feature classes and tables, the attribute table only has its schema replicated.] http://support.esri.com/en/bugs/nimbus/TklNMDQwMjgz You can also have a look at the below post for a good workaround: http://forums.arcgis.com/threads/481...604#post166604 (look at the last post) Hope this helps! Regards, ... View more

Trevor, While looking into the issue, I came across the below link, which provides details about all the Permissions of Fixed Database Roles: http://msdn.microsoft.com/en-us/library/ms189612(v=sql.105).aspx So, it seems that the permissions "CREATE TABLE, CREATE PROCEDURE, CREATE VIEW, CREATE FUNCTION" are granted along with the "db_ddladmin" role. I also came across the below link, which mentions that "Role db_ddladmin not working properly on SQL Server 2008" (I know you mentioned 2008R2)...but still, you might want to check this as the link mentions some issues with 2008 R2 too: http://dba.stackexchange.com/questions/4081/role-db-ddladmin-not-working-properly-on-sql-server-2008 Hope this helps! ... View more

I think you guys might be encountering the following Bug: http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3 [NIM084987 - When upgrading an ArcGIS 10 SP5 geodatabase to ArcGIS 10.1, while connecting with the syntax 'sde:oracle11g:TNSNAME' the upgrade fails with the error 'ERROR: geodatabase schema object install not completed (-522).'] Regards, ... View more

Foram, As Jake suggested, try connecting as the SDE user and then Register as Versioned, because the data is owned by SDE and not a dbo user. You can only perform certain operations as a Data Owner (in this case 'SDE'), even though the 'sa' or other 'dbo' users have all the rights. Regards, ... View more

Tamara. This shouldn't be a Bug. Can you crosscheck with the IDs of the a- & d- tables having edits, that which FCs they are referring to? Check the Table_registry for verifying the ID of the FCs. Do you have any Geometric Network, Topology, etc in your geodatabase? ... View more

Tamara, As the below link mentions: If you decide to register a feature dataset, stand-alone feature class, or table as versioned with the option to move edits to base, right-click it in the Catalog tree, point to Manage, then click Register As Versioned to open the Register As Versioned dialog box. Check Register the selected objects with the option to move edits to base. Checking this option causes edits that have been saved to the DEFAULT version, whether edited directly or merged from other versions, to be saved in the base (business) tables. Edits to other versions remain in the delta tables when you save. http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000rp000000 So basically, the edits done in DEFAULT version will directly go to the base tables. Edits done in other versions will go to the Delta (a- & d-) tables, for your case. Hope this helps! Regards, ... View more