topic Re: Join to SQL Server in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438690#M19375 <HTML><HEAD></HEAD><BODY><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/403018_pastedImage_1.png" style="width: auto; height: auto;" /></P><P></P><P>This is typical of the error message that I get trying to open the Atttribute Table for my joined parcels data in Pro.&nbsp; and additionally if I import a map document from an .mxd the join seems to import too.&nbsp; However too many changes or manipulations to the attribute table in pro gives the above message.&nbsp; Prior to this message I had re-arranged a few fields that I am interested in within the attribute table fields view.&nbsp;</P></BODY></HTML> Wed, 25 Apr 2018 16:10:54 GMT SamMontoia1 2018-04-25T16:10:54Z Join to SQL Server https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438687#M19372 <HTML><HEAD></HEAD><BODY><P>Running Pro 2.1.0 and Microsoft SQL Server 12.0.5203.0.&nbsp;</P><P></P><P>Wishing to join on a field between SQL and Parcels' layer.&nbsp;&nbsp; The particular table that I am joining to in SQL Server is a View of another table, but in ArcGIS it shows up as a table.&nbsp;</P><P></P><P>Anyway Join eventually fails, though this behavior works properly in ArcGIS Desktop.</P></BODY></HTML> Tue, 24 Apr 2018 22:17:02 GMT https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438687#M19372 SamMontoia1 2018-04-24T22:17:02Z Re: Join to SQL Server https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438688#M19373 <HTML><HEAD></HEAD><BODY><P>is that sql server 32 bit?</P></BODY></HTML> Wed, 25 Apr 2018 15:35:21 GMT https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438688#M19373 VinhLy2 2018-04-25T15:35:21Z Re: Join to SQL Server https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438689#M19374 <HTML><HEAD></HEAD><BODY><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/403017_pastedImage_1.png" style="width: 620px; height: 129px;" /></P><P></P><P>it's 64-bit.&nbsp; The above is from SQL Server Management Studio.&nbsp; Properties of the Server.</P></BODY></HTML> Wed, 25 Apr 2018 15:41:52 GMT https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438689#M19374 SamMontoia1 2018-04-25T15:41:52Z Re: Join to SQL Server https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438690#M19375 <HTML><HEAD></HEAD><BODY><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/403018_pastedImage_1.png" style="width: auto; height: auto;" /></P><P></P><P>This is typical of the error message that I get trying to open the Atttribute Table for my joined parcels data in Pro.&nbsp; and additionally if I import a map document from an .mxd the join seems to import too.&nbsp; However too many changes or manipulations to the attribute table in pro gives the above message.&nbsp; Prior to this message I had re-arranged a few fields that I am interested in within the attribute table fields view.&nbsp;</P></BODY></HTML> Wed, 25 Apr 2018 16:10:54 GMT https://community.esri.com/t5/arcgis-pro-questions/join-to-sql-server/m-p/438690#M19375 SamMontoia1 2018-04-25T16:10:54Z