title: How to change user's default database using SQL for SQL Server 2000?
body: <p>I tried:</p>
  
  <pre><code>ALTER LOGIN  user
  WITH DEFAULT_DATABASE = defaultDB
  </code></pre>
  
  <p>but it says:</p>
  
  <blockquote>
    <p>Line 1: Incorrect syntax near 'LOGIN'.</p>
  </blockquote>
  
  <p>I know this works in 2005+ but is there a different way in 2000?</p>