How to change user's default database using SQL for SQL Server 2000?

Question

I tried:

ALTER LOGIN  user
WITH DEFAULT_DATABASE = defaultDB

but it says:

Line 1: Incorrect syntax near 'LOGIN'.

I know this works in 2005+ but is there a different way in 2000?

Answer 1

exec sp_defaultdb @loginame='someone', @defdb='dbname'

Or since there are only those 2 parameters,

exec sp_defaultdb 'someone', 'dbname'