Call A Web Service From Sql Server

[mateobus]

Hey,

I am writing a migration script from a user table to enter into our new system. In the old system, the passwords were not hashed, but in the new one they are. Since I am already using a cursor, i think the easiest way to hash the passwords would be to call a web service with the userid for each iteration of the cursor, and then i would use the C# hash object to hash the password and update the db.

I have tried using an open source md5 hash function in sql,but it doesnt use the same hash as the Microsoft Enterprise Library's Hash Class. Anyone know how to call a webservice from t-sql, or have a better solution?

 

[onpnt]

T-SQL is not that kind of language and cannot do that. If you are on SQL Server 2005 you can use C# to call the web service. You need to be very careful on security though. you will open an unsafe method on your database server but it can be secure if you do it right and p in the time to research it

[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]