Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.

learn more… | top users | synonyms (1)

1
vote
0answers
68 views

QGIS Connection with MSSQL localdb not possible correctly

I installed MSSql Server Express with localDB. Everything looks ok. The connection with the LocalDB is nessesary and the tables and views are displayed in the QGIS MSSQL Dioalog. A primary key is ...
1
vote
0answers
40 views

sql server geometry find points intersection buffer

How do I find the point of intersection of buffer?
1
vote
0answers
197 views

Deploy Web AppBuilder for external access

I am developing an app using Web AppBuilder within ArcGIS Online. The data are hosted in in-house SQL Server, not in ArcGIS Online. I have tested deploying in IIS, it works well, no issues. While ...
1
vote
0answers
34 views

Managing privileges for an ArcSDE database using SSMS

I am trying to mange users for my ArcSDE database via SSMS as opposed to tools in ArcGIS, to do this i want to set up two new user roles, data-viewer and data-editor, and then assign users to those ...
1
vote
0answers
117 views

qgis unable to connect to ms sql server using sql authentication

I am getting the following error when I try to set up a connection to a MS SQL Server database using sql server authentication. I did find a bug report from 2014, but that was apparently fixed and ...
1
vote
0answers
39 views

ArcGIS SQL Server - Using Windows Authentication

I want to use a domain level service account to manage my database connections. This account is added as a Windows authenticated account in SQL Server 2012 as a sysadmin. If I try to use this ...
1
vote
0answers
152 views

FME 2015.1.01 and SQL Server 2012 Native Client Issues

I'm having trouble connecting to a SQL Server 2008 database from FME 2015.1.01 on a computer with SQL Server Management Studio 2012, including SQL Server Native Client. Here's the error message: MS ...
1
vote
0answers
74 views

LOX table shows up instead of an address locator in SDE geodatabase on SQL server 2012

Tried to copy an address locator from a network share to an SDE database, that worked. Tried the same thing on another database and it shows up in the target geodatabase as an SDE table with LOX in ...
1
vote
0answers
35 views

In ArcSDE, SQL Studio Manager 2012, How to get pixel data using a point layer?

I was using 'where' and 'ST_Intersects' with polygon data to get values 'under' my point layer. Example: Select rd.[FORESTNAME] as Forest, Count(Distinct morel.[OBJECTID]) AS Observations From ...
1
vote
0answers
25 views

Can I do the sql server for find fnode and tnode?

Can I do the sql server for find fnode and tnode field?
1
vote
0answers
432 views

Setup ArcGIS 10.2.2 and SQL Server 2012

I installed on Oracle VM VirtualBox two Windows Server 2008 R2. • One with ArcGIS Server and ArcGIS Desktop 10.2.2 10.2.2 • The second SQL Server 2012 in Mixed Mode Because I'm not connected to ...
1
vote
0answers
31 views

Using REST Services acquiring limited data from DataBase like LayerDefinition

I am working with ArcGIS Server 10.2 and MS SQL DB. I have a requirement in which i need to retrieve limited data using a query from a bulk data using the same Map Service REST URL which can give me ...
1
vote
0answers
23 views

what I do share data in sqlserver enterprise for server?

I want to create a web editing services using ArcGIS Server, but the following error occurs when I add an editor task and click on configure. "No Editable layers found". I am using Microsoft SQL ...
1
vote
0answers
237 views

Importing 2014 TIGER County Shape Files to 2012 SQL Server?

Last year, I figured out how to import TIGER Census Block shape files into 2012 SQL Server with no issues. I assumed I would use similar code to do the county shape files but I keep getting a few ...
1
vote
0answers
77 views

SQL server in ArcGIS 10.2 Desktop

I am using ArcGIS 10.2, and previously using Oracle spatial as back end. Now the data providers have shifted to SQL providing core data using FTP which is being staged at SQL server. We need to ...
1
vote
0answers
105 views

'OutofMemoryException' whilst data trasnfer

I have a process in which data is transferred from PGDB to SDE GDB, recently I have encountered error - 'OutofMemoryException' and the process stops. I have noticed this error while trying to transfer ...
1
vote
0answers
39 views

How to reduce MSSQL Logfile size?

First of all I am not a Database specialist. I am using MSSQL to store my SDE 9.3 Data which is served with AGS 10.0. I have Vector and raster data stored in the databases and have very little room ...
1
vote
0answers
46 views

Update enterprise database from shapefile data?

Where I work we recently moved our GIS data from GDB databases to an enterprise SQL database. We primarily use ArcGIS 10.2 to edit and maintain our internal data but we also receive ancillary data ...
1
vote
0answers
42 views

Preventing Export Layer by user via ArcObjects?

In my project, I am using a Geodatabase (SQL Server) to store feature classes. I want to prevent users (who do not have permission to access or edit) exporting layers into shapefile or other ...
1
vote
0answers
102 views

Query Data from an Event Table in ArcGIS (Linear Referencing)

My goal is to store a bunch of past present and future Events in a central place from different vehicles, query those tables on demand and display the result in ArcMap. Note that right now, my Route ...
1
vote
0answers
43 views

primary key in sql server uneditable in mapinfo attribute?

I trying create table relationship in sqlserver 2008 R2. Tables will have spatial table and non-spatial (tabular) . I having trouble while selecting varchar field as primary key, this field cannon be ...
1
vote
0answers
42 views

mapping and update data in database

We have two feature layers: layer A - drainage segment layer (along road outline) layer B - road centre line layer. In my SQL Server database I have a table storing the mapping information of ...
1
vote
0answers
127 views

Creating Irregular ellipses using SQL Spatial 2012 Geometry

I have stumbled across a problem in SQL Server 2012 - whereby I need to create different shape ellipses from the following data points: centre_x | centre_y | max_x | max_y | min_x | min_y I have ...
1
vote
0answers
82 views

Hindi character support in MS SQL 2012

I have spatial MS SQL 2012 and i need to store hindi characters in a column. I tried using nvarchar datatype but I'm getting only "Question marks(????)". Is it possible to store non-english ...
1
vote
0answers
304 views

Split polyline feature in sql server 2012

Please find the below attached image. I have one point(in blue color) and polyline(in black color). Using the below sql server 2012 comment i got the nearest path(in red color) between ...
1
vote
0answers
35 views

Error trying to create mssql layer in geoserver

with mssql 2008 and the latest geoserver with the mssql store plugin, I can create a dbo connection with a mssql database and list the tables. When I try to create a layer with one of the tables which ...
1
vote
0answers
105 views

SDE Performance issue with SQL Spatial labelled lines on one server

Here is an issue that has stumped ESRI and SQL Server experts alike. I ask it here just to get more people thinking about it. Exhibit A is this screencast. I have two servers: ROGIS: A dedicated ...
1
vote
0answers
89 views

SQL 2012 shortestlineto method

I am trying to find the nearest centerline segment to an address point. I was hoping that I would be able to use the ShortestLineTo method, but it is not working. I have tested with Microsoft's ...
1
vote
0answers
45 views

Is it possible to retrieve lost versioned data in SQL Server Management Studio?

One of my staff accidentally deleted a feature class she was creating in her version before I reconciled it. I have grabbed a back up of the database from yesterday in SQL Management Studio. Is ...
1
vote
0answers
151 views

Find Nearby GPS Navigation Route

I am developing a car pooling website. For that, I have created the database which has the different route options selected by different user. These routes are saved in the Database as Geography ...
1
vote
0answers
481 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
1
vote
0answers
154 views

How do I use ReorientObject() in an SQL Server 2012 UPDATE statement?

I'm trying to UPDATE a Geography field in an SQL Server 2012 database using the output of a web mapper. I got the dreaded "The specified input does not represent a valid geography instance because it ...
1
vote
0answers
235 views

ArcGIS Query Layer SQL Server Performance Issue

I'm experiencing a performance issue with ArcGIS Query Layer using non-sde Sql Server 2008 R2. Actually, I'm using a rather comprehensive view that pulls and joins data from multiple databases and ...
1
vote
0answers
209 views

Error When Generating INSERT Statements for Geometry Field SQL Server

I am populating a column of linestrings from a list of points in sql with which I use to create insert statements to populate an ID and a geometry field in a table. This creates a temporary dataset ...
1
vote
0answers
356 views

How to add a MSSQL spatial layer using Python?

I'm having difficulty adding a MSSQL spatial data layer using Python. The database is password protected, and I can add the layer without any problems using the built in feature, but I can't make it ...
1
vote
0answers
86 views

QGis 2.01 Fedora 19 vs Windows SQL-Server Access

i just installed QGis 2.01 on Ubuntu / Fedora 19 / windows 8, configured ODBC-support for Fedora 19 and created ODBC-DSNs on the windows machine and the Fedora machine to the same SQL-Server 2012 ...
1
vote
0answers
310 views

Upgraded ESRI .NET ADF application (9.3 to 10.1) intermittently missing service issue

I also asked this question on the ESRI forum but I'm not sure if anyone will see it through the tumbleweeds over there. I had an application based on the .NET Web ADF originally built in 9.3. The ...
1
vote
0answers
873 views

How to connect to MSSQL-Server using Geoserver?

I have Geoserver on Ubuntu 13.04. On another machine I have MS SQL-Server 2008 R2. Now I want to connect it together. Google says that its possible to connect to SQL-Server from Ubuntu using ODBC ...
1
vote
0answers
236 views

SQL Server geography.Intersects Yields Unexpected Results (arch shape)

I've coupled ESRI's ArcGIS with SQL Server 2008 R2 in an attempt to allow users to search for geographical points using a polygon (with ArcGIS' drawing toolbar). I've run up against an issue that's ...
1
vote
0answers
103 views

Why is my linestring not valid ? was recorded from GPX file

I have a linestring that was built from points from GPX file. I've insert it to sql as geometry and when I try to run funcs on it (like STStartPoint ) I get error that line isn't valid and I need to ...
1
vote
0answers
199 views

Polygon not a valid geography instance

I am trying to create and insert data from ESRI shape files. This is one of the many features in the shape file, you can copy paste it and try it yourself: DECLARE @g geography; SET @g = ...
1
vote
0answers
451 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...
1
vote
0answers
58 views

SQL server 08 Limitations

The Soil SURvey GeOgraphic (SSURGO) database is a set of very large and complicated shapefiles. We want to load all of the shapefiles for the US into a national SQL database. Are there import ...
1
vote
0answers
118 views

Need to create custom map based the spatial Database

I need to create a custom map in .net 2008 c# webapplication based the spatial database(sqlserver 2008) without using any third party tools For example in sqlserver 2008 i am create a map using this ...
1
vote
0answers
286 views

One-way ArcGIS replication copying __ATTACH tables instead of base tables

I'm trying to get one-way replication working in ESRI ArcGIS 10. Here's a quick summary of the steps I followed: Open map in ArcMap with the relevant data layers I want to replicate Choose Create ...
1
vote
0answers
628 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
1
vote
0answers
472 views

Cannot join feature layer with SQL Server table with query built in it in ArcMap

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder. When I ...
1
vote
0answers
141 views

Acceptable Reduce() amounts for google maps zoom levels?

I'm using SQL Server Spatial to return large polygons to Google Maps for display. Given that google maps has a zoom scale of 1 - 20, I would like to reduce my polygons (reduce function uses the ...
1
vote
0answers
126 views

Making donut without updating id in MapInfo

I wont to make a donut out of an polygon in MapInfo. I store my data in Sql Server 2008 R2 and access it as a linked table. In SQL Server the Id-column is an Identity column that is used to as a ...
1
vote
0answers
980 views

Converting Lon Lat to UTM Zone 32N in C# with SQLSpatialTools

I have a set of coordinates; Lon 9.42221521, Lat 56.44978001 and I want to convert them to UTM Zone 32N coordinates. I found the SQLSpatialTools library to do the conversion but I need some help. When ...