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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-15 : 08:56:04
|
| Ken writes "I know that using SQL statements, I can find all logins with blank passwords:select dbname, password from master..syslogins where password is NULL.However, I cannot find any property/method in SQL-DMO that would find this data.The Login object has a method SetPassword(), but no evaluate/get method.Is there a way to do this using SQL-DMO?Thank youKen" |
|
|
kong
Starting Member
1 Post |
Posted - 2002-01-15 : 09:04:24
|
| I was informed about the DMO method ExecuteImmediate().This or one of its derrivatives worked fine for what I needed.We can do a T-SQL statement from here and get the information.Thanks to people on this site who informed me of this.Ken |
 |
|
|
|
|
|
Using SQL-DMO to find logins with NULL passwords