January 8, 2002 at 6:23 am
How can I use DMO to determine which Logins have NULL passwords?
The sql statement is
select name, password from dbname..syslogins where password is NULL.
Thanks
January 8, 2002 at 11:36 am
January 8, 2002 at 11:49 am
I agree it may have been better, but our entire application uses the management capabilities of DMO already to do everything else. This feature is all that is lacking.
If there is no other way to do it, we will use ADO for this 1 operation, but for maintenance reasons, it's better to stick with 1 API.
Thanks though.
January 8, 2002 at 3:19 pm
I dont think you can get passwords from the login object in DMO, you can just set passwords. You can definitely run the query using the executeimmediate which will return a queryresults object (essentially an array). It shouldnt be a lot of records so probably not hard to handle.
Andy
January 8, 2002 at 4:48 pm
Thanks for your ideas and replies.
It looks like I don't have many options.
Getting the recordset will have to do it.
Thanks again
Ken
January 8, 2002 at 9:24 pm
Not sure I explained it well - you can execute the query and return it via DMO to a queryresults object. You dont HAVE to use ADO at all.
Andy
January 9, 2002 at 4:49 am
Andy..
I had searched the documentation for the ExecuteImmediate command and got the specifics.
Thanks again for helping me out.
Ken
January 9, 2002 at 5:15 am
No problem at all! We don't get enough DMO topics, was nice to have one!
Andy
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply