Access ArcGIS Server data using Visual Studio: Difference between revisions
From Wildsong
Jump to navigationJump to search
Brian Wilson (talk | contribs) Created page with "View-> SQl Server Object Explorer == See the roles attached to a geodatabase == Select the ArcGIS database you want to look at. Right click and select "New Query...". This..." |
Brian Wilson (talk | contribs) mNo edit summary |
||
| Line 16: | Line 16: | ||
Here is a screen shot after the query runs. | Here is a screen shot after the query runs. | ||
[[File:screenshot_visual_studio.png | [[File:screenshot_visual_studio.png]] | ||
<br clear=all/> | <br clear=all/> | ||
[[Category:GIS]] | |||
[[Category:SQL]] | |||
Revision as of 18:42, 13 July 2018
View-> SQl Server Object Explorer
See the roles attached to a geodatabase
Select the ArcGIS database you want to look at.
Right click and select "New Query...".
This opens a SQL query window. You can then type this in:
SELECT [name] FROM sys.database_principals
WHERE type = 'R' and principal_id>0 and principal_id<16384;
To run it, you can click the "play" button in the top bar.
Here is a screen shot after the query runs.
