I upgraded SQL 2000 to SQL 2005; the default database of sa is changed to master. I don’t know why it behaves in this way. I am waiting for some solution before implementing this on production. Is this something by design or is it a bug.

Whats the fix for it?