Exegesis Spatial Data Management

 

Posts in Category: SQL Server

How to set up a MapInfo DBMS table from SQL Server without a DSN

Posted by Crispin Flower 14 November 2013 Categories: GIS (general) MapInfo Professional SQL Server
A quick note to say that it is definitely possible to use a SQL Server spatial table in MapInfo Professional without an ODBC DSN. There's not much about this on the web, and the normal methods of... read more
 
Comments(1)

Optimising SQL Server spatial indexing - let sql do the work..

Posted by 01 October 2013 Categories: GIS (general) GISquirrel SQL Server
Note – this will take a LONG time to run – quite possibly many hours - on a big dataset as it drops and recreates the index using different parameters – sledgehammer approach, but given the... read more
 
Comments(0)

SQL Server Manager Studio 2008 bug expanding database list

Posted by Steve Ellwood 27 September 2013 Categories: SQL Server
There is a bug within SSMS 2008 where if you connect to a db server using an account that does not have any rights to some of the database you can get an error when trying to expand the database list ... read more
 
Comments(5)

Invalid column name problem with GeoServer 2.3 and SQL Server views

Posted by Crispin Flower 13 June 2013 Categories: GeoServer SQL Server WMS
I have been getting this error with a WMS layer based on a SQL Server 2008 view, when using a GetFeatureInfo request: java.lang.RuntimeException: java.io.IOException java.io.IOException null... read more
 
Comments(0)

Transferring user accounts from ASP.NET to MojoPortal

Posted by 04 March 2013 Categories: mojoPortal SQL Server
Occasionally we need to transfer user accounts from existing ASP.NET membership based sites into MojoPortal Note : if the databases are on the same server, or can be linked, then it is possible to ... read more
 
Comments(0)

How to take a SQL Server backup without breaking the backup sequence

Posted by Crispin Flower 06 October 2012 Categories: SQL Server
When a SQL Server is configured to run scheduled full backups followed by a sequence of differential backups, taking an ad hoc backup will affect how backups can be restored, potentially breaking the ... read more
 
Comments(0)

How to drop all connections to a SQL Server database

Posted by Crispin Flower 18 September 2012 Categories: SQL Server
Mike S-G has passed me this useful tool for dropping all connections from a database. This is required before deleting or re-naming databases, for example. This creates a stored procedure in... read more
 
Comments(0)

Multiple SQL Server log-in failures caused by connection string error - HBSMRv3

Posted by 23 April 2012 Categories: HBSMR SQL Server

A SQL Server DBA reported many login failures in his SQL logs. These failures were not apparent to system users. The connection string included the clause <Trusted_Connections=Yes>, this should have been <Trusted_Connection=Yes>. Once the connection string had been corrected the log-in failures stopped.

... read more
 
Comments(0)

Accessing SQL Server 2008 Express (on Win 7 OS) over the network

Posted by Laine Skinner 21 March 2012 Categories: SQL Server
I hit a problem where I needed to enable network access to SQL Server 2008 Express R2 which was on a Win7 64bit OS. the solution was previously posted at:... read more
 
Comments(0)

Calculating the extent of the geometry in a SQL Server table

Posted by Crispin Flower 20 March 2012 Categories: GIS (general) SQL Server
Andy Brewer passed me this, adapted from http://barendgehrels.blogspot.co.uk/2011/04/extent-of-sql-server-spatial-table.html This is a useful script, using CTEs (common table expressions) to... read more
 
Comments(0)
Page 2 of 3 << < 1 2 3 > >>
  • RSS
https://www.esdm.co.uk/Blog/ViewCategory.aspx?cat=4&pageid=138&mid=108&pagenumber=2