Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more keen on applying ''disabling SA account''! I was confronted by a Database developer that if there ...

As a DBA you might have come across this situation where you have forgotten the sa password for SQL Server - so what can you do? If you are experienced with such situation then definetly you might have an alternative solution to keep the passwords in safe. The easiest way around this is to logon to the actual SQL Server NT machine itself as ...