FYI
/Sik
FYI
/Sik
Quote
During the Implementing Enterprise Applications with the Geodatabase presentation at the 2009 ESRI Developer Summit a couple weeks ago, we talked about a handy tool that can be added to ArcMap to send SQL to the connected database. This tool uses the IWorkspace.ExecuteSQL method and it can be very useful in starting and stopping a DBMS trace directly from ArcMap when profiling an operation.
The tool can be downloaded from the ESRI ArcGIS Resource Center for developers in the ArcGIS Desktop .NET Code Gallery. Click here to go directly to the tool.
ExecuteSQL Command for ArcMap
It is very useful in starting DBMS tracing from ArcMap.
Usage:
-Add data to ArcMap
-Select a feature layer
-Click the command button
-Enter sql to execute
-Click ok
Example SQL to start a trace:
ORACLE:
alter session set events '10046 trace name context forever, level 12'
SQLServer:
master..sp_trace_setstatus 1
Informix:
set explain onAuthor FoJo Date Submitted 03-27-2009 Date Last Upated 03-27-2009 Language C# Product/Version ArcGIS Desktop 9.3 Views 204 Downloads 90 License Type ESRI Attribution and License Agreement 
Report Inappropriate Content: This Code Gallery is intended for the free exchange of code related to ESRI software products. Let us know if this entry is inappropriate (e.g., a download for a commercial product).
Read more:
Ingen kommentarer:
Send en kommentar