check sql licence: sp4

Showing posts with label sp4. Show all posts

Saturday, February 25, 2012

checkpoint on tempdb

It appears that after applying SP4 (the box has 4GB of RAM, so no post-SP4
was applied) the following situation started occuring:
- There is a simple scripted trace running on the server that captures
STMTCompleted and BatchCompleted events;
- A scheduled tasks fires every minute and captures the results using
::fn_trace_gettable function;
- tempdb is in Simple recovery mode (doh, that's the only mode that this
database can be in), but without explicitly issuing CHECKPOINT or BACKUP LOG
TEMPDB WITH TRUNCATE_ONLY space used in the log device continues growing.
While investigating the issue I set 3502 trace flag on, and also discovered
that even after explicitly issuing CHECKPOINT the entry about the checkpoint
on tempdb is not made.
As a workaround I added BACKUP LOG TEMPDB WITH TRUNCATE_ONLY to the job that
runs every minute. But what's interesting is that exactly the same scenario
with exactly the same trace works fine in 818 build, and space used in TEMPD
B
log device gets periodically cleared without having to explicitly issue any
checkpoint-related commands.
Is it a bug in SP4? And why 3502 trace flag does not post the entry for
TEMPDB (dbid 2)?
Any pointers would be appreciated.Thanks for reporting this problem.
TF3502 does not post entry in the errorlog for tempdb. This has been the
case since SQL 7.0.
There is another way to find out if there has been a checkpoint:
use tempdb
select * from ::fn_dblog(null, null)
This dumps the log since the last checkpoint.
Can you try that and let us know if there is indeed no checkpoint log
record? Or you could send me the data+log file of your tempdb in a zip file
and I will take a look. But that file may be huge.
This could be a bug. In the mean time I will ask the devs around here to see
if
anybody knows.
Finally, please note that both TF3502 and fn_dblog are undocumented
commands. There might be issues with using them on production systems. You
could open a case with Microsoft Product Support if you are not comfortable
with diagnosing the problem on your own.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Djabarov" <Robert Djabarov@.discussions.microsoft.com> wrote in
message news:B1CA9B5B-34B2-46D2-927B-01815B92E912@.microsoft.com...
> It appears that after applying SP4 (the box has 4GB of RAM, so no post-SP4
> was applied) the following situation started occuring:
> - There is a simple scripted trace running on the server that captures
> STMTCompleted and BatchCompleted events;
> - A scheduled tasks fires every minute and captures the results using
> ::fn_trace_gettable function;
> - tempdb is in Simple recovery mode (doh, that's the only mode that this
> database can be in), but without explicitly issuing CHECKPOINT or BACKUP
> LOG
> TEMPDB WITH TRUNCATE_ONLY space used in the log device continues growing.
> While investigating the issue I set 3502 trace flag on, and also
> discovered
> that even after explicitly issuing CHECKPOINT the entry about the
> checkpoint
> on tempdb is not made.
> As a workaround I added BACKUP LOG TEMPDB WITH TRUNCATE_ONLY to the job
> that
> runs every minute. But what's interesting is that exactly the same
> scenario
> with exactly the same trace works fine in 818 build, and space used in
> TEMPDB
> log device gets periodically cleared without having to explicitly issue
> any
> checkpoint-related commands.
> Is it a bug in SP4? And why 3502 trace flag does not post the entry for
> TEMPDB (dbid 2)?
> Any pointers would be appreciated.

checkpoint on tempdb

It appears that after applying SP4 (the box has 4GB of RAM, so no post-SP4
was applied) the following situation started occuring:
- There is a simple scripted trace running on the server that captures
STMTCompleted and BatchCompleted events;
- A scheduled tasks fires every minute and captures the results using
::fn_trace_gettable function;
- tempdb is in Simple recovery mode (doh, that's the only mode that this
database can be in), but without explicitly issuing CHECKPOINT or BACKUP LOG
TEMPDB WITH TRUNCATE_ONLY space used in the log device continues growing.
While investigating the issue I set 3502 trace flag on, and also discovered
that even after explicitly issuing CHECKPOINT the entry about the checkpoint
on tempdb is not made.
As a workaround I added BACKUP LOG TEMPDB WITH TRUNCATE_ONLY to the job that
runs every minute. But what's interesting is that exactly the same scenario
with exactly the same trace works fine in 818 build, and space used in TEMPDB
log device gets periodically cleared without having to explicitly issue any
checkpoint-related commands.
Is it a bug in SP4? And why 3502 trace flag does not post the entry for
TEMPDB (dbid 2)?
Any pointers would be appreciated.Thanks for reporting this problem.
TF3502 does not post entry in the errorlog for tempdb. This has been the
case since SQL 7.0.
There is another way to find out if there has been a checkpoint:
use tempdb
select * from ::fn_dblog(null, null)
This dumps the log since the last checkpoint.
Can you try that and let us know if there is indeed no checkpoint log
record? Or you could send me the data+log file of your tempdb in a zip file
and I will take a look. But that file may be huge.
This could be a bug. In the mean time I will ask the devs around here to see
if
anybody knows.
Finally, please note that both TF3502 and fn_dblog are undocumented
commands. There might be issues with using them on production systems. You
could open a case with Microsoft Product Support if you are not comfortable
with diagnosing the problem on your own.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Djabarov" <Robert Djabarov@.discussions.microsoft.com> wrote in
message news:B1CA9B5B-34B2-46D2-927B-01815B92E912@.microsoft.com...
> It appears that after applying SP4 (the box has 4GB of RAM, so no post-SP4
> was applied) the following situation started occuring:
> - There is a simple scripted trace running on the server that captures
> STMTCompleted and BatchCompleted events;
> - A scheduled tasks fires every minute and captures the results using
> ::fn_trace_gettable function;
> - tempdb is in Simple recovery mode (doh, that's the only mode that this
> database can be in), but without explicitly issuing CHECKPOINT or BACKUP
> LOG
> TEMPDB WITH TRUNCATE_ONLY space used in the log device continues growing.
> While investigating the issue I set 3502 trace flag on, and also
> discovered
> that even after explicitly issuing CHECKPOINT the entry about the
> checkpoint
> on tempdb is not made.
> As a workaround I added BACKUP LOG TEMPDB WITH TRUNCATE_ONLY to the job
> that
> runs every minute. But what's interesting is that exactly the same
> scenario
> with exactly the same trace works fine in 818 build, and space used in
> TEMPDB
> log device gets periodically cleared without having to explicitly issue
> any
> checkpoint-related commands.
> Is it a bug in SP4? And why 3502 trace flag does not post the entry for
> TEMPDB (dbid 2)?
> Any pointers would be appreciated.

checkpoint on tempdb

It appears that after applying SP4 (the box has 4GB of RAM, so no post-SP4
was applied) the following situation started occuring:
- There is a simple scripted trace running on the server that captures
STMTCompleted and BatchCompleted events;
- A scheduled tasks fires every minute and captures the results using
::fn_trace_gettable function;
- tempdb is in Simple recovery mode (doh, that's the only mode that this
database can be in), but without explicitly issuing CHECKPOINT or BACKUP LOG
TEMPDB WITH TRUNCATE_ONLY space used in the log device continues growing.
While investigating the issue I set 3502 trace flag on, and also discovered
that even after explicitly issuing CHECKPOINT the entry about the checkpoint
on tempdb is not made.
As a workaround I added BACKUP LOG TEMPDB WITH TRUNCATE_ONLY to the job that
runs every minute. But what's interesting is that exactly the same scenario
with exactly the same trace works fine in 818 build, and space used in TEMPDB
log device gets periodically cleared without having to explicitly issue any
checkpoint-related commands.
Is it a bug in SP4? And why 3502 trace flag does not post the entry for
TEMPDB (dbid 2)?
Any pointers would be appreciated.
Thanks for reporting this problem.
TF3502 does not post entry in the errorlog for tempdb. This has been the
case since SQL 7.0.
There is another way to find out if there has been a checkpoint:
use tempdb
select * from ::fn_dblog(null, null)
This dumps the log since the last checkpoint.
Can you try that and let us know if there is indeed no checkpoint log
record? Or you could send me the data+log file of your tempdb in a zip file
and I will take a look. But that file may be huge.
This could be a bug. In the mean time I will ask the devs around here to see
if
anybody knows.
Finally, please note that both TF3502 and fn_dblog are undocumented
commands. There might be issues with using them on production systems. You
could open a case with Microsoft Product Support if you are not comfortable
with diagnosing the problem on your own.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Djabarov" <Robert Djabarov@.discussions.microsoft.com> wrote in
message news:B1CA9B5B-34B2-46D2-927B-01815B92E912@.microsoft.com...
> It appears that after applying SP4 (the box has 4GB of RAM, so no post-SP4
> was applied) the following situation started occuring:
> - There is a simple scripted trace running on the server that captures
> STMTCompleted and BatchCompleted events;
> - A scheduled tasks fires every minute and captures the results using
> ::fn_trace_gettable function;
> - tempdb is in Simple recovery mode (doh, that's the only mode that this
> database can be in), but without explicitly issuing CHECKPOINT or BACKUP
> LOG
> TEMPDB WITH TRUNCATE_ONLY space used in the log device continues growing.
> While investigating the issue I set 3502 trace flag on, and also
> discovered
> that even after explicitly issuing CHECKPOINT the entry about the
> checkpoint
> on tempdb is not made.
> As a workaround I added BACKUP LOG TEMPDB WITH TRUNCATE_ONLY to the job
> that
> runs every minute. But what's interesting is that exactly the same
> scenario
> with exactly the same trace works fine in 818 build, and space used in
> TEMPDB
> log device gets periodically cleared without having to explicitly issue
> any
> checkpoint-related commands.
> Is it a bug in SP4? And why 3502 trace flag does not post the entry for
> TEMPDB (dbid 2)?
> Any pointers would be appreciated.

Checkpoint not being issued

Hi,

Has anybody encountered this situation before? DB on SQL Server 2000 SP4 with trunc log on chkpt option turned on. Checkpoint trace flags were turned on but noticing no checkpoints are being done on one specific DB resulting into growing transaction log. No open transactions.

Any ideas?

Thanks.What traceflags are you using, and why?

Friday, February 24, 2012

CHECKING the TRANSACTION LOG

I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
2000 Server. Is there a equivalent command or procedure. Thanks.
Hi Tom
Because log files are separate physical files this command is redundant. If
you want to look at the space used in the log file try DBCC SQLPERF
(logspace) http://msdn2.microsoft.com/en-us/library/aa258819(SQL.80).aspx.
For other database consistency checks DBCC CHECKDB, DBCC CHECKTABLE, DBCC
CHECKALLOC...
John
"Tom Reis" wrote:

> I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
> check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
> 2000 Server. Is there a equivalent command or procedure. Thanks.
>
>

CHECKING the TRANSACTION LOG

I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
2000 Server. Is there a equivalent command or procedure. Thanks.What is it in the transaction log that you want to check?
For 7.0 and 2000, DBCC CHECKDB and CHECKCATALOG covers integrity checks for
a database.
For 2005, you don't need CHECKCATALOG.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message news:OsLvRLaCHHA.4908@.TK2MSFTNGP03.phx.g
bl...
>I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
> check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
> 2000 Server. Is there a equivalent command or procedure. Thanks.
>|||Hi Tom
Because log files are separate physical files this command is redundant. If
you want to look at the space used in the log file try DBCC SQLPERF
(logspace) http://msdn2.microsoft.com/en-us/library/aa258819(SQL.80).aspx.
For other database consistency checks DBCC CHECKDB, DBCC CHECKTABLE, DBCC
CHECKALLOC...
John
"Tom Reis" wrote:

> I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
> check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
> 2000 Server. Is there a equivalent command or procedure. Thanks.
>
>

CHECKING the TRANSACTION LOG

I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
2000 Server. Is there a equivalent command or procedure. Thanks.What is it in the transaction log that you want to check?
For 7.0 and 2000, DBCC CHECKDB and CHECKCATALOG covers integrity checks for a database.
For 2005, you don't need CHECKCATALOG.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message news:OsLvRLaCHHA.4908@.TK2MSFTNGP03.phx.gbl...
>I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
> check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
> 2000 Server. Is there a equivalent command or procedure. Thanks.
>|||Hi Tom
Because log files are separate physical files this command is redundant. If
you want to look at the space used in the log file try DBCC SQLPERF
(logspace) http://msdn2.microsoft.com/en-us/library/aa258819(SQL.80).aspx.
For other database consistency checks DBCC CHECKDB, DBCC CHECKTABLE, DBCC
CHECKALLOC...
John
"Tom Reis" wrote:
> I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
> check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
> 2000 Server. Is there a equivalent command or procedure. Thanks.
>
>

Tuesday, February 14, 2012

CHECKDB found 0 allocation errors and 2 consistency errors in data

Hi,
SQL 2000, SP4
Getting CHECKDB found 0 allocation errors and 2 consistency errors in
database after running dbcc checkdb:
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'abc', index 'SyncServerState.PK_SyncServerState' (ID
327672215) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:677:2) with values (Id = 3 and ServerConfigId = 0 and Type = 'DevMgmtServerConfigHistoryId') points to the data row identified by ().
Also seeing in SQL error log:
Could not find the index entry for RID
'3600000000020000010044004400650076004d0067006d00740053006500720076006500720043006f006e00660069006700' in index page (1:152369),
help would be apperciated
thxTry rebuilding those indexes and you should be fine as they are
nonclustered.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:388A8392-1139-4315-9911-38607DB51AD6@.microsoft.com...
> Hi,
> SQL 2000, SP4
> Getting CHECKDB found 0 allocation errors and 2 consistency errors in
> database after running dbcc checkdb:
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'abc', index 'SyncServerState.PK_SyncServerState'
> (ID
> 327672215) (index ID 2). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:677:2) with values (Id = 3 and ServerConfigId = 0 and Type => 'DevMgmtServerConfigHistoryId') points to the data row identified by ().
> Also seeing in SQL error log:
> Could not find the index entry for RID
> '3600000000020000010044004400650076004d0067006d00740053006500720076006500720043006f006e00660069006700'
> in index page (1:152369),
> help would be apperciated
> thx|||Hi,
I am looking at manage index window and it says that it is Clustered,
"stoney" wrote:
> Hi,
> SQL 2000, SP4
> Getting CHECKDB found 0 allocation errors and 2 consistency errors in
> database after running dbcc checkdb:
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'abc', index 'SyncServerState.PK_SyncServerState' (ID
> 327672215) (index ID 2). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:677:2) with values (Id = 3 and ServerConfigId = 0 and Type => 'DevMgmtServerConfigHistoryId') points to the data row identified by ().
> Also seeing in SQL error log:
> Could not find the index entry for RID
> '3600000000020000010044004400650076004d0067006d00740053006500720076006500720043006f006e00660069006700' in index page (1:152369),
> help would be apperciated
> thx|||This definately says the index ID is 2. The index ID has to be 1 for it to
be a clustered index.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'abc', index 'SyncServerState.PK_SyncServerState' (ID
327672215) (index ID 2). Extra or invalid key for the keys:
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:B4EE6885-40EE-4842-9188-F02B61CCEE38@.microsoft.com...
> Hi,
> I am looking at manage index window and it says that it is Clustered,
> "stoney" wrote:
>> Hi,
>> SQL 2000, SP4
>> Getting CHECKDB found 0 allocation errors and 2 consistency errors in
>> database after running dbcc checkdb:
>> Server: Msg 8952, Level 16, State 1, Line 1
>> Table error: Database 'abc', index 'SyncServerState.PK_SyncServerState'
>> (ID
>> 327672215) (index ID 2). Extra or invalid key for the keys:
>> Server: Msg 8956, Level 16, State 1, Line 1
>> Index row (1:677:2) with values (Id = 3 and ServerConfigId = 0 and Type =>> 'DevMgmtServerConfigHistoryId') points to the data row identified by ().
>> Also seeing in SQL error log:
>> Could not find the index entry for RID
>> '3600000000020000010044004400650076004d0067006d00740053006500720076006500720043006f006e00660069006700'
>> in index page (1:152369),
>> help would be apperciated
>> thx|||thx Andrew, I have rebuilt the index and all seems to be working fine.
Allthough I see in the errorlog 'Skipping startup of clean database id 5' and
that is the id of the db that I rebuilt the inex on.
Any thoughts
"Andrew J. Kelly" wrote:
> Try rebuilding those indexes and you should be fine as they are
> nonclustered.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:388A8392-1139-4315-9911-38607DB51AD6@.microsoft.com...
> > Hi,
> >
> > SQL 2000, SP4
> > Getting CHECKDB found 0 allocation errors and 2 consistency errors in
> > database after running dbcc checkdb:
> >
> > Server: Msg 8952, Level 16, State 1, Line 1
> > Table error: Database 'abc', index 'SyncServerState.PK_SyncServerState'
> > (ID
> > 327672215) (index ID 2). Extra or invalid key for the keys:
> >
> > Server: Msg 8956, Level 16, State 1, Line 1
> > Index row (1:677:2) with values (Id = 3 and ServerConfigId = 0 and Type => > 'DevMgmtServerConfigHistoryId') points to the data row identified by ().
> >
> > Also seeing in SQL error log:
> >
> > Could not find the index entry for RID
> > '3600000000020000010044004400650076004d0067006d00740053006500720076006500720043006f006e00660069006700'
> > in index page (1:152369),
> >
> > help would be apperciated
> >
> > thx
>

Sunday, February 12, 2012

Check version of SQL 2000 w/ select @@version

Can anybody tell me when i complete the sp4 upgrade to my sql server
2000 why when I type "select @.@.version" under sql query analyzer it
doesn't releft latest upgrade to sevice pack 4?
ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
2000 00:57:48
Any reply to help would be much appreciated... email:
mlajoinie@.gmail.com
-thanksThat is rtm. Better reapply the sp again.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159588073.880553.264310@.m73g2000cwd.googlegroups.com...
> Can anybody tell me when i complete the sp4 upgrade to my sql server
> 2000 why when I type "select @.@.version" under sql query analyzer it
> doesn't releft latest upgrade to sevice pack 4?
> ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> 2000 00:57:48
> Any reply to help would be much appreciated... email:
> mlajoinie@.gmail.com
> -thanks
>|||Thanks, but I have reapplied this sp4 with same results, also tried it
on a sql 2000 dvlp ed. on xp with same results. I read something about
having the services stopped prior to running the service pack so tried
that too with same results after the select @.@.version command. Are
there any cmd lines to force the sp upgrade?
frizzzdog wrote:
> Can anybody tell me when i complete the sp4 upgrade to my sql server
> 2000 why when I type "select @.@.version" under sql query analyzer it
> doesn't releft latest upgrade to sevice pack 4?
> ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> 2000 00:57:48
> Any reply to help would be much appreciated... email:
> mlajoinie@.gmail.com
> -thanks|||Hi
Have you extracted the service pack and then run the upgrade or just
extracted it?
John
"frizzzdog" wrote:
> Thanks, but I have reapplied this sp4 with same results, also tried it
> on a sql 2000 dvlp ed. on xp with same results. I read something about
> having the services stopped prior to running the service pack so tried
> that too with same results after the select @.@.version command. Are
> there any cmd lines to force the sp upgrade?
> frizzzdog wrote:
> > Can anybody tell me when i complete the sp4 upgrade to my sql server
> > 2000 why when I type "select @.@.version" under sql query analyzer it
> > doesn't releft latest upgrade to sevice pack 4?
> > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> > 2000 00:57:48
> > Any reply to help would be much appreciated... email:
> > mlajoinie@.gmail.com
> > -thanks
>|||John,
I extracted the service pack then ran it from a saved folder with same
reszults from sql query. Read somewhere that the services must stopped
when running the service pack but only saw it once. Any more thoughts -
same results from the query...
Marc
John Bell wrote:
> Hi
> Have you extracted the service pack and then run the upgrade or just
> extracted it?
> John
> "frizzzdog" wrote:
> > Thanks, but I have reapplied this sp4 with same results, also tried it
> > on a sql 2000 dvlp ed. on xp with same results. I read something about
> > having the services stopped prior to running the service pack so tried
> > that too with same results after the select @.@.version command. Are
> > there any cmd lines to force the sp upgrade?
> >
> > frizzzdog wrote:
> > > Can anybody tell me when i complete the sp4 upgrade to my sql server
> > > 2000 why when I type "select @.@.version" under sql query analyzer it
> > > doesn't releft latest upgrade to sevice pack 4?
> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> > > 2000 00:57:48
> > > Any reply to help would be much appreciated... email:
> > > mlajoinie@.gmail.com
> > > -thanks
> >
> >|||Do you have multiple SQL 2000 instances installed? Each must be upgraded
independently.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> John,
> I extracted the service pack then ran it from a saved folder with same
> reszults from sql query. Read somewhere that the services must stopped
> when running the service pack but only saw it once. Any more thoughts -
> same results from the query...
> Marc
> John Bell wrote:
>> Hi
>> Have you extracted the service pack and then run the upgrade or just
>> extracted it?
>> John
>> "frizzzdog" wrote:
>> > Thanks, but I have reapplied this sp4 with same results, also tried it
>> > on a sql 2000 dvlp ed. on xp with same results. I read something about
>> > having the services stopped prior to running the service pack so tried
>> > that too with same results after the select @.@.version command. Are
>> > there any cmd lines to force the sp upgrade?
>> >
>> > frizzzdog wrote:
>> > > Can anybody tell me when i complete the sp4 upgrade to my sql server
>> > > 2000 why when I type "select @.@.version" under sql query analyzer it
>> > > doesn't releft latest upgrade to sevice pack 4?
>> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
>> > > Aug
>> > > 2000 00:57:48
>> > > Any reply to help would be much appreciated... email:
>> > > mlajoinie@.gmail.com
>> > > -thanks
>> >
>> >
>|||Have you tried:
SELECT SERVERPROPERTY('productversion') Version,
SERVERPROPERTY ('productlevel') Level,
SERVERPROPERTY ('edition') Edition,
SERVERPROPERTY ('LicenseType') LicenseType,
SERVERPROPERTY ('Engine Edition') EngineEdition,
SERVERPROPERTY ('InstanceName') InstanceName,
SERVERPROPERTY ('IsClustered') IsClustered,
SERVERPROPERTY ('IsFullTextInstalled') IsFullTextInstalled,
SERVERPROPERTY ('IsIntegratedSecurityOnly') IsIntegratedSecurityOnly,
SERVERPROPERTY ('IsSingleUser') IsSingleUser,
SERVERPROPERTY ('IsSyncWithBackup') IsSyncWithBackup,
SERVERPROPERTY ('MachineName') MachineName,
SERVERPROPERTY ('ProcessID') ProcessID,
SERVERPROPERTY ('ServerName') ServerName|||Dan, under Microsoft SQL Server folder, isn't this where I'd see my
named instances? Running straight SQL Server 2000, not MSDE, if that
helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
sql2kasp.exe are run it afterwards), I still get the RTM return value -
not anything with reflected SP3 in return. Can I integrate SP3 into
bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
install SP3 ?
thanks, Marc
Dan Guzman wrote:
> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> independently.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> > John,
> >
> > I extracted the service pack then ran it from a saved folder with same
> > reszults from sql query. Read somewhere that the services must stopped
> > when running the service pack but only saw it once. Any more thoughts -
> > same results from the query...
> >
> > Marc
> >
> > John Bell wrote:
> >> Hi
> >>
> >> Have you extracted the service pack and then run the upgrade or just
> >> extracted it?
> >>
> >> John
> >>
> >> "frizzzdog" wrote:
> >>
> >> > Thanks, but I have reapplied this sp4 with same results, also tried it
> >> > on a sql 2000 dvlp ed. on xp with same results. I read something about
> >> > having the services stopped prior to running the service pack so tried
> >> > that too with same results after the select @.@.version command. Are
> >> > there any cmd lines to force the sp upgrade?
> >> >
> >> > frizzzdog wrote:
> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql server
> >> > > 2000 why when I type "select @.@.version" under sql query analyzer it
> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> >> > > Aug
> >> > > 2000 00:57:48
> >> > > Any reply to help would be much appreciated... email:
> >> > > mlajoinie@.gmail.com
> >> > > -thanks
> >> >
> >> >
> >|||> Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> named instances?
Yes, but only if the default installation location(s) was chosen. You can
see all installed instances from Service Manager or under the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> When I run, the SP3 package save and extract (sql2ksp3.exe then
> sql2kasp.exe are run it afterwards), I still get the RTM return value -
> not anything with reflected SP3 in return.
Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
sql2ksp3 setup will prompt you for the target instance after the EULA
dialog. Also, be sure you are connecting to that same instance when you
verify the installation. Personally, I prefer to use SELECT
SERVERPROPERTY('ProductLevel') so I don't have to remember the build
numbers.
The AS service pack (sql2kasp.exe) isn't related to the database engine
version. Also, your original post said SP4 but you now mention SP3.
Service packs are cumulative so you don't need to install both.
> Can I integrate SP3 into
> bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> install SP3 ?
Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
in about that.
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> named instances? Running straight SQL Server 2000, not MSDE, if that
> helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> sql2kasp.exe are run it afterwards), I still get the RTM return value -
> not anything with reflected SP3 in return. Can I integrate SP3 into
> bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> install SP3 ?
> thanks, Marc
> Dan Guzman wrote:
>> Do you have multiple SQL 2000 instances installed? Each must be upgraded
>> independently.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
>> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
>> > John,
>> >
>> > I extracted the service pack then ran it from a saved folder with same
>> > reszults from sql query. Read somewhere that the services must stopped
>> > when running the service pack but only saw it once. Any more thoughts -
>> > same results from the query...
>> >
>> > Marc
>> >
>> > John Bell wrote:
>> >> Hi
>> >>
>> >> Have you extracted the service pack and then run the upgrade or just
>> >> extracted it?
>> >>
>> >> John
>> >>
>> >> "frizzzdog" wrote:
>> >>
>> >> > Thanks, but I have reapplied this sp4 with same results, also tried
>> >> > it
>> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
>> >> > about
>> >> > having the services stopped prior to running the service pack so
>> >> > tried
>> >> > that too with same results after the select @.@.version command. Are
>> >> > there any cmd lines to force the sp upgrade?
>> >> >
>> >> > frizzzdog wrote:
>> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
>> >> > > server
>> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
>> >> > > it
>> >> > > doesn't releft latest upgrade to sevice pack 4?
>> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
>> >> > > X86)
>> >> > > Aug
>> >> > > 2000 00:57:48
>> >> > > Any reply to help would be much appreciated... email:
>> >> > > mlajoinie@.gmail.com
>> >> > > -thanks
>> >> >
>> >> >
>> >
>|||Dan Guzman wrote:
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances?
> Yes, but only if the default installation location(s) was chosen. You can
> see all installed instances from Service Manager or under the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> > When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return.
> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
> sql2ksp3 setup will prompt you for the target instance after the EULA
> dialog. Also, be sure you are connecting to that same instance when you
> verify the installation. Personally, I prefer to use SELECT
> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
> numbers.
> The AS service pack (sql2kasp.exe) isn't related to the database engine
> version. Also, your original post said SP4 but you now mention SP3.
> Service packs are cumulative so you don't need to install both.
> > Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
> in about that.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances? Running straight SQL Server 2000, not MSDE, if that
> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return. Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> >
> > thanks, Marc
> >
> > Dan Guzman wrote:
> >> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> >> independently.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> >> > John,
> >> >
> >> > I extracted the service pack then ran it from a saved folder with same
> >> > reszults from sql query. Read somewhere that the services must stopped
> >> > when running the service pack but only saw it once. Any more thoughts -
> >> > same results from the query...
> >> >
> >> > Marc
> >> >
> >> > John Bell wrote:
> >> >> Hi
> >> >>
> >> >> Have you extracted the service pack and then run the upgrade or just
> >> >> extracted it?
> >> >>
> >> >> John
> >> >>
> >> >> "frizzzdog" wrote:
> >> >>
> >> >> > Thanks, but I have reapplied this sp4 with same results, also tried
> >> >> > it
> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
> >> >> > about
> >> >> > having the services stopped prior to running the service pack so
> >> >> > tried
> >> >> > that too with same results after the select @.@.version command. Are
> >> >> > there any cmd lines to force the sp upgrade?
> >> >> >
> >> >> > frizzzdog wrote:
> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
> >> >> > > server
> >> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
> >> >> > > it
> >> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
> >> >> > > X86)
> >> >> > > Aug
> >> >> > > 2000 00:57:48
> >> >> > > Any reply to help would be much appreciated... email:
> >> >> > > mlajoinie@.gmail.com
> >> >> > > -thanks
> >> >> >
> >> >> >
> >> >
> >|||Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('ProductLevel') resulted in SP3 for text output -
thanks!
I think personally I was reading some other (bogus and misleading )
blogs off scroogle.org then choosing "google scraper" - this way Im not
a stat for google but rather use their engine via scroogle.org -
besides they've got some hilarious not so PC comments about big bro
google on the search engine. That is running sql2ksp.exe then
sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
just a lab I'm setting up so will stick with SP3 sorry for the
confusion.. I also wonder out loud if I have an msdn subscription but
don't see office server 2007 as a download there yet do you know if the
msdn subscriber community will be privy to this release prior to final
release later this year? Thanks again, you were very helpful and onward
to laying down the tracks to Sharepoint 2003 (via a couple of vmware
workstations).
Marc
Dan Guzman wrote:
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances?
> Yes, but only if the default installation location(s) was chosen. You can
> see all installed instances from Service Manager or under the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> > When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return.
> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
> sql2ksp3 setup will prompt you for the target instance after the EULA
> dialog. Also, be sure you are connecting to that same instance when you
> verify the installation. Personally, I prefer to use SELECT
> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
> numbers.
> The AS service pack (sql2kasp.exe) isn't related to the database engine
> version. Also, your original post said SP4 but you now mention SP3.
> Service packs are cumulative so you don't need to install both.
> > Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
> in about that.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances? Running straight SQL Server 2000, not MSDE, if that
> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return. Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> >
> > thanks, Marc
> >
> > Dan Guzman wrote:
> >> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> >> independently.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> >> > John,
> >> >
> >> > I extracted the service pack then ran it from a saved folder with same
> >> > reszults from sql query. Read somewhere that the services must stopped
> >> > when running the service pack but only saw it once. Any more thoughts -
> >> > same results from the query...
> >> >
> >> > Marc
> >> >
> >> > John Bell wrote:
> >> >> Hi
> >> >>
> >> >> Have you extracted the service pack and then run the upgrade or just
> >> >> extracted it?
> >> >>
> >> >> John
> >> >>
> >> >> "frizzzdog" wrote:
> >> >>
> >> >> > Thanks, but I have reapplied this sp4 with same results, also tried
> >> >> > it
> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
> >> >> > about
> >> >> > having the services stopped prior to running the service pack so
> >> >> > tried
> >> >> > that too with same results after the select @.@.version command. Are
> >> >> > there any cmd lines to force the sp upgrade?
> >> >> >
> >> >> > frizzzdog wrote:
> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
> >> >> > > server
> >> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
> >> >> > > it
> >> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
> >> >> > > X86)
> >> >> > > Aug
> >> >> > > 2000 00:57:48
> >> >> > > Any reply to help would be much appreciated... email:
> >> >> > > mlajoinie@.gmail.com
> >> >> > > -thanks
> >> >> >
> >> >> >
> >> >
> >|||Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('ProductLevel') resulted in SP3 for text output -
thanks!
I think personally I was reading some other (bogus and misleading )
blogs off scroogle.org then choosing "google scraper" - this way Im not
a stat for google but rather use their engine via scroogle.org -
besides they've got some hilarious not so PC comments about big bro
google on the search engine. That is running sql2ksp.exe then
sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
just a lab I'm setting up so will stick with SP3 sorry for the
confusion.. I also wonder out loud if I have an msdn subscription but
don't see office server 2007 as a download there yet do you know if the
msdn subscriber community will be privy to this release prior to final
release later this year? Thanks again, you were very helpful and onward
to laying down the tracks to Sharepoint 2003 (via a couple of vmware
workstations).
Marc
Dan Guzman wrote:
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances?
> Yes, but only if the default installation location(s) was chosen. You can
> see all installed instances from Service Manager or under the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
> > When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return.
> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
> sql2ksp3 setup will prompt you for the target instance after the EULA
> dialog. Also, be sure you are connecting to that same instance when you
> verify the installation. Personally, I prefer to use SELECT
> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
> numbers.
> The AS service pack (sql2kasp.exe) isn't related to the database engine
> version. Also, your original post said SP4 but you now mention SP3.
> Service packs are cumulative so you don't need to install both.
> > Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
> in about that.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> > named instances? Running straight SQL Server 2000, not MSDE, if that
> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
> > not anything with reflected SP3 in return. Can I integrate SP3 into
> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> > install SP3 ?
> >
> > thanks, Marc
> >
> > Dan Guzman wrote:
> >> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> >> independently.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
> >> > John,
> >> >
> >> > I extracted the service pack then ran it from a saved folder with same
> >> > reszults from sql query. Read somewhere that the services must stopped
> >> > when running the service pack but only saw it once. Any more thoughts -
> >> > same results from the query...
> >> >
> >> > Marc
> >> >
> >> > John Bell wrote:
> >> >> Hi
> >> >>
> >> >> Have you extracted the service pack and then run the upgrade or just
> >> >> extracted it?
> >> >>
> >> >> John
> >> >>
> >> >> "frizzzdog" wrote:
> >> >>
> >> >> > Thanks, but I have reapplied this sp4 with same results, also tried
> >> >> > it
> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
> >> >> > about
> >> >> > having the services stopped prior to running the service pack so
> >> >> > tried
> >> >> > that too with same results after the select @.@.version command. Are
> >> >> > there any cmd lines to force the sp upgrade?
> >> >> >
> >> >> > frizzzdog wrote:
> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
> >> >> > > server
> >> >> > > 2000 why when I type "select @.@.version" under sql query analyzer
> >> >> > > it
> >> >> > > doesn't releft latest upgrade to sevice pack 4?
> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
> >> >> > > X86)
> >> >> > > Aug
> >> >> > > 2000 00:57:48
> >> >> > > Any reply to help would be much appreciated... email:
> >> >> > > mlajoinie@.gmail.com
> >> >> > > -thanks
> >> >> >
> >> >> >
> >> >
> >|||Glad to see you got it installed.
> Sorry heard SP4 isn't for the faint of heart
That's a bit of an exaggeration, IMHO. We have SP4 installed on all of our
SQL 2000 servers plus the AWE hotfix
(http://support.microsoft.com/default.aspx?kbid=899761) and have had no
problems. Note that SP3 is no longer supported. See
http://support.microsoft.com/gp/lifesupsps#Windows
> I also wonder out loud if I have an msdn subscription but
> don't see office server 2007 as a download there yet do you know if the
> msdn subscriber community will be privy to this release prior to final
> release later this year?
I see the Office 2007 beta 2 downloads currently available on MSDN for
Grove, Project and Sharepoint server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159703063.424054.269200@.m7g2000cwm.googlegroups.com...
> Running setup.bat from the sql2ksp3 folder did the trick after a reboot
> - and running
> SELECT SERVERPROPERTY('ProductLevel') resulted in SP3 for text output -
> thanks!
> I think personally I was reading some other (bogus and misleading )
> blogs off scroogle.org then choosing "google scraper" - this way Im not
> a stat for google but rather use their engine via scroogle.org -
> besides they've got some hilarious not so PC comments about big bro
> google on the search engine. That is running sql2ksp.exe then
> sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
> just a lab I'm setting up so will stick with SP3 sorry for the
> confusion.. I also wonder out loud if I have an msdn subscription but
> don't see office server 2007 as a download there yet do you know if the
> msdn subscriber community will be privy to this release prior to final
> release later this year? Thanks again, you were very helpful and onward
> to laying down the tracks to Sharepoint 2003 (via a couple of vmware
> workstations).
> Marc
> Dan Guzman wrote:
>> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
>> > named instances?
>> Yes, but only if the default installation location(s) was chosen. You
>> can
>> see all installed instances from Service Manager or under the registry
>> key
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
>> > When I run, the SP3 package save and extract (sql2ksp3.exe then
>> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
>> > not anything with reflected SP3 in return.
>> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
>> sql2ksp3 setup will prompt you for the target instance after the EULA
>> dialog. Also, be sure you are connecting to that same instance when you
>> verify the installation. Personally, I prefer to use SELECT
>> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
>> numbers.
>> The AS service pack (sql2kasp.exe) isn't related to the database engine
>> version. Also, your original post said SP4 but you now mention SP3.
>> Service packs are cumulative so you don't need to install both.
>> > Can I integrate SP3 into
>> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
>> > install SP3 ?
>> Sorry, but I know nothing about bart's PE CD. Maybe someone else can
>> jump
>> in about that.
>>
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
>> news:1159664323.042983.24610@.k70g2000cwa.googlegroups.com...
>> > Dan, under Microsoft SQL Server folder, isn't this where I'd see my
>> > named instances? Running straight SQL Server 2000, not MSDE, if that
>> > helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
>> > sql2kasp.exe are run it afterwards), I still get the RTM return value -
>> > not anything with reflected SP3 in return. Can I integrate SP3 into
>> > bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
>> > install SP3 ?
>> >
>> > thanks, Marc
>> >
>> > Dan Guzman wrote:
>> >> Do you have multiple SQL 2000 instances installed? Each must be
>> >> upgraded
>> >> independently.
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Dan Guzman
>> >> SQL Server MVP
>> >>
>> >> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
>> >> news:1159637870.608584.51190@.m73g2000cwd.googlegroups.com...
>> >> > John,
>> >> >
>> >> > I extracted the service pack then ran it from a saved folder with
>> >> > same
>> >> > reszults from sql query. Read somewhere that the services must
>> >> > stopped
>> >> > when running the service pack but only saw it once. Any more
>> >> > thoughts -
>> >> > same results from the query...
>> >> >
>> >> > Marc
>> >> >
>> >> > John Bell wrote:
>> >> >> Hi
>> >> >>
>> >> >> Have you extracted the service pack and then run the upgrade or
>> >> >> just
>> >> >> extracted it?
>> >> >>
>> >> >> John
>> >> >>
>> >> >> "frizzzdog" wrote:
>> >> >>
>> >> >> > Thanks, but I have reapplied this sp4 with same results, also
>> >> >> > tried
>> >> >> > it
>> >> >> > on a sql 2000 dvlp ed. on xp with same results. I read something
>> >> >> > about
>> >> >> > having the services stopped prior to running the service pack so
>> >> >> > tried
>> >> >> > that too with same results after the select @.@.version command.
>> >> >> > Are
>> >> >> > there any cmd lines to force the sp upgrade?
>> >> >> >
>> >> >> > frizzzdog wrote:
>> >> >> > > Can anybody tell me when i complete the sp4 upgrade to my sql
>> >> >> > > server
>> >> >> > > 2000 why when I type "select @.@.version" under sql query
>> >> >> > > analyzer
>> >> >> > > it
>> >> >> > > doesn't releft latest upgrade to sevice pack 4?
>> >> >> > > ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel
>> >> >> > > X86)
>> >> >> > > Aug
>> >> >> > > 2000 00:57:48
>> >> >> > > Any reply to help would be much appreciated... email:
>> >> >> > > mlajoinie@.gmail.com
>> >> >> > > -thanks
>> >> >> >
>> >> >> >
>> >> >
>> >
>

Saturday, February 25, 2012

checkpoint on tempdb

checkpoint on tempdb

checkpoint on tempdb

Checkpoint not being issued

Friday, February 24, 2012

CHECKING the TRANSACTION LOG

CHECKING the TRANSACTION LOG

CHECKING the TRANSACTION LOG

Tuesday, February 14, 2012

CHECKDB found 0 allocation errors and 2 consistency errors in data

Sunday, February 12, 2012

Check version of SQL 2000 w/ select @@version

Check version of SQL 2000 w/ select @@version

Check version of SQL 2000 w/ select @@version

check sql licence

Blog Archive

About Me