We have a Delphi5 C/S application need to logon to multiple MS-SQL
databases, we prefer to use the same MS-SQL login user name for all the
databases login.

However, upon login, it goes to the DefaultDb of the MS-SQL Login straight
away, is there anyway to specify to logon to different database instead of
the default one.

We found out that "SP_DEFAULTDB" can change the default database for a
login, but this can only get effect for the next time login. We also found
out that "USE ADbName" seems to change the current database, but we are not
sure if this can be trusted, because we have some funny results.

Any help would be greatly appreciated.

thanks in advance
john