AWE Hotfix - SQLServer.exe \ OSQL.exe Versions

Hi,
I see that after the AWE hot fix in our production server [Not the standard
microsoft recommended MSI way, only the SQLServer.exe and OSQL.exe are
replaced] the following are the versions of each component.
osql.exe , 2000.80.1025.0, 16-May-2005 6:51:12PM
sqlservr.exe , 2000.80.2040.0, 13-May-2005 9:11:46PM
I do not know why the OSQL version chosen is 2000.80.1025.0 instead of
2000.80.2039.0?
Does any has any support documentation which tells that we need to have the
SQLServer\OSQL versions 2000.80.2040.0\2000.80.1025.0 respectively? I feel
that the current combination is wrong and it should be
2000.80.2040.0\2000.80.2039.0. [I have installed the AWE in the standard way
in server and noticed that SQLServer\OSQL versions are
2000.80.2040.0\2000.80.2039.0].
TIA,
Manoj
I have to ask. Why would you NOT use the hotfix installer and hand-patch
the binaries?
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
news:13955C6A-8D22-4A6A-BCAD-EBDA006FF26D@.microsoft.com...
> Hi,
> I see that after the AWE hot fix in our production server [Not the
> standard
> microsoft recommended MSI way, only the SQLServer.exe and OSQL.exe are
> replaced] the following are the versions of each component.
> osql.exe , 2000.80.1025.0, 16-May-2005 6:51:12PM
> sqlservr.exe , 2000.80.2040.0, 13-May-2005 9:11:46PM
> I do not know why the OSQL version chosen is 2000.80.1025.0 instead of
> 2000.80.2039.0?
> Does any has any support documentation which tells that we need to have
> the
> SQLServer\OSQL versions 2000.80.2040.0\2000.80.1025.0 respectively? I
> feel
> that the current combination is wrong and it should be
> 2000.80.2040.0\2000.80.2039.0. [I have installed the AWE in the standard
> way
> in server and noticed that SQLServer\OSQL versions are
> 2000.80.2040.0\2000.80.2039.0].
>
> TIA,
> Manoj
>

AWE enabled

Hi, please let me know if I enable AWE and PAE and turn on /3 GB switch, why
can't I see sqlserver.exe or total/target server memory more that 2.72 GB?
Event though there is a page/sec goes upto 6000. Server must need memory more
than 3 GB. My email address is : atiqur_rahman02@.yahoo.com or you can paste
here. Thanks for your help!
How much memory does your server machine have? What is the version and
edition of the operating system and SQL Server you are using?
Anith

Autostart MS Agent on Win98/Me

Hello,
does anyone know how I could autostart the MSAgent on Win98/Me with a
named instance.
I try with
scm.exe -Action 1 -Service SQLAgent$$" & str_InstanceName
where str_InstanceName is the name of the MSDE Instance.
The password is correct (I exported the crypted password from a computer
with Entreprise manager and the agent start with WinNT...
It can also start manually.
On Winnt, 2K and XP, all is fine, on Win98/Me, I receive the message
Service operation has been completed successfully but the agent did not
start. I can manually start the agent with the MSDE service manager, but
if my custommer forget it then he has no automatic backup of his database.
Thank you
Marc Allard
Allcomp
If you really rely on SQL Server Agent being started and you have not a lot
of control over the machine, start SQL Server Agent from within SQL Server:
-- Create a procedure to start SQL Server Agent
USE master
GO
CREATE PROC usp_start_sqlserveragent
AS
EXEC master..xp_cmdshell 'net start SQLServerAgent'
GO
-- Mark stored procedure to run on SQL Server start
EXEC sp_procoption 'usp_start_sqlserveragent', 'startup', 'true'
Jacco Schalkwijk
SQL Server MVP
"Allcomp" <marc@.nospam.allcomp.be> wrote in message
news:41e279f2$0$2676$ba620e4c@.news.skynet.be...
> Hello,
> does anyone know how I could autostart the MSAgent on Win98/Me with a
> named instance.
> I try with
> scm.exe -Action 1 -Service SQLAgent$$" & str_InstanceName
> where str_InstanceName is the name of the MSDE Instance.
> The password is correct (I exported the crypted password from a computer
> with Entreprise manager and the agent start with WinNT...
> It can also start manually.
> On Winnt, 2K and XP, all is fine, on Win98/Me, I receive the message
> Service operation has been completed successfully but the agent did not
> start. I can manually start the agent with the MSDE service manager, but
> if my custommer forget it then he has no automatic backup of his database.
>
> Thank you
> Marc Allard
> Allcomp
|||That will never work on Windows 9x based OS's since there is no concept of a
real service which gets started with NET START. Only Windows NT based OS's
(and OS/2) have NET START.
You can use SCM.EXE instead
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:eU1Ed3y9EHA.2876@.TK2MSFTNGP12.phx.gbl...
> If you really rely on SQL Server Agent being started and you have not a
> lot of control over the machine, start SQL Server Agent from within SQL
> Server:
> -- Create a procedure to start SQL Server Agent
> USE master
> GO
> CREATE PROC usp_start_sqlserveragent
> AS
> EXEC master..xp_cmdshell 'net start SQLServerAgent'
> GO
> -- Mark stored procedure to run on SQL Server start
> EXEC sp_procoption 'usp_start_sqlserveragent', 'startup', 'true'
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Allcomp" <marc@.nospam.allcomp.be> wrote in message
> news:41e279f2$0$2676$ba620e4c@.news.skynet.be...
>
|||Right. Seems Win9x is a bit too long ago for me. I better not answer any
more questions that involve Win 9x
Jacco Schalkwijk
SQL Server MVP
"Gert E.R. Drapers" <GertD@.SQLDev.Net> wrote in message
news:eyuMfi09EHA.1544@.TK2MSFTNGP11.phx.gbl...
> That will never work on Windows 9x based OS's since there is no concept of
> a real service which gets started with NET START. Only Windows NT based
> OS's (and OS/2) have NET START.
> You can use SCM.EXE instead
> GertD@.SQLDev.Net
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> You assume all risk for your use.
> Copyright SQLDev.Net 1991-2004 All rights reserved.
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
> wrote in message news:eU1Ed3y9EHA.2876@.TK2MSFTNGP12.phx.gbl...
>
|||Hello,
Thank you for your answers, but I already try to start the agent with
scm, but it doesn't start. If I start it manually with SQL Server
Service Manager, then it is working.
Is there something to do an automatic backup without the agent?
Thank you
Marc Allard
Allcomp
Jacco Schalkwijk wrote:
> Right. Seems Win9x is a bit too long ago for me. I better not answer any
> more questions that involve Win 9x
>