title: Sysadmin and sa in sql server 2000 - drop and recreate login?
body: <p>A somewhat open-ended question so any information that closes the gaps in my knowledge would be appreciated.</p>
  
  <p>When doing a SQL Server upgrade from 2000 to 2008 the upgrade advisor can give the following warning:
  The Upgrade Advisor detected one or more user-defined login names that match the names of fixed server roles. Fixed server role names are reserved in SQL Server 2008. Rename the login before upgrading to SQL Server 2008.</p>
  
  <p>I believe this is because say for example a login of 'sysadmin' in a sql server 2000 database will clash with a fixed server role of 'sysadmin' in 2008..</p>
  
  <p>Is there a way to safely drop and re-create these logins or could dropping a login of say 'sa' have unintended consequences?</p>