Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
basheer
Starting Member
2 Posts |
 Posted - 2008-04-25 : 03:42:30
|
| We have a security audit on our sql 2000 database. Some of the logins for the databases have blank passwords and easily guessable passwords. I need to change these passwords. But before I change them, I need to know which all databases, stored procedures and jobs these logins are invoking so that I can determine the effect of the password change. Can someone help me determine this effect? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-25 : 22:00:52
|
| What you listed will not be affected, but need to check dts package connections and batch processes. Bad news is no easy way. |
 |
|
|
basheer
Starting Member
2 Posts |
Posted - 2008-04-28 : 08:47:00
|
| How do i check the dts package connections and batch processes? Sorry i am not an sql expert.... :-( |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-28 : 21:43:54
|
| You have to find them out and check one by one. |
|
|
|
|
|
|
SQL Trace