CLR SP AND WEBSERVICE

Right Click project, On Build Tab set to Generate Serialization assembly : on On Database Tab set to Permission Level : Safe build project. Copy from bin/debug directory assembly.dll and assembly.XmlSerializers.dll Paste them to Sql Server machine on c drive my assembly name =SP_SMSSENDER CREATE ASSEMBLY SP_SMSSENDER from 'C:\SP_SMSSENDER.dll' GO CREATE ASSEMBLY [SP_SMSSENDER.XmlSerializers.dll] from 'C:\SP_SMSSENDER.XmlSerializers.dll' go create PROCEDURE [dbo].[SP_SENDSMS] @smpRef [int], @message [nvarchar](4000), @number [nvarchar](4000) WITH EXECUTE AS CALLER AS EXTERNAL NAME [SP_SMSSENDER].[StoredProcedures].[SP_SENDSMS] GO ALTER ASSEMBLY SP_SMSSENDER WITH PERMISSION_SET=EXTERNAL_ACCESS