Community

Accessing a SQL Server Table View

1804
4
12-01-2014 08:21 AM
by Anonymous User
Not applicable
‎12-01-2014 08:21 AM

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

0 Kudos
4 Replies
JakeSkinner
by Esri Esteemed Contributor
Esri Esteemed Contributor
‎12-01-2014 08:32 AM

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

0 Kudos
by Anonymous User
Not applicable
‎12-01-2014 08:34 AM

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

Yes, connected as the same user and 10.2

rg

0 Kudos
JakeSkinner
by Esri Esteemed Contributor
Esri Esteemed Contributor
‎12-01-2014 08:39 AM

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

0 Kudos
by Anonymous User
Not applicable
‎12-01-2014 12:18 PM

2008 R2

In Management Studio:

SELECT     OBJECTID, NewSegID, OldSegID

FROM         dbOwnerName.myTableName

0 Kudos