We have Sql server 2008r2 ,ArcGIS Server 10.1 and ArcGIS Desktop 10.1
I have gone through few links and ArcGIS help and I found that its not possible to use procedures in 10.1.. Actually I am using query layer in ArcGIS Desktop and publishing that layer to ArcGIS Server. All the data is stored in Sql Server.
We do not have ArcSDE 10.1 ( Support told that no need to install ArcSDE due to some advance functionality of 10.1..is that true??)
If anyone knows the ans then please let me know...
Query Layers execute SELECT statements. I doubt you could make them let the stored procedure execute the SELECT for you. I believe both ODBC and ArcSDE will allow you to execute stored procudures, though whether you can process return rows is something you'd have to explore.
The "advance functionality" that obviates ArcSDE is Query Layers (which was part of 10.0 as well). It is not necessary to run an application server to get access to ArcSDE functionality (this has been true since 9.2), however, ArcGIS editing still requires ArcSDE, as does versioning and replication.
Query Layers execute SELECT statements. I doubt you could make them let the stored procedure execute the SELECT for you. I believe both ODBC and ArcSDE will allow you to execute stored procudures, though whether you can process return rows is something you'd have to explore.
The "advance functionality" that obviates ArcSDE is Query Layers (which was part of 10.0 as well). It is not necessary to run an application server to get access to ArcSDE functionality (this has been true since 9.2), however, ArcGIS editing still requires ArcSDE, as does versioning and replication.
