Latest Contributions by Asrujit_SenGupta

‎07-22-2017

It will depend upon, how you had applied the Domain initially. You cannot remove Domains from fields, which have been assigned under the Subtype tab of the Feature Class properties. Any domain, assigned under the Fields tab...those can be removed using the tool.

‎07-21-2017

The main reason according to me will be 'Performance'....I have seen overall performance degrade a lot because of these over a period of time... Take a look and see if these links help: Geoprocessing history logging in ArcGIS: performance review – Alex Tereshenkov How to Make ESRI Desktop ArcMap Faster · ncss-tech/geo-pit Wiki · GitHub Viewing tool execution history—Help | ArcGIS Desktop

‎07-20-2017

You cannot Restore a single Feature Class from a SQL Server db backup. You will have to restore the complete backup > Connect to it using ArcGIS Desktop > Connect to the Specific version, whose data you need for that fc > Export out the data to a File gdb > Confirm that the output in the File gdb is exactly what you needed > Load that data in the required gdb

‎07-20-2017

Honestly, it makes perfect sense if someone cares to read properly and tries to understand the workflow suggested. Instead of trying to use the unregister command from Command line tools (which are anyway deprecated), he is suggesting an alternate and safer way, to avoid any corruption of the Table. 1. make an export, 2. drop the table (delete through Desktop/ArcObjects/ArcPy) 3. re-import the table (alternatively, CREATE TABLE t_new AS SELECT * FROM t", delete, and RENAME). Any other method will involve unsupported manipulation of the GDB tables. 1. suggesting you to export\create a copy of the concerned table in the same database 2. Delete the existing Table using ArcGIS Desktop\ArcObjects\ArcPy (this removes all dependencies, which was the initial concern) 3. Re-import the copy that you created in Step1 OR Recreate the required table from the copy that you made in Step1 OR Rename the copy that you created in Step1 (whatever suits you)

‎07-18-2017

The SS login would be owner of the database but would NOT have to be sysadmin ? Yes, correct.. How would this scenario work ? Are you suggesting copy/paste ? There are too many data sets to do that. 'use a secure 'sysadmin login' to load the data into the Publication databases from the Edit databases.' I didn't mean manually. From your post above, it seems you have already setup an automatic way to move data from the Edit DBs to the Publisher DBs...so just use a secure sysadmin login to connect to the Publisher DBs and execute the workflow.

‎07-18-2017

No, to change the Data owner in an Enterprise geodatabase, you will have to reload the data connected as required user using ArcGIS Desktop. Trying to change it from the database side risks corrupting the data, as entries are made to different system tables. Why not create and use a single SQL Server Authenticated login as the login for all Data Loading purpose. Make it the owner of the concerned databases and map it to dbo. Or use a secure 'sysadmin login' to load the data into the Publication databases from the Edit databases.

‎07-18-2017

I hope you intend to create a SDE-schema Enterprise geodatabase.....otherwise, you don't need the SDE login credentials to create a DBO-schema Enterprise geodatabase....

‎07-14-2017

No, db_owner and the owner of the database are NOT the same. You can have only one login as the owner of a database. That is why, I had mentioned In your scenario, where you need multiple Windows Authenticated logins to connect and create data as DBO, you will have to grant the 'sysadmin' server role to them. What is the difference between "db_owner" and "the user that owns the database" in SQL Server 2000? - Stack Overflow MS SQL: dbo versus db_owner – GOVARDHAN GUNNALA

‎07-14-2017

A comparison of geodatabase owners in SQL Server—Help | ArcGIS Desktop The dbo user The dbo user and its default schema exist in all databases automatically. Logins can be dbo in a database in one of two ways: By creating or being made owner of a specific database By being a member of the sysadmin fixed-server role In your scenario, where you need multiple Windows Authenticated logins to connect and create data as DBO, you will have to grant the 'sysadmin' server role to them.

‎07-13-2017

No, we cannot. At 10.2.2, they added the functionality of not showing Feature Datasets, however nothing for Relationship Classes yet. FAQ: Can feature datasets be prevented from appearing under Database Connections in ArcCatalog? As far as I can remember, whatever data is present within a Feature Dataset, will be hidden from a user if that user doesn't have privileges on the dataset. However if these objects are outside a feature dataset, it will still be visible to a user who doesn't have privileges on it. There was an Enhancement logged for this a couple of years back: ENH-000085148 - Do not return relationship class for which the connecting user has no access to its related data However, you will have to contact Esri tech Support if you want to know the current status of the Enhancement request. Geodatabase‌ Managing Data‌

‎07-11-2017

No, we don't have that flexibility yet. The archive process—ArcGIS Help | ArcGIS Desktop Working with historical versions—ArcGIS Help | ArcGIS Desktop When working with archived information, it is important to understand that the date and time recorded in the gdb_from_date and the gdb_to_date fields of the archive reflect the date and time a transaction took place—when a feature was added, edited, or removed from the feature class. This date and time is received from the server OS. This affects how you access and query the archive.

‎07-11-2017

Add screenshots of the error, successful SQLPlus connection in cmd and the parameters you are using to connect. https://community.esri.com/groups/geodatabase?sr=search&searchId=a5255caf-bf16-4958-b68e-e8485aceb3b9&searchIndex=0‌ https://community.esri.com/community/gis/managing-data?sr=search&searchId=8829b72d-8bc0-4bc5-aea2-7f4cbded29fe&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=dabf9fba-aa34-4229-bb91-8af8144caa1f&searchIndex=0‌

‎07-03-2017

Being the Data Owner is not enough to disconnect users from a geodatabase. Check this link for more details: Manage connections in SQL Server—Help | ArcGIS Desktop To disconnect users from a geodatabase in Microsoft SQL Server, the geodatabase administrator may need additional privileges. The geodatabase administrator (sde) in an sde-schema geodatabase requires VIEW DEFINITION privileges on the database to see the list of connected users and must be a member of the processadmin fixed server role to disconnect users. If the geodatabase administrator of a dbo-schema geodatabase is the database owner, the geodatabase administrator must be added to the processadmin fixed server role to disconnect users. No additional privileges are required for the geodatabase administrator in a dbo-schema geodatabase if the geodatabase administrator is a member of the sysadmin fixed server role.

‎07-01-2017

https://community.esri.com/community/gis/enterprise-gis/arcgis-for-server?sr=search&searchId=5733f764-37d0-4194-b8d7-177d60600e16&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis/geoevent?sr=search&searchId=4d80a27d-4f6f-4c59-a969-eea0de3f7e5d&searchIndex=0‌ https://community.esri.com/community/gis/managing-data?sr=search&searchId=937912a9-dacd-480b-a188-5b15e87c9677&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=38656824-3442-4cd2-aeca-efc71a198ffd&searchIndex=1‌

‎06-28-2017

Great! Close the thread if your question has been answered by marking the appropriate response as "Mark Correct"

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by Asrujit_SenGupta

Re: How to Remove domain from field for gdb

Re: Why delete geoprocessing history from Geodatabase?

Re: How to restore a feature class from a SQL database backup?

Re: sdetable unregister

Re: Creating data in an ArcSDE geodatabase under a different schema

Re: Creating data in an ArcSDE geodatabase under a different schema

Re: Create a Enterprise database....sde password is lost

Re: Creating data in an ArcSDE geodatabase under a different schema

Re: Creating data in an ArcSDE geodatabase under a different schema

Re: 'Hiding' Relationship Classes in Enterprise GDB

Re: ArcGIS Versioned Archive Dates Not in UTC

Re: Client software failed to load. Be sure the database client software is installed and configured correctly

Re: I am a data owner. When I clicked administrator geodatabase on data connection and tried to disconnect user locks however it stated "insufficient permission". How can I fix it? I need to disconnect users. I also have access to SQL Server Management St

Re: Registered Database vs. Registered Managed Database

Re: Delete Records of Delta Table (A&D)

Re: Unable to Delete Versions

Re: Changing colomn length in egdb

Re: Unable to download the ArcGIS Experience Build...

Re: Creating a View in SQL Server Enterprise Geoda...

Layers with Subtypes not recognized as data in Exp...

Experience Builder Custom Widgets

Esri Certified Individuals