SQL Linked Server/Web Service Question
-
Good morning, I have a question regarding if something is possible to do in SQL. Is it possible to setup a Linked Server in SQL, or some other SQL connection that will access an existing Web Service? I have found various web pages about setting up SQL data to be accessable as a Web Service, but I found nothing that says if it's possible for SQL to access a Web Service to pull back records as part of a stored procedure. The reason I'm wondering about this is because as we are moving to a new database engine, it has been suggested to turn off access to Linked Servers. David
-
Good morning, I have a question regarding if something is possible to do in SQL. Is it possible to setup a Linked Server in SQL, or some other SQL connection that will access an existing Web Service? I have found various web pages about setting up SQL data to be accessable as a Web Service, but I found nothing that says if it's possible for SQL to access a Web Service to pull back records as part of a stored procedure. The reason I'm wondering about this is because as we are moving to a new database engine, it has been suggested to turn off access to Linked Servers. David
I my be wrong, but I think you will need to write a .NET extension for SQL Server, which can then subscribe to a Web Service
Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.