YES. You can call .Dll from SQL Server by the following ways...
1. You can use "sp_addextendedproc" to register the .Dll in SQL Server and You can call the same from SQL Server.
sp_addextendedproc "FunctionName", "Dll Path"
Using Extended Stored procedure is a "Deprecated Feature
", So please don't follow this way...
2. You can create CLR Objects in .Net (Stored Procedure, Functions,....) and Register in on SQL Server as a ASSEMBLY and then you can uses the same.
Using CLR Assembly is the only recommended way to access the .Dll(s). So, Using the Extended Stored Procedure is the "Deprecated Feature
", So please don't follow First way.
ie: CREATE ASSEMBLY....
Ray.chayan, if this helps please login to Mark As Answer. | Alert Moderator