Daylight Savings Date Change

I have a Windows 2003 Standard server running MS SQL 2000 Server on it. I
read that if I have MS SQL Server Notification Services running on it I will
need to apply an update to it for the daylight savings time date change. Ho
w
do I tell if I have Notification Services running on this server. I don't
see it in Services. Is there anywhere else I need to look or is that it?
Thank you in advance.
--
Mike StevensYou would see it as a separately installed program in "Add/Remove Programs"
if you are on SQL Server
2000.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Stevens" <Stevens@.discussions.microsoft.com> wrote in message
news:D66848A1-E298-4A6E-AB6A-2085835741B0@.microsoft.com...
>I have a Windows 2003 Standard server running MS SQL 2000 Server on it. I
> read that if I have MS SQL Server Notification Services running on it I wi
ll
> need to apply an update to it for the daylight savings time date change.
How
> do I tell if I have Notification Services running on this server. I don't
> see it in Services. Is there anywhere else I need to look or is that it?
> Thank you in advance.
> --
> Mike Stevens|||In addition to the note from Tibor, you will have some databases like
NSMain* and NS*. The KB article that has the fix includes a section on
detecting if Notification Services is installed on SQL Server 2000:
http://support.microsoft.com/kb/931815
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||That answered my question. Thank you for your help.
--
Mike Stevens
"Tibor Karaszi" wrote:

> You would see it as a separately installed program in "Add/Remove Programs
" if you are on SQL Server
> 2000.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Stevens" <Stevens@.discussions.microsoft.com> wrote in message
> news:D66848A1-E298-4A6E-AB6A-2085835741B0@.microsoft.com...
>
>|||Thank you for your help. It doesn't look like I have it. One less thing to
do.
--
Mike Stevens
"Plamen Ratchev" wrote:

> In addition to the note from Tibor, you will have some databases like
> NSMain* and NS*. The KB article that has the fix includes a section on
> detecting if Notification Services is installed on SQL Server 2000:
> http://support.microsoft.com/kb/931815
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
>|||Plamen,
Can you install SQL2005 Notification Services but not configure it? If
that's so then this is what we have done so we should not have to run the
script in the KB article.
Chris
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:OBOgOXuSHHA.5016@.TK2MSFTNGP05.phx.gbl...
> In addition to the note from Tibor, you will have some databases like
> NSMain* and NS*. The KB article that has the fix includes a section on
> detecting if Notification Services is installed on SQL Server 2000:
> http://support.microsoft.com/kb/931815
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
>|||You are correct Chris. When you install Notification Services only the
binary files are installed. You have to worry about applying the fix only
when you configure and deploy instances of Notification Services, which host
notification applications. Also, note in the KB that new instances created
after SP2 will not need to be fixed, as they will have the correct
information.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||Thanks Plamen.
That's what I had hoped for.
Chris
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:%239ANydwSHHA.4260@.TK2MSFTNGP06.phx.gbl...
> You are correct Chris. When you install Notification Services only the
> binary files are installed. You have to worry about applying the fix only
> when you configure and deploy instances of Notification Services, which
> host notification applications. Also, note in the KB that new instances
> created after SP2 will not need to be fixed, as they will have the correct
> information.
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>