SQL Server Performance Forum – Threads Archive

server.execute n server.transfer

what is the difference between server.execute and server.transfer method

---

Duplicate posting deleted…
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22811
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

Mohammed,
You link doesn’t get the reply either you have to lock 1 thread or delete unanswered thred. Anyway coming to the discussion Server.Execute & Server.Transfer is more dependant on code side such as ASP, in this case execute process will go execute the page that you pass, and return to the calling page and continue on. Server.Transfer will stop all processing on the calling page and /transfer/ to the other page and go from there until the end without ever returning to your first page. You have to be clear about where you want to differentiate in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Thanks Satya.

---

]]>