Latest Contributions by BirajaNayak

Also send or copy the content of sde log and setup log file. We can find more information from those files. ... View more

It looks like you are not able to access sqlserver "hassasvr" from this client box using sa user. can you please try to connect to this sqlserver from this Arccatalog using the same parameter as on screen capture 1. Also check the spelling of sql server name. ... View more

Hi Rama, You got all permission right once you followed Asrujit's suggestion. In Arcatalog, you can use filter to get feature class and it's locks. If you can not see, then close Arccatalog and reopen to try again. Sometimes, Arcatalog cache it out and you may not see update information on the same session. If you still have issue, then log a tech support call. Thanks, Biraja ... View more

Is there any hung or orphan processes in sqlserver. Or is there any process is blocked processes.  If it is possible, then restart sqlserver service and try copy again. Otherwise log a case with Esri Support. Thanks, Biraja ... View more

One more to check is whether you saved user name and password in .sde file or database connection file. Thanks, Biraja ... View more

Are you able to create a new feature class or tables in target enterprise geodatabase using Arccatalog. Please check the data creator  Privileges for geodatabases in SQL Server—Help | ArcGIS for Desktop Required privileges: CREATE TABLE CREATE PROCEDURE CREATE VIEW Also check the following for data creator login: Users who create data must have a default schema with the same name as their database user name. For example, for the user name simon, the default schema name must be simon. If it isn't, the user cannot create objects such as feature classes. Thanks, Biraja ... View more

Hi Henry, Have you checked archive option in geodatabase. Here is the web help link: The archive process—ArcGIS Help | ArcGIS for Desktop It helps to keep track of chnages of feature in time. Hope this helps. Thanks, Biraja ... View more

Feature layer in ArcMAP has more info to consider  boundary extend, symbology etc in the copy process. If you do not want specific feature to copy, then better method is to  use Arccatalog and copy file geodatabase/feature dataset/feature class. Just curious to know, why you need to copy feature layer one at a time from ArcMAP. Thanks, Biraja ... View more

In addition to George suggestion, you can use the following syntax to resynch: exec sp_change_users_login 'Auto_fix','gissrvadm', NULL, 'gissrvadm' Thanks, Biraja ... View more

Hi Jane, As you mentioned, you have small data ( I assume it will be around 1 to 2GB  or less), you can use sqlserver express as personal geodatabase to store both spatial and non-spatial data and join. Editing sqlserver non-spatial data is easy and if your colleague knows how to modify data in MS-Access then he will figure out how to do it on sqlserver. For your field analyst, you can make a checkout replica as file geodatabase if required and edit. Thanks, Biraja ... View more

Are you using ArcMAP edit session to edit data. Do you have any third party or custom tool to edit features. Thanks, Biraja ... View more

Hi Jeff, You can submit your suggestion in ideas site as an enhancement request and other user vote for it. Esri development team is very active in ideas site and they consider ideas with more votes. Thanks, Biraja ... View more

Please run the below query and let us know your result: SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_NAME  = 'ST_GEOMETRY' AND REFERENCED_TYPE  = 'TYPE' AND TYPE = 'TABLE'; ... View more