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

Create Duplicate SQL Server with Databases

Hi,
Is there a way to copy a SQL Server along with its databases and all other
configuration to other servers? Please keep in mind that all the other
servers are in different Active Directory/domains.
Thank you.Hi,
Thank you for your reply.
Reinstalling SQL is what I would like to avoid. I have to create SQL/Win2K
servers on a regular basis for our clients. I was trying to find a way so I
can simply ghost the server. The base configuration is the same for all our
server so the database do not change until it's been installed. Even then,
only data changes, not the DBs themselves.
Thank you.
"Stressed" <k@.c.co.uk> wrote in message
news:%23I5LeawYDHA.652@.TK2MSFTNGP10.phx.gbl...
> You may be able to install a new copy of sql server, so all the
> settings/registry keys are up to scratch on the new server, and
> then copy everything to the new server, so long as the other server
> has the same configuration and disk letters.
> I've not tried this, though, HTH.
>
> "Dragon" <nopam_baadil@.hotmail.com> wrote in message
> news:eK9VI4oYDHA.2448@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Is there a way to copy a SQL Server along with its databases and all
other
> > configuration to other servers? Please keep in mind that all the other
> > servers are in different Active Directory/domains.
> >
> > Thank you.
> >
> >
>