Is there are way to Update a User password in all database of SQL Server 2008 Instance?
This script is throwing up error because there is no column with name password in the sys.database_principals. Any ideas where the password of a user will store and how we can update that?
Users don't have passwords, logins do. So you need only change the password once for the instance, and all databases within the instance will be 'affected'.
And... the error isn't just because the column isn't there - it's also because that's not how to change a password. Try
answered Jan 28 '10 at 10:23 PM