Re: SA Password Change
- From: "Steve" <morriszone@xxxxxxxxxxx>
- Date: 16 Jan 2007 08:33:37 -0800
whitehsm@xxxxxxxxx wrote:
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
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
.
- References:
- SA Password Change
- From: whitehsm
- SA Password Change
- Prev by Date: SA Password Change
- Next by Date: Broken connection timeout
- Previous by thread: SA Password Change
- Next by thread: Broken connection timeout
- Index(es):
Relevant Pages
|
