SQL query for sa password
Is there a SQL query that can be run to find out the sa password.
I have sql maintenance plan in place for 5+ years and all of a sudden it doesn't work. The errors are basically:
'Status: Failed - Invoked on: 2005-08-02 08:30:00 - Message: The job failed. The owner () of job Transaction Log Backup Job for 'xxxxxxxxx Maintenance Plan' does not have server access.'
which is SQLSERVERAGENT Category: 3 Event #208
Any help would be greatly appreciated.
|