Wednesday, March 7, 2012

CREATE LOGIN vs. sp_addlogin

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:
>
>

No comments:

Post a Comment