Designate database in login

Is there a way to tell SQL Server 2000 which database you
want to connect to at the time of login? I have two
different database on my server and there are times I want
to log into the other database instead of the default
database. Can do this at login time?Hi
isqlw -S servername -E -d northwind
this way i can go to northwind database instead of default one( use -U -P
for sql authentication)
well with odbc u can do it your own way with connection string
Regards,
Mayur
"John Abate" <abatej@.noralnm.com> wrote in message
news:d34401c3ef37$98826cf0$a001280a@.phx.gbl...
> Is there a way to tell SQL Server 2000 which database you
> want to connect to at the time of login? I have two
> different database on my server and there are times I want
> to log into the other database instead of the default
> database. Can do this at login time?|||Thanks!

>--Original Message--
>Hi
>isqlw -S servername -E -d northwind
>this way i can go to northwind database instead of
default one( use -U -P
>for sql authentication)
>well with odbc u can do it your own way with connection
string
>Regards,
>Mayur
>
>"John Abate" <abatej@.noralnm.com> wrote in message
>news:d34401c3ef37$98826cf0$a001280a@.phx.gbl...
you
want
>
>.
>