SQL Server 2008 Spatial: Management Studio Express

So I figured it was time to get SQL Server 2008 Spatial up and running on my machine.  After installing a few pre-requisites (Windows PowerShell, MS Installer 4.5, etc) I was able to upgrade my current SQL Server 2005 Express, to SQL Server 2008 Express.

The install went fairly smoothly with the expcetion of not installing the SQL Server Management Studio Express (SSMSE).  After a quick Google search it was apparent this was a common problem, and you simply needed to re-run the install and choose to install the Management Tools - Basic (which btw, I did not recall seeing during the original upgrade, so I'm not sure if this is by design or not?)

Once SSMSE was installed I fired up Map 2009, and Bulk Copied some data from a previous SQL Server Schema (non-spatial), and was able to create a non FDO schema and dumped some data into it.

I was pleasantly surprised whn I popped back into SSMSE and found the Spatial Results tab on one of the tables I selected.  This tab provides a nice graphic display of the spatial data, including tooltips, labels, and a zoom slider.  Not Bad...


Take Care,
Warren 
AU in 40 days

Comments

Post a Comment

Popular posts from this blog

ArcGIS: Packaging error - General function failure

Image
Whoa... 2 posts within 2 months...  I'm on a roll baby...   :-) In today's episode I want to document what I've discovered with the following lovely error when attempting to create a Map Package: I've had this very insightful (hint:sarcasm) message box pop-up a number of times when trying to create a Map Package.  After much copying/pasting, renaming, re-connecting data sources I finally figured out what the problem was in this particular instance. This particular map had some DWG files connected to the map, and some of these DWG names contained a special character "#", and also contained extra 'dots' in the name to delimit a date.  For example: Name#-2013.04.09.dwg In my testing and trials, removing the '#' symbol did not resolve the issue, and it wasn't until I removed the extra 'dots' in the name that I was finally able to successfully generate the package.  Further testing revealed that the '#' symbol ...
Read more

More ArcGIS Woes with 'Special' Characters...

Image
It's no secret that I've griped and complained about many of ArcGIS's quirks that seem stuck or rooted in the 80's ...  One would think I wouldn't be surprised anymore when I come across such silly issues... But I am. The latest 'undocumented feature' I've discovered is that the Field Calculator will fail if there is forward slash ( '\' ) in the Layer name. ArcGIS 11 can't come soon enough.
Read more

ArcGIS Collector: Update Error Code 1006

Image
Alright, this is the second time this happened to me, and I neglected to document it the first time, so I had to search again to find the answer, so I will document it here, and now. Here goes... If you happen to come across ArcGIS Collector throwing an error when updating a feature, and the error states something along the lines of: Invalid untrusted Html content detected in field: Have no fear, there is a simple fix.  Well, that is, it's a simple fix if this is 'local' map, not accessible to the general public.  That's only because ESRI doesn't actually 'recommend' this fix. So what is 'this fix' I speak of? A little more background... If you have any fields that contain HTML content, there is a chance that Collector could see that as malicious content, and it will block it.  You can see a list of allowable HTML tags in Collector a this link . In my instance, I am running some database triggers to populate and update a URL field, where...
Read more