I might be wrong but I believe you can't change authentication mode once it's been set. You can always create a new DB and copy all the tables from the old DB pretty easily. HTH.
>Hello to all,
>
>I need to change the SQL 2000 authentication mode to "SQL and Windows" nor only "Windows" mode (the default), but I don't want to do it through the Enterprise Manager, It has to be through osql, T-SQL, Programmatically or whatever way.
>
>Many Thanks
>
>Amilcar Pino
It's "my" world. You're just living in it.