I have a webservice that I would like to call from SQL Server 2005. I have done alot of testing and am pretty familiar with how CLR works and how to create assemblies in SQL. My problem is that I don't know much about .net and am not sure what kind of project I need to create in Visual Studios to accomplish calling the webservice. I've tried googling and have not found much that is of use to me.
Any help would be appreciated
Aaron
You need to
1) creat SQL Server Project and create CRL stored Procedure.
2) add your wsdl file to web reference that points to your web service
3) call web method in your CRL stored Procedure
The following link might be useful to you.
http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx
No comments:
Post a Comment