Is there a post SP3a Hotfix build list??

Is there a post SP3a Hotfix build list?
ThanksSee:
http://www.aspfaq.com/sql2000builds.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
http://support.microsoft.com/kb/888799/
Razvan

Is there a post SP3a Hotfix build list??

Is there a post SP3a Hotfix build list?
Thanks
See:
http://www.aspfaq.com/sql2000builds.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
http://support.microsoft.com/kb/888799/
Razvan

Is there a post SP3a Hotfix build list??

Is there a post SP3a Hotfix build list?
ThanksSee:
http://www.aspfaq.com/sql2000builds.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
http://support.microsoft.com/kb/888799/
Razvan

Is there a list of the various DBCC TRACEON values?

(SQL Server 2000, SP3a)
Hello, all!
I'm interested to learn what the various Trace Flag values are for use with DBCC
TRACEON/OFF.
Thanks for any help you can provide!
John PetersonHi John,
You might find the following links useful:
Some Useful Undocumented SQL Server 2000 Trace Flags
http://www.sql-server-performance.com/ac_2000_trace_flags.asp
SQL Server 7.0 and 2000 Trace Flags
http://www.sql-server-performance.com/rd_traceflags.asp
-Sue
On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
<j0hnp@.comcast.net> wrote:
>(SQL Server 2000, SP3a)
>Hello, all!
>I'm interested to learn what the various Trace Flag values are for use with DBCC
>TRACEON/OFF.
>Thanks for any help you can provide!
>John Peterson
>|||Thanks, Sue! That's exactly what I was looking for. Though, this still doesn't seem to
be an entirely comprehensive list. Do you know whether and where a full list might be
available?
Thanks again! :-)
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
> Hi John,
> You might find the following links useful:
> Some Useful Undocumented SQL Server 2000 Trace Flags
> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
> SQL Server 7.0 and 2000 Trace Flags
> http://www.sql-server-performance.com/rd_traceflags.asp
> -Sue
> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
> <j0hnp@.comcast.net> wrote:
> >(SQL Server 2000, SP3a)
> >
> >Hello, all!
> >
> >I'm interested to learn what the various Trace Flag values are for use with DBCC
> >TRACEON/OFF.
> >
> >Thanks for any help you can provide!
> >
> >John Peterson
> >
>|||There is no full list and many of them are undocumented...so
there isn't a comprehensive documentation of all the trace
flags. Books online has a few of them documented under the
trace flags topic, you can find others by searching the
Knowledge base. In addition some books, links etc have some
listed but no one source of all of the trace flags.
-Sue
On Mon, 27 Oct 2003 12:03:36 -0700, "John Peterson"
<j0hnp@.comcast.net> wrote:
>Thanks, Sue! That's exactly what I was looking for. Though, this still doesn't seem to
>be an entirely comprehensive list. Do you know whether and where a full list might be
>available?
>Thanks again! :-)
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
>> Hi John,
>> You might find the following links useful:
>> Some Useful Undocumented SQL Server 2000 Trace Flags
>> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
>> SQL Server 7.0 and 2000 Trace Flags
>> http://www.sql-server-performance.com/rd_traceflags.asp
>> -Sue
>> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
>> <j0hnp@.comcast.net> wrote:
>> >(SQL Server 2000, SP3a)
>> >
>> >Hello, all!
>> >
>> >I'm interested to learn what the various Trace Flag values are for use with DBCC
>> >TRACEON/OFF.
>> >
>> >Thanks for any help you can provide!
>> >
>> >John Peterson
>> >
>|||Heh! That what I was afraid of. ;-)
Thanks again!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hlrqpvk92veo1l0i4lp6249u1nfhb9i9eo@.4ax.com...
> There is no full list and many of them are undocumented...so
> there isn't a comprehensive documentation of all the trace
> flags. Books online has a few of them documented under the
> trace flags topic, you can find others by searching the
> Knowledge base. In addition some books, links etc have some
> listed but no one source of all of the trace flags.
> -Sue
> On Mon, 27 Oct 2003 12:03:36 -0700, "John Peterson"
> <j0hnp@.comcast.net> wrote:
> >Thanks, Sue! That's exactly what I was looking for. Though, this still doesn't seem
to
> >be an entirely comprehensive list. Do you know whether and where a full list might be
> >available?
> >
> >Thanks again! :-)
> >
> >
> >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> >news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
> >> Hi John,
> >> You might find the following links useful:
> >> Some Useful Undocumented SQL Server 2000 Trace Flags
> >> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
> >> SQL Server 7.0 and 2000 Trace Flags
> >> http://www.sql-server-performance.com/rd_traceflags.asp
> >>
> >> -Sue
> >>
> >> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
> >> <j0hnp@.comcast.net> wrote:
> >>
> >> >(SQL Server 2000, SP3a)
> >> >
> >> >Hello, all!
> >> >
> >> >I'm interested to learn what the various Trace Flag values are for use with DBCC
> >> >TRACEON/OFF.
> >> >
> >> >Thanks for any help you can provide!
> >> >
> >> >John Peterson
> >> >
> >>
> >
>|||The 'full' list is only available internally in the SQL Server development
group. The reason for this is that the majority of trace flags are
undocumented and usually dangerous (i.e. they may cause SQL Server to crash,
shutdown, or behave in some strange way). You should not turn on trace flags
unless you're absolutely sure what the effect will be.
Thanks and regards,
Paul.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:eJ1N01MnDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Heh! That what I was afraid of. ;-)
> Thanks again!
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:hlrqpvk92veo1l0i4lp6249u1nfhb9i9eo@.4ax.com...
> > There is no full list and many of them are undocumented...so
> > there isn't a comprehensive documentation of all the trace
> > flags. Books online has a few of them documented under the
> > trace flags topic, you can find others by searching the
> > Knowledge base. In addition some books, links etc have some
> > listed but no one source of all of the trace flags.
> >
> > -Sue
> >
> > On Mon, 27 Oct 2003 12:03:36 -0700, "John Peterson"
> > <j0hnp@.comcast.net> wrote:
> >
> > >Thanks, Sue! That's exactly what I was looking for. Though, this
still doesn't seem
> to
> > >be an entirely comprehensive list. Do you know whether and where a
full list might be
> > >available?
> > >
> > >Thanks again! :-)
> > >
> > >
> > >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> > >news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
> > >> Hi John,
> > >> You might find the following links useful:
> > >> Some Useful Undocumented SQL Server 2000 Trace Flags
> > >> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
> > >> SQL Server 7.0 and 2000 Trace Flags
> > >> http://www.sql-server-performance.com/rd_traceflags.asp
> > >>
> > >> -Sue
> > >>
> > >> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
> > >> <j0hnp@.comcast.net> wrote:
> > >>
> > >> >(SQL Server 2000, SP3a)
> > >> >
> > >> >Hello, all!
> > >> >
> > >> >I'm interested to learn what the various Trace Flag values are for
use with DBCC
> > >> >TRACEON/OFF.
> > >> >
> > >> >Thanks for any help you can provide!
> > >> >
> > >> >John Peterson
> > >> >
> > >>
> > >
> >
>|||Yeah...and I should have included some of what Paul posted
for you. Additionally, traces often change from release to
release so there really is no way to know what might be safe
and what might not be safe from version to version.
If the trace will server some purpose in general use, you
can typically find it in a KB article with instructions on
when it's appropriate to use.
-Sue
On Mon, 27 Oct 2003 14:01:08 -0700, "John Peterson"
<j0hnp@.comcast.net> wrote:
>Heh! That what I was afraid of. ;-)
>Thanks again!
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:hlrqpvk92veo1l0i4lp6249u1nfhb9i9eo@.4ax.com...
>> There is no full list and many of them are undocumented...so
>> there isn't a comprehensive documentation of all the trace
>> flags. Books online has a few of them documented under the
>> trace flags topic, you can find others by searching the
>> Knowledge base. In addition some books, links etc have some
>> listed but no one source of all of the trace flags.
>> -Sue
>> On Mon, 27 Oct 2003 12:03:36 -0700, "John Peterson"
>> <j0hnp@.comcast.net> wrote:
>> >Thanks, Sue! That's exactly what I was looking for. Though, this still doesn't seem
>to
>> >be an entirely comprehensive list. Do you know whether and where a full list might be
>> >available?
>> >
>> >Thanks again! :-)
>> >
>> >
>> >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>> >news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
>> >> Hi John,
>> >> You might find the following links useful:
>> >> Some Useful Undocumented SQL Server 2000 Trace Flags
>> >> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
>> >> SQL Server 7.0 and 2000 Trace Flags
>> >> http://www.sql-server-performance.com/rd_traceflags.asp
>> >>
>> >> -Sue
>> >>
>> >> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
>> >> <j0hnp@.comcast.net> wrote:
>> >>
>> >> >(SQL Server 2000, SP3a)
>> >> >
>> >> >Hello, all!
>> >> >
>> >> >I'm interested to learn what the various Trace Flag values are for use with DBCC
>> >> >TRACEON/OFF.
>> >> >
>> >> >Thanks for any help you can provide!
>> >> >
>> >> >John Peterson
>> >> >
>> >>
>> >
>|||Thanks, Paul!
My curiosity was piqued by this link that shows a lot of the undocumented DBCC commands,
as I was investigating the DBCC SETINSTANCE (which is the underlying call from the
undocumented sp_user_counter* SPs).
http://www.sqlmag.com/forums/messageview.cfm?catid=13&threadid=9801
I noticed that this list was generated with a Trace Flag of 2520, which wasn't in that
list that Sue provided (the one by Randy Dyess). So I got to thinking, what *other* Trace
Flags are available, but undocumented?
In just some cursory browsing, I learned a number of things. For example, that you can
potentially log deadlock conditions to the error log for all connections, as indicated by
this link to dbforums:
http://65.61.175.198/t894916.html
I was interested to learn what other nifty "goodies" might be available. ;-)
Thanks for the information, and if you have any additional comments, I'd love to hear from
you.
Regards,
John Peterson
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:ua$btgNnDHA.2500@.TK2MSFTNGP10.phx.gbl...
> The 'full' list is only available internally in the SQL Server development
> group. The reason for this is that the majority of trace flags are
> undocumented and usually dangerous (i.e. they may cause SQL Server to crash,
> shutdown, or behave in some strange way). You should not turn on trace flags
> unless you're absolutely sure what the effect will be.
> Thanks and regards,
> Paul.
> --
> Paul Randal
> DBCC Technical Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:eJ1N01MnDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > Heh! That what I was afraid of. ;-)
> >
> > Thanks again!
> >
> >
> > "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> > news:hlrqpvk92veo1l0i4lp6249u1nfhb9i9eo@.4ax.com...
> > > There is no full list and many of them are undocumented...so
> > > there isn't a comprehensive documentation of all the trace
> > > flags. Books online has a few of them documented under the
> > > trace flags topic, you can find others by searching the
> > > Knowledge base. In addition some books, links etc have some
> > > listed but no one source of all of the trace flags.
> > >
> > > -Sue
> > >
> > > On Mon, 27 Oct 2003 12:03:36 -0700, "John Peterson"
> > > <j0hnp@.comcast.net> wrote:
> > >
> > > >Thanks, Sue! That's exactly what I was looking for. Though, this
> still doesn't seem
> > to
> > > >be an entirely comprehensive list. Do you know whether and where a
> full list might be
> > > >available?
> > > >
> > > >Thanks again! :-)
> > > >
> > > >
> > > >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> > > >news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
> > > >> Hi John,
> > > >> You might find the following links useful:
> > > >> Some Useful Undocumented SQL Server 2000 Trace Flags
> > > >> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
> > > >> SQL Server 7.0 and 2000 Trace Flags
> > > >> http://www.sql-server-performance.com/rd_traceflags.asp
> > > >>
> > > >> -Sue
> > > >>
> > > >> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
> > > >> <j0hnp@.comcast.net> wrote:
> > > >>
> > > >> >(SQL Server 2000, SP3a)
> > > >> >
> > > >> >Hello, all!
> > > >> >
> > > >> >I'm interested to learn what the various Trace Flag values are for
> use with DBCC
> > > >> >TRACEON/OFF.
> > > >> >
> > > >> >Thanks for any help you can provide!
> > > >> >
> > > >> >John Peterson
> > > >> >
> > > >>
> > > >
> > >
> >
> >
>|||You're welcome. Be even more vehemently warned away from playing with
unfamiliar, undocumented DBCC commands. Some of these (when used outside
specific conditions related to recovering corrupt or inaccessible databases)
can make your database unusable and unrecoverable.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:e93MX#OnDHA.2424@.TK2MSFTNGP10.phx.gbl...
> Thanks, Paul!
> My curiosity was piqued by this link that shows a lot of the undocumented
DBCC commands,
> as I was investigating the DBCC SETINSTANCE (which is the underlying call
from the
> undocumented sp_user_counter* SPs).
> http://www.sqlmag.com/forums/messageview.cfm?catid=13&threadid=9801
> I noticed that this list was generated with a Trace Flag of 2520, which
wasn't in that
> list that Sue provided (the one by Randy Dyess). So I got to thinking,
what *other* Trace
> Flags are available, but undocumented?
> In just some cursory browsing, I learned a number of things. For example,
that you can
> potentially log deadlock conditions to the error log for all connections,
as indicated by
> this link to dbforums:
> http://65.61.175.198/t894916.html
> I was interested to learn what other nifty "goodies" might be available.
;-)
> Thanks for the information, and if you have any additional comments, I'd
love to hear from
> you.
> Regards,
> John Peterson
>
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> news:ua$btgNnDHA.2500@.TK2MSFTNGP10.phx.gbl...
> > The 'full' list is only available internally in the SQL Server
development
> > group. The reason for this is that the majority of trace flags are
> > undocumented and usually dangerous (i.e. they may cause SQL Server to
crash,
> > shutdown, or behave in some strange way). You should not turn on trace
flags
> > unless you're absolutely sure what the effect will be.
> >
> > Thanks and regards,
> >
> > Paul.
> >
> > --
> > Paul Randal
> > DBCC Technical Lead, Microsoft SQL Server Storage Engine
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "John Peterson" <j0hnp@.comcast.net> wrote in message
> > news:eJ1N01MnDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > > Heh! That what I was afraid of. ;-)
> > >
> > > Thanks again!
> > >
> > >
> > > "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> > > news:hlrqpvk92veo1l0i4lp6249u1nfhb9i9eo@.4ax.com...
> > > > There is no full list and many of them are undocumented...so
> > > > there isn't a comprehensive documentation of all the trace
> > > > flags. Books online has a few of them documented under the
> > > > trace flags topic, you can find others by searching the
> > > > Knowledge base. In addition some books, links etc have some
> > > > listed but no one source of all of the trace flags.
> > > >
> > > > -Sue
> > > >
> > > > On Mon, 27 Oct 2003 12:03:36 -0700, "John Peterson"
> > > > <j0hnp@.comcast.net> wrote:
> > > >
> > > > >Thanks, Sue! That's exactly what I was looking for. Though, this
> > still doesn't seem
> > > to
> > > > >be an entirely comprehensive list. Do you know whether and where a
> > full list might be
> > > > >available?
> > > > >
> > > > >Thanks again! :-)
> > > > >
> > > > >
> > > > >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> > > > >news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
> > > > >> Hi John,
> > > > >> You might find the following links useful:
> > > > >> Some Useful Undocumented SQL Server 2000 Trace Flags
> > > > >> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
> > > > >> SQL Server 7.0 and 2000 Trace Flags
> > > > >> http://www.sql-server-performance.com/rd_traceflags.asp
> > > > >>
> > > > >> -Sue
> > > > >>
> > > > >> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
> > > > >> <j0hnp@.comcast.net> wrote:
> > > > >>
> > > > >> >(SQL Server 2000, SP3a)
> > > > >> >
> > > > >> >Hello, all!
> > > > >> >
> > > > >> >I'm interested to learn what the various Trace Flag values are
for
> > use with DBCC
> > > > >> >TRACEON/OFF.
> > > > >> >
> > > > >> >Thanks for any help you can provide!
> > > > >> >
> > > > >> >John Peterson
> > > > >> >
> > > > >>
> > > > >
> > > >
> > >
> > >
> >
> >
>|||Yes, and some of the (like DBCC PSS) give very valuable information about
for instance logical I/O's per session to mention one, which is unavailable
otherwise (to my knowledge). It's about time that some of these commands
*are* well documented, preferably by the guys who build/maintain them..
--
regards,
Mario
http://www.sqlinternals.com
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:ergphuRnDHA.964@.TK2MSFTNGP10.phx.gbl...
> You're welcome. Be even more vehemently warned away from playing with
> unfamiliar, undocumented DBCC commands. Some of these (when used outside
> specific conditions related to recovering corrupt or inaccessible
databases)
> can make your database unusable and unrecoverable.
> --
> Paul Randal
> DBCC Technical Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:e93MX#OnDHA.2424@.TK2MSFTNGP10.phx.gbl...
> > Thanks, Paul!
> >
> > My curiosity was piqued by this link that shows a lot of the
undocumented
> DBCC commands,
> > as I was investigating the DBCC SETINSTANCE (which is the underlying
call
> from the
> > undocumented sp_user_counter* SPs).
> >
> > http://www.sqlmag.com/forums/messageview.cfm?catid=13&threadid=9801
> >
> > I noticed that this list was generated with a Trace Flag of 2520, which
> wasn't in that
> > list that Sue provided (the one by Randy Dyess). So I got to thinking,
> what *other* Trace
> > Flags are available, but undocumented?
> >
> > In just some cursory browsing, I learned a number of things. For
example,
> that you can
> > potentially log deadlock conditions to the error log for all
connections,
> as indicated by
> > this link to dbforums:
> >
> > http://65.61.175.198/t894916.html
> >
> > I was interested to learn what other nifty "goodies" might be available.
> ;-)
> >
> > Thanks for the information, and if you have any additional comments, I'd
> love to hear from
> > you.
> >
> > Regards,
> >
> > John Peterson
> >
> >
> > "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> > news:ua$btgNnDHA.2500@.TK2MSFTNGP10.phx.gbl...
> > > The 'full' list is only available internally in the SQL Server
> development
> > > group. The reason for this is that the majority of trace flags are
> > > undocumented and usually dangerous (i.e. they may cause SQL Server to
> crash,
> > > shutdown, or behave in some strange way). You should not turn on trace
> flags
> > > unless you're absolutely sure what the effect will be.
> > >
> > > Thanks and regards,
> > >
> > > Paul.
> > >
> > > --
> > > Paul Randal
> > > DBCC Technical Lead, Microsoft SQL Server Storage Engine
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "John Peterson" <j0hnp@.comcast.net> wrote in message
> > > news:eJ1N01MnDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > > > Heh! That what I was afraid of. ;-)
> > > >
> > > > Thanks again!
> > > >
> > > >
> > > > "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> > > > news:hlrqpvk92veo1l0i4lp6249u1nfhb9i9eo@.4ax.com...
> > > > > There is no full list and many of them are undocumented...so
> > > > > there isn't a comprehensive documentation of all the trace
> > > > > flags. Books online has a few of them documented under the
> > > > > trace flags topic, you can find others by searching the
> > > > > Knowledge base. In addition some books, links etc have some
> > > > > listed but no one source of all of the trace flags.
> > > > >
> > > > > -Sue
> > > > >
> > > > > On Mon, 27 Oct 2003 12:03:36 -0700, "John Peterson"
> > > > > <j0hnp@.comcast.net> wrote:
> > > > >
> > > > > >Thanks, Sue! That's exactly what I was looking for. Though,
this
> > > still doesn't seem
> > > > to
> > > > > >be an entirely comprehensive list. Do you know whether and where
a
> > > full list might be
> > > > > >available?
> > > > > >
> > > > > >Thanks again! :-)
> > > > > >
> > > > > >
> > > > > >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> > > > > >news:5snqpvkqjfk30dimtq22tl6kdrd6blrmih@.4ax.com...
> > > > > >> Hi John,
> > > > > >> You might find the following links useful:
> > > > > >> Some Useful Undocumented SQL Server 2000 Trace Flags
> > > > > >> http://www.sql-server-performance.com/ac_2000_trace_flags.asp
> > > > > >> SQL Server 7.0 and 2000 Trace Flags
> > > > > >> http://www.sql-server-performance.com/rd_traceflags.asp
> > > > > >>
> > > > > >> -Sue
> > > > > >>
> > > > > >> On Mon, 27 Oct 2003 10:59:22 -0700, "John Peterson"
> > > > > >> <j0hnp@.comcast.net> wrote:
> > > > > >>
> > > > > >> >(SQL Server 2000, SP3a)
> > > > > >> >
> > > > > >> >Hello, all!
> > > > > >> >
> > > > > >> >I'm interested to learn what the various Trace Flag values are
> for
> > > use with DBCC
> > > > > >> >TRACEON/OFF.
> > > > > >> >
> > > > > >> >Thanks for any help you can provide!
> > > > > >> >
> > > > > >> >John Peterson
> > > > > >> >
> > > > > >>
> > > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Is the SP3a the most recent MSDE distribution

I ask this question because the sp3a version I have contains a merge module -
atl.msm - which is dated (modified date) 5/14/03 and is 76KB in size whereas
the "atl.msm" that is issued with VB6 SP6 contains the same merge module but
is dated Mar 14, 2004 and is 87KB in size.
Is this simply because VB6 has issued a more recent atl? If so, when will
the MSDE be brought up to date? Or better yet, since I am distributing the
atl.msm with my setup package, can I safely replace the one in the MSDE with
the more recent version?
Regards,
Jamie
hi,
thejamie wrote:
> I ask this question because the sp3a version I have contains a merge
> module - atl.msm - which is dated (modified date) 5/14/03 and is 76KB
> in size whereas the "atl.msm" that is issued with VB6 SP6 contains
> the same merge module but is dated Mar 14, 2004 and is 87KB in size.
> Is this simply because VB6 has issued a more recent atl? If so, when
> will the MSDE be brought up to date? Or better yet, since I am
> distributing the atl.msm with my setup package, can I safely replace
> the one in the MSDE with the more recent version?
MSDERelA is based on the service pack 3a of SQL Server, which is the most
recent complete distribution...
we have to wait until sp4 is available for newer versions..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Is there any word that an sp4 is imminent? Is it waiting for the SQL Server
2005 to come out of beta?
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3c4hfeF6johu1U1@.individual.net...
> hi,
> thejamie wrote:
> MSDERelA is based on the service pack 3a of SQL Server, which is the most
> recent complete distribution...
> we have to wait until sp4 is available for newer versions..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Dont think so , SP4 is announced for this or next month.
HTH, Jens Smeyer
http://www.sqlserver2005.de
"jamie" <anonymous@.nospam.somewhere.com> schrieb im Newsbeitrag
news:enT%23QkTQFHA.2132@.TK2MSFTNGP09.phx.gbl...
> Is there any word that an sp4 is imminent? Is it waiting for the SQL
> Server 2005 to come out of beta?
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3c4hfeF6johu1U1@.individual.net...
>
|||Look like it is out as of 5/6/05
"jamie" <anonymous@.nospam.somewhere.com> wrote in message
news:enT%23QkTQFHA.2132@.TK2MSFTNGP09.phx.gbl...
> Is there any word that an sp4 is imminent? Is it waiting for the SQL
> Server 2005 to come out of beta?
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3c4hfeF6johu1U1@.individual.net...
>
|||SP4 just shipped. See http://www.microsoft.com/sql/downloads/2000/sp4.asp
for details on MSDE.
joe.
"jamie" <anonymous@.nospam.somewhere.com> wrote in message
news:%23YovRe$UFHA.1148@.tk2msftngp13.phx.gbl...
> Look like it is out as of 5/6/05
> "jamie" <anonymous@.nospam.somewhere.com> wrote in message
> news:enT%23QkTQFHA.2132@.TK2MSFTNGP09.phx.gbl...
>
sql

Is sql2kdesksp3 always necessary?

Prior to installing any SP3a service packs:
VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
RTM
After installing sql2ksp3 and sql2kasp3 I get:
VERSION:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
SP3
I am having difficulty installing sql2kdesksp3 and was wondering if I was
trying to install it where it is not required?
I have an MSDN copy of SQL Server 2000 Developer Edition.
No. It appears that you have the Developer Edition of SQL Server 2000 and
did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp. A
little ways down that page it describes what each of the three files are.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"DesC" <xs667@.hotmail.com> wrote in message
news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> Prior to installing any SP3a service packs:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> RTM
>
> After installing sql2ksp3 and sql2kasp3 I get:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> SP3
>
> I am having difficulty installing sql2kdesksp3 and was wondering if I
was
> trying to install it where it is not required?
> I have an MSDN copy of SQL Server 2000 Developer Edition.
>
>
>
|||How then can you tell conclusively exactly what you have, i.e. SQL Server
2000 or MSDE 2000 ?
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> No. It appears that you have the Developer Edition of SQL Server 2000 and
> did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
> MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
A
> little ways down that page it describes what each of the three files are.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "DesC" <xs667@.hotmail.com> wrote in message
> news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
Windows[vbcol=seagreen]
Windows
> was
>
|||> After installing sql2ksp3 and sql2kasp3 I get:
Do you really have Analysis Services running? That's what sql2kasp3.exe is
for.

> I am having difficulty installing sql2kdesksp3
Probably because you don't need it. This file is for MSDE (desktop
edition).
Please read http://www.aspfaq.com/2440
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||Steve could tell because your @.@.VERSION returned "Developer Edition" in the
text.
If you have more than one installation of SQL Server, you will need to
repeat this process for every instance. Only you know how many instances
you have installed, but the SP3 page has information, I think, on
determining where your other instances live.
Also see http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DesC" <xs667@.hotmail.com> wrote in message
news:OrMYKOsMEHA.268@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> How then can you tell conclusively exactly what you have, i.e. SQL Server
> 2000 or MSDE 2000 ?
>
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
running[vbcol=seagreen]
http://www.microsoft.com/sql/downloads/2000/sp3.asp.[vbcol=seagreen]
> A
are.[vbcol=seagreen]
> rights.
> Windows
> Windows
I
>
|||Sql2kdesksp3 is for the Desktop Edition of SQL Server 2000. It appears
that you have the Developer Edition. These are not the same thing. You
already have service pack 3 (or 3a) on the SQL Server you posted the
@.@.version information from. If this is the one you are attempting to apply
sql2kdesksp3 to then it will not apply and if it did you probably do not
need it.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||You can also check your machine and/or network for all SQL Server instances
that are running. See the following URL (it may wrap):
http://www.microsoft.com/downloads/d...displaylang=en
|||Do you really have Analysis Services running?
Yes, I hope so anyrate, something wrong?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23xFJjOsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Do you really have Analysis Services running? That's what sql2kasp3.exe
is
> for.
>
> Probably because you don't need it. This file is for MSDE (desktop
> edition).
> Please read http://www.aspfaq.com/2440
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
|||> Yes, I hope so anyrate
Are you sure you know the difference between SQL Server and Analysis
Services? I think if you had any use for Analysis Services, you'd know
whether or not it was installed, instead of "I hope so"...
|||Well, I had an idea I was going to use DTS to pump data into a data
warehouse consisting of data-marts, data tables and dimension tables and
then extract static and dynamic cubes using Analysis Services (or OLAP as I
think it used to be called). I might be all wrong about this but one of my
contracts was for a major UK supermarket chain that produced a lot of data
and I figure larning how to do this kind of thing might be useful.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OG9uussMEHA.1348@.TK2MSFTNGP12.phx.gbl...
> Are you sure you know the difference between SQL Server and Analysis
> Services? I think if you had any use for Analysis Services, you'd know
> whether or not it was installed, instead of "I hope so"...
>

Is sql2kdesksp3 always necessary?

Prior to installing any SP3a service packs:
VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
RTM
After installing sql2ksp3 and sql2kasp3 I get:
VERSION:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
SP3
I am having difficulty installing sql2kdesksp3 and was wondering if I was
trying to install it where it is not required?
I have an MSDN copy of SQL Server 2000 Developer Edition.No. It appears that you have the Developer Edition of SQL Server 2000 and
did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp. A
little ways down that page it describes what each of the three files are.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"DesC" <xs667@.hotmail.com> wrote in message
news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> Prior to installing any SP3a service packs:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> RTM
>
> After installing sql2ksp3 and sql2kasp3 I get:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> SP3
>
> I am having difficulty installing sql2kdesksp3 and was wondering if I
was
> trying to install it where it is not required?
> I have an MSDN copy of SQL Server 2000 Developer Edition.
>
>
>|||How then can you tell conclusively exactly what you have, i.e. SQL Server
2000 or MSDE 2000 ?
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> No. It appears that you have the Developer Edition of SQL Server 2000 and
> did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
> MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
A
> little ways down that page it describes what each of the three files are.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "DesC" <xs667@.hotmail.com> wrote in message
> news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
Windows[vbcol=seagreen]
Windows[vbcol=seagreen]
> was
>|||> After installing sql2ksp3 and sql2kasp3 I get:
Do you really have Analysis Services running? That's what sql2kasp3.exe is
for.

> I am having difficulty installing sql2kdesksp3
Probably because you don't need it. This file is for MSDE (desktop
edition).
Please read http://www.aspfaq.com/2440
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Steve could tell because your @.@.VERSION returned "Developer Edition" in the
text.
If you have more than one installation of SQL Server, you will need to
repeat this process for every instance. Only you know how many instances
you have installed, but the SP3 page has information, I think, on
determining where your other instances live.
Also see http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DesC" <xs667@.hotmail.com> wrote in message
news:OrMYKOsMEHA.268@.TK2MSFTNGP11.phx.gbl...
> How then can you tell conclusively exactly what you have, i.e. SQL Server
> 2000 or MSDE 2000 ?
>
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
running[vbcol=seagreen]
http://www.microsoft.com/sql/downloads/2000/sp3.asp.[vbcol=seagreen]
> A
are.[vbcol=seagreen]
> rights.
> Windows
> Windows
I[vbcol=seagreen]
>|||Sql2kdesksp3 is for the Desktop Edition of SQL Server 2000. It appears
that you have the Developer Edition. These are not the same thing. You
already have service pack 3 (or 3a) on the SQL Server you posted the
@.@.version information from. If this is the one you are attempting to apply
sql2kdesksp3 to then it will not apply and if it did you probably do not
need it.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||You can also check your machine and/or network for all SQL Server instances
that are running. See the following URL (it may wrap):
CDE4D933600&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en|||Do you really have Analysis Services running?
Yes, I hope so anyrate, something wrong?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23xFJjOsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Do you really have Analysis Services running? That's what sql2kasp3.exe
is
> for.
>
> Probably because you don't need it. This file is for MSDE (desktop
> edition).
> Please read http://www.aspfaq.com/2440
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||> Yes, I hope so anyrate
Are you sure you know the difference between SQL Server and Analysis
Services? I think if you had any use for Analysis Services, you'd know
whether or not it was installed, instead of "I hope so"...|||Well, I had an idea I was going to use DTS to pump data into a data
warehouse consisting of data-marts, data tables and dimension tables and
then extract static and dynamic cubes using Analysis Services (or OLAP as I
think it used to be called). I might be all wrong about this but one of my
contracts was for a major UK supermarket chain that produced a lot of data
and I figure larning how to do this kind of thing might be useful.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OG9uussMEHA.1348@.TK2MSFTNGP12.phx.gbl...
> Are you sure you know the difference between SQL Server and Analysis
> Services? I think if you had any use for Analysis Services, you'd know
> whether or not it was installed, instead of "I hope so"...
>

Is sql2kdesksp3 always necessary?

Prior to installing any SP3a service packs:
VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
RTM
After installing sql2ksp3 and sql2kasp3 I get:
VERSION:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
SP3
I am having difficulty installing sql2kdesksp3 and was wondering if I was
trying to install it where it is not required?
I have an MSDN copy of SQL Server 2000 Developer Edition.No. It appears that you have the Developer Edition of SQL Server 2000 and
did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp. A
little ways down that page it describes what each of the three files are.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"DesC" <xs667@.hotmail.com> wrote in message
news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> Prior to installing any SP3a service packs:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> RTM
>
> After installing sql2ksp3 and sql2kasp3 I get:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> SP3
>
> I am having difficulty installing sql2kdesksp3 and was wondering if I
was
> trying to install it where it is not required?
> I have an MSDN copy of SQL Server 2000 Developer Edition.
>
>
>|||How then can you tell conclusively exactly what you have, i.e. SQL Server
2000 or MSDE 2000 ?
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> No. It appears that you have the Developer Edition of SQL Server 2000 and
> did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
> MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
A
> little ways down that page it describes what each of the three files are.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "DesC" <xs667@.hotmail.com> wrote in message
> news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> > Prior to installing any SP3a service packs:
> >
> > VERSION:
> > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
Windows
> > NT 5.1 (Build 2600: Service Pack 1)
> >
> > SERVERPROPERTY:
> > RTM
> >
> >
> > After installing sql2ksp3 and sql2kasp3 I get:
> >
> > VERSION:
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
> > NT 5.1 (Build 2600: Service Pack 1)
> >
> > SERVERPROPERTY:
> > SP3
> >
> >
> > I am having difficulty installing sql2kdesksp3 and was wondering if I
> was
> > trying to install it where it is not required?
> >
> > I have an MSDN copy of SQL Server 2000 Developer Edition.
> >
> >
> >
> >
> >
> >
>|||> After installing sql2ksp3 and sql2kasp3 I get:
Do you really have Analysis Services running? That's what sql2kasp3.exe is
for.
> I am having difficulty installing sql2kdesksp3
Probably because you don't need it. This file is for MSDE (desktop
edition).
Please read http://www.aspfaq.com/2440
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Steve could tell because your @.@.VERSION returned "Developer Edition" in the
text.
If you have more than one installation of SQL Server, you will need to
repeat this process for every instance. Only you know how many instances
you have installed, but the SP3 page has information, I think, on
determining where your other instances live.
Also see http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DesC" <xs667@.hotmail.com> wrote in message
news:OrMYKOsMEHA.268@.TK2MSFTNGP11.phx.gbl...
> How then can you tell conclusively exactly what you have, i.e. SQL Server
> 2000 or MSDE 2000 ?
>
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > No. It appears that you have the Developer Edition of SQL Server 2000
and
> > did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> > Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be
running
> > MSDE. Have a look at
http://www.microsoft.com/sql/downloads/2000/sp3.asp.
> A
> > little ways down that page it describes what each of the three files
are.
> >
> > --
> > Sincerely,
> > Stephen Dybing
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "DesC" <xs667@.hotmail.com> wrote in message
> > news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> > > Prior to installing any SP3a service packs:
> > >
> > > VERSION:
> > > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > > Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
> Windows
> > > NT 5.1 (Build 2600: Service Pack 1)
> > >
> > > SERVERPROPERTY:
> > > RTM
> > >
> > >
> > > After installing sql2ksp3 and sql2kasp3 I get:
> > >
> > > VERSION:
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows
> > > NT 5.1 (Build 2600: Service Pack 1)
> > >
> > > SERVERPROPERTY:
> > > SP3
> > >
> > >
> > > I am having difficulty installing sql2kdesksp3 and was wondering if
I
> > was
> > > trying to install it where it is not required?
> > >
> > > I have an MSDN copy of SQL Server 2000 Developer Edition.
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>|||Sql2kdesksp3 is for the Desktop Edition of SQL Server 2000. It appears
that you have the Developer Edition. These are not the same thing. You
already have service pack 3 (or 3a) on the SQL Server you posted the
@.@.version information from. If this is the one you are attempting to apply
sql2kdesksp3 to then it will not apply and if it did you probably do not
need it.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||You can also check your machine and/or network for all SQL Server instances
that are running. See the following URL (it may wrap):
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en|||Do you really have Analysis Services running?
Yes, I hope so anyrate, something wrong?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23xFJjOsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > After installing sql2ksp3 and sql2kasp3 I get:
> Do you really have Analysis Services running? That's what sql2kasp3.exe
is
> for.
> > I am having difficulty installing sql2kdesksp3
> Probably because you don't need it. This file is for MSDE (desktop
> edition).
> Please read http://www.aspfaq.com/2440
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||> Yes, I hope so anyrate
Are you sure you know the difference between SQL Server and Analysis
Services? I think if you had any use for Analysis Services, you'd know
whether or not it was installed, instead of "I hope so"...|||Well, I had an idea I was going to use DTS to pump data into a data
warehouse consisting of data-marts, data tables and dimension tables and
then extract static and dynamic cubes using Analysis Services (or OLAP as I
think it used to be called). I might be all wrong about this but one of my
contracts was for a major UK supermarket chain that produced a lot of data
and I figure larning how to do this kind of thing might be useful.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OG9uussMEHA.1348@.TK2MSFTNGP12.phx.gbl...
> > Yes, I hope so anyrate
> Are you sure you know the difference between SQL Server and Analysis
> Services? I think if you had any use for Analysis Services, you'd know
> whether or not it was installed, instead of "I hope so"...
>|||> Well, I had an idea I was going to use DTS to pump data into a data
> warehouse consisting of data-marts, data tables and dimension tables and
> then extract static and dynamic cubes using Analysis Services (or OLAP as
I
> think it used to be called). I might be all wrong about this but one of
my
> contracts was for a major UK supermarket chain that produced a lot of data
> and I figure larning how to do this kind of thing might be useful.
My original question was "do you have analysis services running?" to which
you said "I hope so."
I'm not questioning whether or not you think you can make use of Analysis
Services.
I'm questioning whether you should have even considered installing
sql2kasp3.exe.
A

Is SQL Mulstiserver Administration a requirement with SP3a

In reading through the instructions for SQL SP3a there is a statement "before
you apply the service pack, you must upgrade your SQL Server 2000
master/target server configuration." Is this really the case? What if I
don't want to deal with the Multiserver administration? Another statement in
the instructions is “If you manage two or more servers and you want to
centralize maintenance tasks” The AND YOU WANT implies it not a requirement.
Anyone know for certain?
MandyH
Hi
It is not a requirement, but really eases administration. It is advice that
they give to help lower TCO (Total Cost of Ownership).
Regards
Mike
"MandyHancock" wrote:

> In reading through the instructions for SQL SP3a there is a statement "before
> you apply the service pack, you must upgrade your SQL Server 2000
> master/target server configuration." Is this really the case? What if I
> don't want to deal with the Multiserver administration? Another statement in
> the instructions is “If you manage two or more servers and you want to
> centralize maintenance tasks” The AND YOU WANT implies it not a requirement.
> Anyone know for certain?
> --
> MandyH
>
|||Wow - Thanks for such a quick response Mike. I REALLY appreciate having
someone like you out there .
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> It is not a requirement, but really eases administration. It is advice that
> they give to help lower TCO (Total Cost of Ownership).
> Regards
> Mike
> "MandyHancock" wrote:

Is SQL Mulstiserver Administration a requirement with SP3a

In reading through the instructions for SQL SP3a there is a statement "befor
e
you apply the service pack, you must upgrade your SQL Server 2000
master/target server configuration." Is this really the case? What if I
don't want to deal with the Multiserver administration? Another statement i
n
the instructions is “If you manage two or more servers and you want to
centralize maintenance tasks” The AND YOU WANT implies it not a requiremen
t.
Anyone know for certain?
--
MandyHHi
It is not a requirement, but really eases administration. It is advice that
they give to help lower TCO (Total Cost of Ownership).
Regards
Mike
"MandyHancock" wrote:

> In reading through the instructions for SQL SP3a there is a statement "bef
ore
> you apply the service pack, you must upgrade your SQL Server 2000
> master/target server configuration." Is this really the case? What if I
> don't want to deal with the Multiserver administration? Another statement
in
> the instructions is “If you manage two or more servers and you want to
> centralize maintenance tasks” The AND YOU WANT implies it not a requirem
ent.
> Anyone know for certain?
> --
> MandyH
>|||Wow - Thanks for such a quick response Mike. I REALLY appreciate having
someone like you out there .
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> It is not a requirement, but really eases administration. It is advice tha
t
> they give to help lower TCO (Total Cost of Ownership).
> Regards
> Mike
> "MandyHancock" wrote:
>

Is SQL Mulstiserver Administration a requirement with SP3a

In reading through the instructions for SQL SP3a there is a statement "before
you apply the service pack, you must upgrade your SQL Server 2000
master/target server configuration." Is this really the case? What if I
don't want to deal with the Multiserver administration? Another statement in
the instructions is â'If you manage two or more servers and you want to
centralize maintenance tasksâ' The AND YOU WANT implies it not a requirement.
Anyone know for certain?
--
MandyHHi
It is not a requirement, but really eases administration. It is advice that
they give to help lower TCO (Total Cost of Ownership).
Regards
Mike
"MandyHancock" wrote:
> In reading through the instructions for SQL SP3a there is a statement "before
> you apply the service pack, you must upgrade your SQL Server 2000
> master/target server configuration." Is this really the case? What if I
> don't want to deal with the Multiserver administration? Another statement in
> the instructions is â'If you manage two or more servers and you want to
> centralize maintenance tasksâ' The AND YOU WANT implies it not a requirement.
> Anyone know for certain?
> --
> MandyH
>|||Wow - Thanks for such a quick response Mike. I REALLY appreciate having
someone like you out there :).
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> It is not a requirement, but really eases administration. It is advice that
> they give to help lower TCO (Total Cost of Ownership).
> Regards
> Mike
> "MandyHancock" wrote:
> > In reading through the instructions for SQL SP3a there is a statement "before
> > you apply the service pack, you must upgrade your SQL Server 2000
> > master/target server configuration." Is this really the case? What if I
> > don't want to deal with the Multiserver administration? Another statement in
> > the instructions is â'If you manage two or more servers and you want to
> > centralize maintenance tasksâ' The AND YOU WANT implies it not a requirement.
> > Anyone know for certain?
> > --
> > MandyH
> >