Automatic client redirect in SQL Server 2005

Will this work with replication too. I see it with a mirror database, but could it work if I was keeping two copies of the database and wanted to transparently reroute the connection to a surviving server?We will support such redirection on the publication database, when DB mirroring becomes a supported feature later.|||* If the publication DB is mirrored, client can do automatic redirection between the database on principal server and database on mirror server. BOL has a topic called "Replication and Database Mirroring" on this. As Li said, it will be supported once DB mirroring becomes supported feature.

* If you question is to do automatic redirection between publication DB and subscription DB, the answer is NO for SQL 2005.

Auto URL Redirect

Hi,Does anyone know how to redirect the report to another URL automatically conditionally based on some checking, without user interaction with the report?I am trying to perform validity checking on user's input value and redirect user to a centralise error page if the input value is invalid.Thanks,J LimYou can't do this using the standard parameter toolbar. You will need to code your own textbox for accepting user input for the parameter value and pass that to the report if is valid and redirect to the error page if not valid.