Patches and updates

Newbie question:
Does SQL Server 2000 have an updates service like that for
Windows that tells you what you have and what you need to
apply? Is there a comprehensive list of updates and
patches? I've looked thru MS website and I didn't locate
it yet.
Thanks for your time.
DionDion,
Iam not aware about any update service but you can certainly subscribe to
the newsletter.This article provides a exhaustive list of patches and
service packs
SQLSecurity Checklist
http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Dion" <dreihs@.aol.com> wrote in message
news:114f01c37258$681f5c00$a501280a@.phx.gbl...
> Newbie question:
> Does SQL Server 2000 have an updates service like that for
> Windows that tells you what you have and what you need to
> apply? Is there a comprehensive list of updates and
> patches? I've looked thru MS website and I didn't locate
> it yet.
> Thanks for your time.
> Dion|||Thank you for you quick response.
How do you know where to begin? Can you just start at the
latest greatest cumulative patch (Cumulative Patch for
Microsoft SQL Server (815495)) or is there a progression?
Dion
>--Original Message--
>Dion,
>Iam not aware about any update service but you can
certainly subscribe to
>the newsletter.This article provides a exhaustive list of
patches and
>service packs
>SQLSecurity Checklist
>http://www.sqlsecurity.com/DesktopDefault.aspx?
tabindex=3&tabid=4
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Dion" <dreihs@.aol.com> wrote in message
>news:114f01c37258$681f5c00$a501280a@.phx.gbl...
>> Newbie question:
>> Does SQL Server 2000 have an updates service like that
for
>> Windows that tells you what you have and what you need
to
>> apply? Is there a comprehensive list of updates and
>> patches? I've looked thru MS website and I didn't locate
>> it yet.
>> Thanks for your time.
>> Dion
>
>.
>|||Try the following:
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/security/current.asp?
productid=30&servicepackid=0
Choose your product version and service pack level, then
click GO, and you will see a list of all security-related
hotfixes that apply. For instance, right now, the latest
for SQL2K with SP3 is MS03-031, which is a cumulative fix.
--m
>--Original Message--
>Dion,
>Iam not aware about any update service but you can
certainly subscribe to
>the newsletter.This article provides a exhaustive list of
patches and
>service packs
>SQLSecurity Checklist
>http://www.sqlsecurity.com/DesktopDefault.aspx?
tabindex=3&tabid=4
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Dion" <dreihs@.aol.com> wrote in message
>news:114f01c37258$681f5c00$a501280a@.phx.gbl...
>> Newbie question:
>> Does SQL Server 2000 have an updates service like that
for
>> Windows that tells you what you have and what you need
to
>> apply? Is there a comprehensive list of updates and
>> patches? I've looked thru MS website and I didn't locate
>> it yet.
>> Thanks for your time.
>> Dion
>
>.
>|||Dion,
That would be your call.Usually the service packs include all the patches
till then.Any bugs after that, if documented, would be having hotfixes.In
case you experience that, just search in http://support.microsoft.com and
apply the hotfix.If the bug is not documented you can call MS PSS.In any
case, make sure to read the related documentation and test it in a dev
environment before applying them in production.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Dion" <dreihs@.aol.com> wrote in message
news:127401c3725e$2f332880$a601280a@.phx.gbl...
> Thank you for you quick response.
> How do you know where to begin? Can you just start at the
> latest greatest cumulative patch (Cumulative Patch for
> Microsoft SQL Server (815495)) or is there a progression?
> Dion
> >--Original Message--
> >Dion,
> >
> >Iam not aware about any update service but you can
> certainly subscribe to
> >the newsletter.This article provides a exhaustive list of
> patches and
> >service packs
> >
> >SQLSecurity Checklist
> >http://www.sqlsecurity.com/DesktopDefault.aspx?
> tabindex=3&tabid=4
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Dion" <dreihs@.aol.com> wrote in message
> >news:114f01c37258$681f5c00$a501280a@.phx.gbl...
> >> Newbie question:
> >>
> >> Does SQL Server 2000 have an updates service like that
> for
> >> Windows that tells you what you have and what you need
> to
> >> apply? Is there a comprehensive list of updates and
> >> patches? I've looked thru MS website and I didn't locate
> >> it yet.
> >>
> >> Thanks for your time.
> >> Dion
> >
> >
> >.
> >

password synchronization - newbie question

We are using SQL Server authentication in a new W2k system that is replacing
a legacy UNIX system. I have a script that successfully recreates the user
accounts, but of course I have to default the password. Our security folks w
ill never agree to such a s
cheme, especially since I have read on this newsgroup that there is no way t
o force the users to change their passwords the first time they log on. Is t
here any way to port the users' UNIX passwords to SQL Server 2000? I can cap
ture the encrypted UNIX pas
swords, and was hoping there was a way to use them to populate the "password
" field of the master.sysxlogins table. Is the encryption used for UNIX in
any way compatible or "translate-able" to the encryption used by SQL Server?
This would probably be much easier if we were using Windows authentication,
but for our particular implementation, we have some other compelling reasons
not to.No the encryption algorithm is not going to be the same as any Unix based
system.
I would think that if you're writing a custom application you could force
the users to execute sp_password
at the same interval as the Unix system. But, if the users are simply
using Query Analyser and the other SQL tools,
there's no way to force this.
Yukon, the next release may address password policy enforcement that would
resolve issues like this.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you, Kevin. I'll talk to our developers about adding a call to sp_pass
word.