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 |
|
LeoC
Starting Member
37 Posts |
 Posted - 2004-11-18 : 11:15:24
|
| Does anybody have a fix to change passwords under a login that only has 'security-admin' role.I don't want to give 'sysadmin' to the user, yet she cannot change passwords (in SQL 7); I duplicated the process and get ...error 15210 only sysadmin role can use login name option...Thanks,lec. |
|
|
LeoC
Starting Member
37 Posts |
Posted - 2004-11-26 : 15:21:41
|
| OK, no one has a solution for the above...BUT what if I take sp_password from SQL 2K and make it work/compile in SQL 7?What exactly does:dbcc auditevent (107, @self, 1, @loginame, NULL, NULL, NULL)actually do? Other than that I tested the change in procs. and it seems to work OK.Any comments anyone?lec. |
 |
|
|
|
|
|
SQL server 7 - changing login passwords