MSSql2000 - Always prompt for Username and Password

Dear Experts,Whenever we are using the 'Mixed Mode Authentication' to login to MSSql 2000 server there is a check box 'Always prompt for Username and Password' ( we can find the setting under 'Edit SQL Server Registration properties') which will prompt for username and password when the user is loging in to the server. Is there any way to find whether this setting is enabled or not in windows registry or using some sql query.I want to administer the sql server progrmatically.Please Suggest.Regards,Vikram

The 'Always prompt' option only relates to the current installation of Enterprise Manager, and it is probably also limited to the current user profile in Windows.
If you do not select the option, then if you open Enterprise Manager and access this registered instance of SQL Server, your session will be connected using the credentials selected here (SQL login or Windows authentication).