SQL Server web service

Hello,

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!