I have two SQL Servers currently running SQL2000 I am in the process of upgrading to SQL 2005 is there an easy way of pointing my users to the spare SQL server while I do the upgrade. I wondered if I could run a login script which could change the ODBC setting to the spare server.