I am doing a project that moves my handheld merge application from SQL2000 to a new SQL2005 server.
For the current SQL2000 version, "sscesa20.dll" was deployed under IIS which is running on the server as SQL2000.
My question is:
1. Do I have to install "sscesa20.dll" (Or "sqlcesa30.dll")in IIS under same sql server machine?
2. What benefit/risk is if I intall it in a different machine?