Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Access procedures as Web Service.

Author  Topic 

hdv212
Posting Yak Master

140 Posts

Posted - 2009-02-22 : 05:59:45
Hi
Is there anyway to access procedures (or something else like views,functions or ...) as web service ?
Thanks

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2009-02-22 : 10:33:55
At least two ways I can think of:

1. Write web methods to make a connection to the database and execute the procedures or access the tables and views. This will need setting up the web service and writing code (C#,VB.Net etc.) to create the web methods.

2. Use SQL 2005's HTTP endpoints to create the web service. I have only read about it, not actually implemented this, so I don't know the nuances. But, this is something you might want to investigate.
Go to Top of Page
   

- Advertisement -