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

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?

sql sql-server sql-server-2000

Edit Report

0 Answers