I might be asking something stupid here but here it comes
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.