SA Password Change -- sql server (microsoft)

whitehsm NO[at]SPAM gmail.com
1/15/2007 3:50:37 PM

Our DBA has just left our company and I am covering for the meantime. I
have some very basic SQL server skills and have been asked to change
the sa password on all SQL installations/instances (we have a SQL
Cluster environment as well as stand alone SQL installations).

What is the best way to find out what DTS Packages, Scheduled Jobs and
other objects that utilise this SA account/password on all
servers/cluster?

I was going to do it manually but thought I'd ask if there is an easy
way to find out this information and document it.

TIA
Stephen

Steve
1/16/2007 8:33:37 AM

[quoted text, click to view]

Generaly check out system tables and views.
In 2005:

Jobs:
SELECT j.name AS 'JobName'
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.sys.syslogins l
ON j.owner_sid = l.sid
WHERE l.name = 'sa'

Packages:
Check out dbo.sysdtspackages

sql server (microsoft) : SA Password Change