Hello Gang,

At the moment am looking into consolidating SQL Server databases. I am basically an Oracle DBA and know very little about SQL Server.

The question is, if I move the database to a new server then in Oracle I will change the values in TNSNAMES.ORA to point in the right direction. Where should I do this in case of SQL Server 7?

Thanks in advance,
-Shyami