如题。解答了马上给分。谢谢!!!
解决方案 »
- 请教VB的for 语句中如何实现跳过
- VB中用Restore语句恢复数据库时,怎么判断某一数据库已存在,或者正在使用?
- 我在程序中打开一个数据库,如何使在DLL里也可用上这个数据库而不用再重新打开?
- 有谁编过学生的信息管理系统或其他的帮我看看(想在csdn速度快了啊高分哦哦)
- 有谁在用UML协助软件开发,谈谈经验。用UML是大势所趋吗
- 很奇怪的数据显示问题!up有分
- 111,要要要:请教关于IE控件的一个问题,不要怕来晚。
- VB读串口数据
- 用Data连接数据库,设置DatabaseName为access文件(d:\proj\proj\exam.mdb),为什么设置RecordSource出错?
- 怎样用程序设置当前按钮?
- 谁有刷卡(磁卡)的vb源代码?高分相送.
- 我要做 毕业设计 应该选什么题目呀??
Adds or changes a password for a Microsoft® SQL Server™ login.Syntax
sp_password [[@old =] 'old_password',] {[@new =] 'new_password'}
[,[@loginame =] 'login']Arguments
[@old =] 'old_password'
Is the old password. old_password is sysname, with a default of NULL.
[@new =] 'new_password'
Is the new password. new_password is sysname, with no default. old_password must be specified if named parameters are not used.
[@loginame =] 'login'
Is the name of the login affected by the password change. login is sysname, with a default of NULL. login must already exist and can only be specified by a member of the sysadmin fixed server role.
Return Code Values
0 (success) or 1 (failure)Res
SQL Server passwords can contain from 1 to 128 characters, including any letters, symbols, and numbers.The new password is updated and stored in an encrypted form so that no user, not even system administrators, can view the password.sp_password cannot be used with Microsoft Windows NT® security accounts. Users connecting to SQL Server through their Windows NT network account are authenticated by Windows NT, therefore their passwords can be changed only in Windows NT.sp_password cannot be executed within a user-defined transaction.Permissions
Execute permissions default to the public role for a user changing the password for his or her own login. Only members of the sysadmin role can change the password for another user’s login.Examples
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.EXEC sp_password NULL, 'ok', 'Victoria' B. Change a password
This example changes the password for the login Victoria from ok to coffee.EXEC sp_password 'ok', 'coffee' See Also
sp_addlogin sp_revokelogin
sp_adduser System Stored Procedures
sp_grantlogin
(c) 1988-98 Microsoft Corporation. All Rights Reserved.
可通过调用master的系统存储过程sp_password....