Do you work in multiple environments like sandbox, test and production?
With the builtin function computername() and a few if statements the need to change your code and database connection each time when moving to another environment is eliminated. The code snippet below is taken from one of my Collect.qvw files.
directory ;
Let vStartTime = now();
$(Include=..\Common\Language_DK.qvs);
if upper(ComputerName()) = 'BI01SAND' then
trace BI01SAND;
read more
Read the complete post at http://guerrillabi.com/node/25