How will i know that which DTS packages, connection object has se t the sa password ?

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]




MS Sql Server LazyDBA home page