title: how to deploy the CLR functions in SQL server 2008
body: <p>I created a SQL Server Project in VS2008 called 'RegularExpression'.In that Project i created a 'Regex.cs' class and i wrote one function regarding Regular Expression.</p>
  
  <p>Then i Build the solution.</p>
  
  <p>Now My problem is to deploy this solution in SQL server 2008 through scripts.( not just clicking on Deploy in VS2008 ).</p>
  
  <p>I succeeded up to deploy the assmebly of that project in SQL 2008 using <code>CREATE ASSEMBLY &lt;AName&gt; FROM '&lt;path of .dll&gt;'</code> </p>
  
  <p>but iam not getting that function i wrote in VS2008 in SQL 2008 Function section.</p>