Upon deployment of one of our maintain software http://www.pentaclesinc.com/moving_pro.asp?disp=1 , we stuble on System.Data.EntityCommandExecutionException. Only to find out that one of our users are using SQL 2000 in which I believe the multiple result set are not supported. So to solve the issue we modify the .EDMX file with a text editor and change the
ProviderManifestToken="2000"<pre>
<Schema Namespace="MovingProNetEnt.Store" Alias="Self"
Provider="System.Data.SqlClient" ProviderManifestToken="2000"
xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
ProviderManifestToken="2000"<pre>
<Schema Namespace="MovingProNetEnt.Store" Alias="Self"
Provider="System.Data.SqlClient" ProviderManifestToken="2000"
xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
</pre>