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.
| Author |
Topic |
|
craigmacca
Posting Yak Master
142 Posts |
 Posted - 2009-01-30 : 11:44:13
|
| Hi i was wondering if it was possible to use a trigger to post xml to a url using sql 2005. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-30 : 11:54:45
|
| why do you need trigger to post data? can you explain your reqmnt? |
 |
|
|
craigmacca
Posting Yak Master
142 Posts |
Posted - 2009-01-30 : 12:02:17
|
| ok i have data which gets inserted to a table, currently i have a coldfusion scheduled task that runs every 60 sec, this loops through all data in the table and does this...1. post data from row 1 as xml to a url2. delete row 1 then carry on the loopso i am trying to move this server load on to sql if possible? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-30 : 12:05:16
|
| using a trigger will have a good impact on performance. i think your current method would be better than this approach |
|
|
|
craigmacca
Posting Yak Master
142 Posts |
Posted - 2009-01-30 : 12:22:01
|
| but using my current medthid if there are 10,000 rec ords the process is very slow i need to find a better solution |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-30 : 12:24:24
|
| why are you doing it row by row? isnt it better to post xml for all rows together in bulk? |
|
|
|
|
|
|
sql 2005 xml