Missing CLR data types on client - Microsoft.SqlServer.Types - geography and geometry

30 November,2015 by Jack Vamvas

Question: We have been having issues with an application. We have a potential  solution that involves using the  spatial data type in SQL 2008 R2

Will we have access to the geography and geometry CLR datatypes as is or do we need to load a Feature Pack ?

Answer: The CLR data types geometry and geography    are presented through the Microsoft.SqlServer.Types  CLR assembly.

To return a list of each  CLR assembly use the sys.assemblies view. You should have a resultset which includes “Microsoft.SqlServer.Types :

select * from sys.assemblies

To view each user-defined data type presented use assembly_types  view. The resultset should include the georgraphy and geormetry data types:

select * from sys.assembly_types

 

If you have an application with a dependency on these CLR data types ,and the client is not on the SQL database server, you’ll need to have those CLR assemblies installed on any client in which install the application.

One method is the Feature Pack – which will give you the stand-alone packages on the client. Download the SQL Server 2008 R2 feature Pack. This facilitates installing the CLR Data types onto a client that doesn’t have SQL Server 2008 R2 installed.

Another method is to create a package which you can install Microsoft.SqlServer.Types  assemblies  the as part of the build,.

Read More CLR Assembly and SQL Server Security

How to get the DNS API permissions in CLR assembly

SQL Server Security Policy

How to create a SQL Server Security Audit

Powershell sql server security audit

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Missing CLR data types on client - Microsoft.SqlServer.Types - geography and geometry


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer