Updating sql server from access
If you are using the \esha instance of SQL Server that is installed with Genesis and Food Processor, you may not have SQL Server Management Studio and will need to use the Knowledge Base article Granting Access with Database Utilities These instructions are for adding a Windows authentication user to the database permissions.
Pushing real-time data into an Arc SDE geodatabase for immediate consumption by end users can be challenging.
However, with the advent of Microsoft's SQL Server 2008 and Esri support for the built-in SQL Server 2008 spatial data types, real-time updating of Arc SDE feature classes in SQL Server 2008 has gotten easier.
By utilizing the SQL Server geometry and geography data types, SQL stored procedures, and triggers, we can essentially bypass the Esri Arc SDE stack and push attribute and spatial updates directly to nonversioned feature class tables.
Simple to complex insertions and updates can be performed through SQL, allowing us to provide (upon map refresh or redraw) instant feature class updates to end users.
Real-time data is becoming more and more prevalent in the world around us and therefore in greater demand within GIS applications.