I know in SQL 2005, you can use the CREATE LOGIN. Along with that, you can
use also use: CHECK_EXPIRATION = and CHECK_POLICY =
When using the sp_addlogin in SQL 2000, is there anything equivelent to the
CHECK_EXPIRATION and CHECK_POLICY I can use? Any sp_?
Thanks,Nope. There is no password policy for SQL logins under SQL
Server 2000. The functionality was added to SQL Server 2005.
-Sue
On Mon, 14 Aug 2006 14:49:02 -0700, SteveS
<SteveS@.discussions.microsoft.com> wrote:
>I know in SQL 2005, you can use the CREATE LOGIN. Along with that, you can
>use also use: CHECK_EXPIRATION = and CHECK_POLICY =
>When using the sp_addlogin in SQL 2000, is there anything equivelent to the
>CHECK_EXPIRATION and CHECK_POLICY I can use? Any sp_?
>Thanks,
>|||Sue,
Thanks for the answer. It was just what I was looking for.
Steve
"Sue Hoegemeier" wrote:
> Nope. There is no password policy for SQL logins under SQL
> Server 2000. The functionality was added to SQL Server 2005.
> -Sue
> On Mon, 14 Aug 2006 14:49:02 -0700, SteveS
> <SteveS@.discussions.microsoft.com> wrote:
>
>
Wednesday, March 7, 2012
CREATE LOGIN vs. sp_addlogin
Labels:
along,
canuse,
check_expiration,
check_policy,
create,
database,
login,
microsoft,
mysql,
oracle,
server,
sp_addlogin,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment