Minimum password length for SQL Server Authentication and special character – how to set?

Minimum password length for SQL Server Authentication and special
character – how to set?
I need to set that minimum password length for 8 char and password
should include special character in SQL (2000) Server Authentication –
is it possible?
How to set it?
Hello sp,

> Minimum password length for SQL Server Authentication and special
> character – how to set?
> I need to set that minimum password length for 8 char and password
> should include special character in SQL (2000) Server Authentication –
> is it possible?
Nope, this feature isn't supported until SQL 2005.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||Hello,
Password and user policies are incorporated only from SQL 2005. In SQL 2000
you may need to use the Windows authentication to get that behaviour.
Thanks
Hari
"sp" <kofa@.noemail.noemail> wrote in message
news:%23VakivYcHHA.4824@.TK2MSFTNGP02.phx.gbl...
> Minimum password length for SQL Server Authentication and special
> character - how to set?
> I need to set that minimum password length for 8 char and password should
> include special character in SQL (2000) Server Authentication - is it
> possible?
> How to set it?

Migration from Sql 2k to SQL 2k5 - Questions

1. How do I copy all my sql logins with their password from sql 2000 to 2005
?
2. How do I copy all my Jobs from 2000 to 2005?1) http://blogs.msdn.com/lcris/archive.../03/567680.aspx
2) Re-create them
"" <@.discussions.microsoft.com> wrote in message
news:BC62FC5B-6297-4865-AF56-BD32F93B0C0C@.microsoft.com...
> 1. How do I copy all my sql logins with their password from sql 2000 to
> 2005?
> 2. How do I copy all my Jobs from 2000 to 2005?
>|||Hi
To add to Uri's answer
"??" wrote:

> 1. How do I copy all my sql logins with their password from sql 2000 to 2005?[/vbc
ol]
Also check out http://support.microsoft.com/kb/246133/
[vbcol=seagreen]
> 2. How do I copy all my Jobs from 2000 to 2005?
>
You can script the job(s) and then re-create the job from the script.
as described in http://support.microsoft.com/kb/314546
>
You may also need to resolve orphaned users see
http://support.microsoft.com/kb/274188/
John

Migration from Sql 2k to SQL 2k5 - Questions

1. How do I copy all my sql logins with their password from sql 2000 to 2005?
2. How do I copy all my Jobs from 2000 to 2005?
1) http://blogs.msdn.com/lcris/archive/2006/04/03/567680.aspx
2) Re-create them
"" <@.discussions.microsoft.com> wrote in message
news:BC62FC5B-6297-4865-AF56-BD32F93B0C0C@.microsoft.com...
> 1. How do I copy all my sql logins with their password from sql 2000 to
> 2005?
> 2. How do I copy all my Jobs from 2000 to 2005?
>
|||Hi
To add to Uri's answer
"??" wrote:

> 1. How do I copy all my sql logins with their password from sql 2000 to 2005?
Also check out http://support.microsoft.com/kb/246133/

> 2. How do I copy all my Jobs from 2000 to 2005?
>
You can script the job(s) and then re-create the job from the script.
as described in http://support.microsoft.com/kb/314546
>
You may also need to resolve orphaned users see
http://support.microsoft.com/kb/274188/
John

Migration from Sql 2k to SQL 2k5 - Questions

1. How do I copy all my sql logins with their password from sql 2000 to 2005?
2. How do I copy all my Jobs from 2000 to 2005?1) http://blogs.msdn.com/lcris/archive/2006/04/03/567680.aspx
2) Re-create them
"âì" <@.discussions.microsoft.com> wrote in message
news:BC62FC5B-6297-4865-AF56-BD32F93B0C0C@.microsoft.com...
> 1. How do I copy all my sql logins with their password from sql 2000 to
> 2005?
> 2. How do I copy all my Jobs from 2000 to 2005?
>|||Hi
To add to Uri's answer
"×?×?" wrote:
> 1. How do I copy all my sql logins with their password from sql 2000 to 2005?
Also check out http://support.microsoft.com/kb/246133/
> 2. How do I copy all my Jobs from 2000 to 2005?
>
You can script the job(s) and then re-create the job from the script.
as described in http://support.microsoft.com/kb/314546
>
You may also need to resolve orphaned users see
http://support.microsoft.com/kb/274188/
John