Oh man, out of my depth already. I'm curious to understand this stuff
myself. Is there a "true" link b/w dts pkges and sysxlogins?
Regards,
Uday
.....................................
Direct: +61-2-98059739
Mobile: +61-401 705907
Email: [Email address protected]
-----Original Message-----
From: Kapadia_Ghanshyambhai
[mailto:mssqldba-ezmlmshield-x84314242.[Email address protected]
Sent: Tuesday, 26 April 2005 9:46 PM
To: LazyDBA Discussion
Subject: RE: How will i know that which DTS packages, connection object ha s
set the sa password ?
Hi Uday and Siddharth,
Thanks for your reply.
How will you link master..sysxlogins to dtspackages related tables
(msdb..sysdtspackages )?
Your help is highly appreciated
Regards,
Ghanshyam Kapadia (Sr.DBA)
EMC˛
where information lives
Phone: +91-80-2678-8930 Xtn-7001
Cell: +91-98805-93991
Email:[Email address protected]
-----Original Message-----
From: Uday Shivamurthy
[mailto:mssqldba-ezmlmshield-x1814480.[Email address protected]
Sent: Tuesday, 26 April 2005 16:50
To: LazyDBA Discussion
Subject: RE: How will i know that which DTS packages, connection object has
se t the sa password ?
Hi Ghanshyam,
I don't think there is an easy way around for this problem.
Option 1
Save every dts pkg as a "vbs" file and look for credentials in the
file and change them.
Option 2
Since you've taken the pains to open each pkg, you may as well visit
the connection object and fix up credentials in each pkg.
Regards,
Uday
.....................................
Direct: +61-2-98059739
Mobile: +61-401 705907
Email: [Email address protected]
-----Original Message-----
From: Kapadia_Ghanshyambhai
[mailto:mssqldba-ezmlmshield-x66535729.[Email address protected]
Sent: Tuesday, 26 April 2005 9:11 PM
To: LazyDBA Discussion
Subject: How will i know that which DTS packages, connection object has se t
the sa password ?
Hi MSSQL Gurus
Actually, we're having a lots of DTS packages on different server and we've
changed the sa password for the all the server.
Now, a question is: How will know that which DTS packages has used sa as
user name and password for the given connection object in the DTS packages?
If you can provide the system table name which contain the sa password for
the said DTS packages and connection object, that will help me a lot.
Thanks for your help in advance
Regards,
Ghanshyam Kapadia (Sr.DBA)
EMC˛
where information lives
Phone: +91-80-2678-8930 Xtn-7001
Cell: +91-98805-93991
Email:[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page