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

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