topic Re: Accessing a SQL Server Table View in ArcGIS Enterprise Questions

Accessing a SQL Server Table View

Anonymous User — Mon, 01 Dec 2014 16:21:16 GMT

I have a table view in SQL Server which was created with Management Studio. This View does not appear in ArcCatalog/ArcMap. Is it possible to view this table view somehow and ultimately publish it via ArcGIS Server? I understand there is a Create View tool however my question is it possible to view the native table view created in Management Studio?

Thanks!

RGibson

Re: Accessing a SQL Server Table View

JakeSkinner — Mon, 01 Dec 2014 16:32:29 GMT

Hi Russell,

Yes, it's possible to access the view you created in Management Studio and publish it to ArcGIS for Server. Are you connected to the database as the same user that created the view in SQL Server Management Studio?

Also what version are you using? Ex:

ArcSDE 10.2.2

SQL Server 2008

Re: Accessing a SQL Server Table View

Anonymous User — Mon, 01 Dec 2014 16:34:49 GMT

Hi, Jake. Thanks for the fast answer...

Yes, connected as the same user and 10.2

Re: Accessing a SQL Server Table View

JakeSkinner — Mon, 01 Dec 2014 16:39:03 GMT

Version of SQL Server? Also, can you provide the SQL you used to create the view?

Re: Accessing a SQL Server Table View

Anonymous User — Mon, 01 Dec 2014 20:18:42 GMT

2008 R2

In Management Studio:

SELECT OBJECTID, NewSegID, OldSegID

FROM dbOwnerName.myTableName