I have disabled the sa account and I have a new SQL admin user account set up with a password which I have been using for the past 3 months.
However, yesterday when I went to change the password on my SQL admin user account, I get a strange error:
Create Failed For Login (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. ((Mcrosoft.SqlServer.COnnectionInfo)
An object or column name is missing or empty...Change the alias to a valid name (Microsoft SQL Server Error: 1038).
Has anyone seen this error before? Can anyone tell how to fix it so I can change the password?