SQLTeam.com | Weblogs | Forums

SQL Server web service




I might be asking something stupid here but here it comes :slight_smile:
Is it possible to have a web service in a SQL Server 2012? I'm thinking of a stored procedure that outputs an XML file. Is it possible (that stored procedure) to be called though by other programs from SQL Server or do I have to create a .net web service or something?

Thank you in advance.


I remember that can be done before, back maybe in 2008 or something, I donno if that got removed in 2012+. You can send soap xml to SQL and it will reply by soap (if i remember correctly), so in a way, yes it can.


Thank you for your answer I will look it up!