Error when limiting memory usage with OSQL.EXE

When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go

Reply in group, but if emailing add another
zero, and remove the last word.
I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.

Reply in group, but if emailing add another
zero, and remove the last word.

Error when limiting memory usage with OSQL.EXE

When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go

Reply in group, but if emailing add another
zero, and remove the last word.
I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.

Reply in group, but if emailing add another
zero, and remove the last word.

Error when limiting memory usage with OSQL.EXE

When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
Reply in group, but if emailing add another
zero, and remove the last word.I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
--
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/.../1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Your advanced options are already set to 1 (enabled).
Now run the second set and you should be fine.
I don't see an error. I would also recommend using 100 instead of 70.
Claus
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.

Error when limiting memory usage with OSQL.EXE

When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
--
Reply in group, but if emailing add another
zero, and remove the last word.I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
--
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Your advanced options are already set to 1 (enabled).
Now run the second set and you should be fine.
I don't see an error. I would also recommend using 100 instead of 70.
--
Claus
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
>> Configuration option 'show advanced options' changed from 1 to 1.
>> Run the RECONFIGURE statement to install.
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.sql

Error when installing

i'm trying to install MS server 2000 components and I continuously get the same error. "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup." I've rebooted 100 times, turned the machine on and off, installed other programs, etc. and stil I get the error ONLY when I try to install the components.

Please Help!!!!

Thanks.

Moved to the setup group for a better chance of a response.|||

try...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q290/9/91.asp&NoWebContent=1

|||

Hi, this should help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312995

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

sql

Error when installing

i'm trying to install MS server 2000 components and I continuously get the same error. "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup." I've rebooted 100 times, turned the machine on and off, installed other programs, etc. and stil I get the error ONLY when I try to install the components.

Please Help!!!!

Thanks.

Moved to the setup group for a better chance of a response.|||

try...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q290/9/91.asp&NoWebContent=1

|||

Hi, this should help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312995

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Error when I try to copy components and tasks

Hi everyone,

Everything's fine or I think so but when I try to copy/cut components to another SSIS of to own.

I get this error:

Error al copiar objetos. El Dise?ador SSIS no pudo serializar los objetos de tiempo de ejecución de SSIS.

No se pudo copiar el objeto 'Tarea Secuencia de comandos ActiveX' al Portapapeles.

(Microsoft.DataTransformationServices.Design)

Tranlasted into English (more or less):

Error copying objetcts. SSIS designer was not able to serialize run-time SSIS objects

ActiveX Script task was not copied to clipboard

NOTE: this behaviour doesn't happen in the own server only from client (xp pros sp2). Nothing has been changed I don't know if install again or not.

Any help will be welcomed.

I thought it maybe something to do with the ActiveX Script Task since it is legacy, but that is rubbish. Not much help, but it seems to be something not right with your local installation.|||

Thanks Darren.

I suppose that for Integration Services' Microsoft developers keep up old COM schemes is a hell in a certain way.

I try to imagine Sql25k without any dependencies...

By the moment, I'll follow working via TS.

|||

Darren,

How odd! It happens with any component not only with VbScript task.

?

Error starting svc at end of install

I get this error right at the end of installing the server
components.
Product: Microsoft SQL Server 2000 Reporting Services
Developer Edition -- Error 1920. Service 'ReportServer'
(ReportServer) failed to start. Verify that you have
sufficient privileges to start system services.
I am logged in as Administrator. It then decides to
rollback the install. My machine is Win2k2003 with IIS6.
Any ideas?
Thanks,
DaveOk, so i did a complete uninstall and reinstall and it
works. I guess if you do a client only install and then
try to install the service components you don't get any
prompts to select which account the reportservice runs
under.
>--Original Message--
>I get this error right at the end of installing the
server
>components.
>Product: Microsoft SQL Server 2000 Reporting Services
>Developer Edition -- Error 1920. Service 'ReportServer'
>(ReportServer) failed to start. Verify that you have
>sufficient privileges to start system services.
>I am logged in as Administrator. It then decides to
>rollback the install. My machine is Win2k2003 with IIS6.
>Any ideas?
>Thanks,
>Dave
>.
>

Error SQL server 2005 installing

first I installed SQL 2005 beta 2 the I uninstall it , but still I receive this error msg:

SQL Server 2005 setup has detected incompatible components from beta version of visual studio, .Net Framework , or SQL server 2005 .

is there any suggestion to solve this problem

thanks for your reply

no one knows ,,

or no one care , I wonder what's the porpose of this forum

|||If you first installed beta products you have to clean your system from all installed version of the beta software, client tools, .NET framework, SNAC, SQL Server etc. There is a uninstall software which cleans the installation, it can be downloaded here:

http://lab.msdn.microsoft.com/vs2005/uninstall/preRTMuninstall/default.aspx
http://lab.msdn.microsoft.com/vs2005/uninstall/default.aspx

HTH, jens Suessmeyer.

http://www.sqlserver2005.de