I have a Sql 2000 and I'd like to migrate to sql 2005. The problem I have it's that on the Sql 2000 I have the password of SA less than 8 characters, is it possible to maintain the same password on SQL 2005?
Yes, when you go to modify the sa account, toggle Password Policy Enforcement off. However, from a security perspective, you need to see about getting that SA account password to at least 8 characters.
K. Brian Kelley