Browse by Tags

Export SQL Servers registration using Management Studio?

Published 3 October 7 4:5 AM | SSQA.net

If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL...

Filed under: sql server, ssms, best practices, password, 2005, management studio, servers, export, registered

Error: Property MustChangePassword is not available for login

Published 7 August 7 9:50 AM | SSQA.net

If you have stumbled with the error "Error: Property MustChangePassword is not available for login.." or same as the picture show below: To solve the issue either you have to take out the "enforce password policy" using SA privileges...

Filed under: sql server, ssms, users, login, password, property, sqlsmo