Common Password

Hi, I would like to setup a common password for all the MS SQL Server Users. Is there any generalized script for the same ? Thanks In Advance.

No, there is no such script that ships with SQL Server because we do not recommend setting a common password for all SQL logins.

Thanks
Laurentiu

|||Thanks, Let me put my question right -

How to change a user's password through a System SP ? If I only know the administrator's username and password.|||

If you are an administrator and you want to reset a user's password, then you can just execute:

ALTER LOGIN user WITH PASSWORD = 'new_password'

See the ALTER LOGIN topic in BOL for more info on this statement.

Is this what you were looking for?

Laurentiu

|||Thanks Again. Yes you are right but i tried using the Statement and it does not work. I did not find anything related in BOL.

Note: I am using MS SQL Server 2000. Thanks|||In SQL Server 2000, you can use sp_password. CREATE LOGIN is new DDL available in SQL Server 2005 only. Here's the equivalent syntax using sp_password:

sp_password NULL, 'new_password', 'user'

You can search for "sp_password" in BOL for SQL Server 2000 for additional info on this.

Thanks
Laurentiu|||Thanks Lots Laurentiu.