I has problem to run EXEC in MSDE 8.00.760

I used the MSDE 8.00.760. I try to run EXEC from the command line, but it is
not recognized as a command ... I can run the osql in the command line. Does
someone knows what is the problem?
Thanks in advance.
hi,
LittlePlane wrote:
> I used the MSDE 8.00.760. I try to run EXEC from the command line,
> but it is not recognized as a command ... I can run the osql in the
> command line. Does someone knows what is the problem?
>
AFAIK, "EXEC" only is a Transact-SQL keyword that is of course not
recognized by the underlying OS but only from applications that can send it
to a SQL Server instance...
is it a particular application?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi, thanks, I am new with SQL. I know how to do it now.
"Andrea Montanari" wrote:

> hi,
> LittlePlane wrote:
> AFAIK, "EXEC" only is a Transact-SQL keyword that is of course not
> recognized by the underlying OS but only from applications that can send it
> to a SQL Server instance...
> is it a particular application?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

I don't understand it

Dear all,
I'm executing a DTS which own a sql server task that launch a stored
procedure.
This stored procedure run a WHILE sentence and then launch a bcp command
dinamically.
Well, everything works debugging that stored procedure or simply launch it
throught Query Analyzer with its parameters.
Problem come up when I launch the DTS. That sql server task works but only
launch one time the BCP command.
I know that is very difficult reach to see the exit but...
There goes an excerpt:
set @.cont = 1
Set @.iCont = (select count(*) from tblDownloadKF_Bridge_Info)
WHILE @.cont < @.iCont + 1
begin
set @.table = (select name from tblDownloadKF_Bridge_Info where ID = @.cont)
SET @.bcpCommand= 'bcp ' + @.db + '' + @.table + ' out ' + @.strPath +
Ltrim(RTrim(@.table)) + '.dat -c -S ' + @.host + ' -U ' + @.strUser +' -P '
+
@.strPassword + ''
EXEC @.result = master.dbo.xp_cmdshell @.bcpCommand
if (@.result = 0)
set @.status = 'done'
else
set @.status = 'error'
update tblDownloadKF_Bridge_Info
set Remarks = Ltrim(Rtrim(@.status)),
dateoperation = getdate()
where ID = @.cont
set @.table = ''
set @.cont = @.cont + 1
end
GO
Is there any restriction on that command via DTS'
Thanks so much,Hi Enric,
Your problem is not the BCP command but xp_cmdshell stored procedure.
"INF: How to Run a DTS Package as a Scheduled Job"
http://support.microsoft.com/defaul...kb;en-us;269074
Cristian Lefter, SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:0C0CB603-97B8-40B0-9255-D6E3E3F245B3@.microsoft.com...
> Dear all,
> I'm executing a DTS which own a sql server task that launch a stored
> procedure.
> This stored procedure run a WHILE sentence and then launch a bcp command
> dinamically.
> Well, everything works debugging that stored procedure or simply launch it
> throught Query Analyzer with its parameters.
> Problem come up when I launch the DTS. That sql server task works but only
> launch one time the BCP command.
> I know that is very difficult reach to see the exit but...
> There goes an excerpt:
> set @.cont = 1
> Set @.iCont = (select count(*) from tblDownloadKF_Bridge_Info)
> WHILE @.cont < @.iCont + 1
> begin
> set @.table = (select name from tblDownloadKF_Bridge_Info where ID = @.cont)
>
> SET @.bcpCommand= 'bcp ' + @.db + '' + @.table + ' out ' + @.strPath +
> Ltrim(RTrim(@.table)) + '.dat -c -S ' + @.host + ' -U ' + @.strUser +' -P
> ' +
> @.strPassword + ''
> EXEC @.result = master.dbo.xp_cmdshell @.bcpCommand
> if (@.result = 0)
> set @.status = 'done'
> else
> set @.status = 'error'
> update tblDownloadKF_Bridge_Info
> set Remarks = Ltrim(Rtrim(@.status)),
> dateoperation = getdate()
> where ID = @.cont
> set @.table = ''
> set @.cont = @.cont + 1
> end
> GO
>
> Is there any restriction on that command via DTS'
> Thanks so much,

I dont know how to use storedProcedure that returns one value as a result to a VB calling

My stored procedure works perfectly when I run Query Analyser, but when I run my VB program I get the eror: I get the message : An SqlParameter with ParameterName'@.total' is not contained by this SqlParameterCollection.

Here is my stored Proc and my VB program is right below

I- Stored Proc:

CREATE PROCEDURE dbo.totalsub
@.account bigint,
@.total bigint output
AS
select total=sum(SubPhnNmbr) from tblsub whereSubAccNmbr=@.account
return
GO

II- And my pogram in VB is:

Dim totsub As Int64
Dim cm As New SqlCommand
Dim cn As New MyConnection
cn.open
'my connection is defined by me don't worry about it
cm.CommandType = CommandType.StoredProcedure
cm.CommandText = "totalsub"
cm.Connection = cn
Dim pm As SqlParameter
pm = cm.Parameters.Add(New System.Data.SqlClient.SqlParameter("@.Account", System.Data.SqlDbType.BigInt))
pm.Value = 100000165
pm = cm.Parameters.Add(New System.Data.SqlClient.SqlParameter("total", System.Data.SqlDbType.BigInt, 4))
pm.Direction = ParameterDirection.Output
totsub = cm.Parameters("total").Value
cm.ExecuteScalar()
totsub = cm.Parameters("total").Value

I also tried using @.total instead of total and I tried ParameterDirection.ReturmValue instead of ParameterDirection.Output

No Luck, someone pls can help

check the second part ofthis article.|||Thanks.

i cannot run express after i have installed it

my system meets the requirements and I have installed .net framework 2.0,

why can't i run sql express?

I tried running it from command prompt but nothing happens?

hi,

how did you "run" the SQLEXPR.EXE boostrap installer? please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx for command prompt required and supported parameters...

as regards "system requirements", be sure they are satisfied as exposed in http://msdn2.microsoft.com/en-us/library/ms143680.aspx

and just to be sure () you can have a look at http://msdn2.microsoft.com/en-us/library/ms143441.aspx as well ...

regards

i can use SQL2005 Client Tools with SQL2000?

hi
i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and run
SQL Statement?
--
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================Absolutely have been for 18 months now
--
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
> hi
> i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and
> run SQL Statement?
> --
> Best Regards
> Tark M. Siala
> Development Manager
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================>|||Definitely use Management Studio for all your databases, both SQL2005 and
SQL2000.
The only thing I think is a pain with it would be that when you generate the
script for an object, the drop statement isn't there. But it's not a
show-stopper, and you'll find that many of the features really help.
"Simon Sabin" wrote:
> Absolutely have been for 18 months now
> --
> Simon Sabin
> SQL Server MVP
> http://sqljunkies.com/weblog/simons
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
> > hi
> > i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and
> > run SQL Statement?
> > --
> > Best Regards
> >
> > Tark M. Siala
> > Development Manager
> > INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> > Mobile: +218-91-3125900
> > E-Mail: tarksiala@.icc-libya.com
> > Messenger: tarksiala@.hotmail.com
> > Web Page: http://www.icc-libya.com
> > Blog: http://spaces.msn.com/tarksiala
> > ======================================> >
>
>|||Is there an automatic completion feature ?|||SoftLion wrote:
> Is there an automatic completion feature ?
>
Do you mean Intellisense? Not built-in, but SQL Prompt (free download)
will give you that capability. Works with the 2000 client tools as well.
http://www.red-gate.com/

I am trying to schedule a job not to run on holidays in SQL server 2005.

Hi,

I want to schedule a job that runs daily but not on holidays and I am using SQL server 2005. Looking for some advice...

thanks,

Include an additional step in the job and check within a stored procedure against a vacation table (which has to be built on your own). If the job is within vacation time, throw an error with raiserror and the appropiate message. Check the status of the job step to use the "Stop executing the job after an error".

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Do you mean even in Saturdays and Sundays?

You can schedule a job to run between Monday to Friday on weekly basis, and for any additional holiday requirement you need to follow what is suggested above.

|||Thanks for replying. I will try.|||as a variation on this theme, you could set up a seperate job that disables or enables jobs depending on whether a day is holiday or not. More risky, perhaps (if it doesn't run, then X jobs are not set correctly).

I am trying to install and config MySQL ... if there is a FAQ I will read ...

Hello,

My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.

1) When I run the Config Wizard, I get the following message:

"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Suggestions please.

Kind regards, Vasya"Vasya" <vigalchin@.gmail.comwrote in message
news:1193890280.276080.101840@.d55g2000hsg.googlegr oups.com...

Quote:

Originally Posted by

Hello,

There probably is a FAQ, but this newsgroup is dedicated to Microsoft SQL
Server, so any help here will be limited.

(though I'll recommend looking at SQL Server Express 2005).

Quote:

Originally Posted by

>
My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.
>
1) When I run the Config Wizard, I get the following message:
>
"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

Yes, there is an event log. I don't have Vista so not sure if they've moved
it but on XP you can go to My Computer, right click, click on MANAGE and
drill down from there.

Quote:

Originally Posted by

>
>
2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Search and replace / with \ ?

Quote:

Originally Posted by

>
Suggestions please.
>
Kind regards, Vasya
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

I am not getting calender in front of the Date textbox.Pls Help!!!

I created a reoport using wizard.In my quesry i took two date parameters.But when i run my report i get two texboxes StartDate and EndDate.How do i get calender button in front of the text boxes.Below is my query.

SELECT dbo.tblReferralTransferStatus.RefId
FROM dbo.tblReferralTransferStatus INNER JOIN
dbo.tblDownloadTracking ON dbo.tblReferralTransferStatus.VendorId = dbo.tblDownloadTracking.VendorId AND
dbo.tblReferralTransferStatus.DateModified < dbo.tblDownloadTracking.DateModified INNER JOIN
dbo.tblVENDOR ON dbo.tblReferralTransferStatus.VendorId = dbo.tblVENDOR.VendorId
WHERE (dbo.tblVENDOR.VendorName = @.vendorname)AND (dbo.tblReferralTransferStatus.DateModified >= CAST(@.StartDate AS varchar)) AND (dbo.tblReferralTransferStatus.DateModified < CAST(@.EndDate AS varchar))

Hello,

Can you verify that your parameters are set to the DateTime data type? Open Report Parameters from the Report menu, select StartDate and EndDate and make sure the Data type is set to DateTime.

Jarret

I am getting error Subreport could not be shown

I am trying to call a subreport in master report, if i try to run the sub report individually by passing hardcoded nonqueried values in the parameters it runs fine, but when i use it as subreport in a master report, it shows the error: subreport could not be shown,

In my subreport i am using the table control to populate all fields is there something to do with table control or i am calling the subreport control in the detail pane of main report, and all main reports fields are in the group header.

Please help.

error info: from error list:

Warning 1 [rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport1’: One or more parameters required to run the report have not been specified. c:\aspnet\ccsreports2005\ccsreports2005\rptNewIssueHRT.rdl 0 0

Thank you all very much for the info.

Have you mapped the parameters in the master report to the parameters in the subreport? You do that through the properties screen of the subreport object.|||

Hi Adam,

I did mapped the parameters via parameter tab from subreport control.

My subreport is using a table control to populate all columns and there result.

If i run the sub report by itself individually, it runs fine with hardcoded values in it, but when i reference the same thru a subreport control via master report i am getting the error subreport could not be shown.

Please help is there something i am doing a mistake. and also do i need to have the subreports parameters also in master report.

Since under my master report i only have 1 parameter, thats all defined to pull it data, once that data gets in want to use those master datas value to pull the subreports data.

Master report uses stored proc which expects only one parameter, that is what i defined under parameter collection on layout of report.

Thank you very much.

|||So if your master report only has 1 parameter than how did you perform the mapping from the master report to the subreport parameters?|||

I got that error when the subreport was bigger than the textbox in which I placed it. I've also gotten the error when the datasource wasn't quite right, but it looks like you've covered that.

Hope this helps,

Don

|||

Yes, i found the problem yesterday. i am getting the parameter related columns in the dataset but did'nt place it on the report as a column since it is holding ID's in it.

after placing teh column and made it hidden true, then it is able to pull the data on subreport.

Thank you.

Hyperlink Action

When I run my report in Visual Studio and click on the hyperlink, it works
fine.
However, when I run my report via the browser after deploying it, the
hyperlinks doesn't work.
Please help!I am receiving an Internet Explorer error when clicking on the hyperlink. I
did not have this problem previously nor did I changed the report.rdl file
etc.
Line: 129
Char: 5
Error: 'event' is null or not an object
Code: 0
URL: http:://reportserv/reports/paages/report.asppx?ItemPath=%
2fDesigners_Council%2fReports%2fForm_Letter
"Terry" wrote:
> When I run my report in Visual Studio and click on the hyperlink, it works
> fine.
> However, when I run my report via the browser after deploying it, the
> hyperlinks doesn't work.
> Please help!

Hyper Threaded and dual CPU

I have a Dell sc1420 server with dual processors 3.2 ghz and hyper threaded
and run window 2003 os. the SQL server is very slow if I turn on Dual
processors and Hyper Thread (From Bios) . If I disable HyperThread and the
second CPU the SQL sever run must faster ? . I Wonder any person run into
the same problem?. Please help if you have any suggestion that I can try.
Thanks
Here a possible explanation: the Win2003 was not installed with the HT and
the Dual Processor activated in the BIOS. If you want to make change to
these settings, you have to reinstall the whole thing.
If this was the case, then maybe a Sysprep might correct the problem;
otherwise, you may have to make a full re-installation of the system.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Hung Le" <HungLe@.discussions.microsoft.com> wrote in message
news:64BDC4D5-8345-486B-86C1-36C3F578B222@.microsoft.com...
> I have a Dell sc1420 server with dual processors 3.2 ghz and hyper
> threaded
> and run window 2003 os. the SQL server is very slow if I turn on Dual
> processors and Hyper Thread (From Bios) . If I disable HyperThread and
> the
> second CPU the SQL sever run must faster ? . I Wonder any person run
> into
> the same problem?. Please help if you have any suggestion that I can try.
> Thanks

Hyper Threaded and dual CPU

I have a Dell sc1420 server with dual processors 3.2 ghz and hyper threaded
and run window 2003 os. the SQL server is very slow if I turn on Dual
processors and Hyper Thread (From Bios) . If I disable HyperThread and the
second CPU the SQL sever run must faster ? . I Wonder any person run into
the same problem?. Please help if you have any suggestion that I can try.
ThanksHere a possible explanation: the Win2003 was not installed with the HT and
the Dual Processor activated in the BIOS. If you want to make change to
these settings, you have to reinstall the whole thing.
If this was the case, then maybe a Sysprep might correct the problem;
otherwise, you may have to make a full re-installation of the system.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Hung Le" <HungLe@.discussions.microsoft.com> wrote in message
news:64BDC4D5-8345-486B-86C1-36C3F578B222@.microsoft.com...
> I have a Dell sc1420 server with dual processors 3.2 ghz and hyper
> threaded
> and run window 2003 os. the SQL server is very slow if I turn on Dual
> processors and Hyper Thread (From Bios) . If I disable HyperThread and
> the
> second CPU the SQL sever run must faster ? . I Wonder any person run
> into
> the same problem?. Please help if you have any suggestion that I can try.
> Thanks

Hyper Threaded and dual CPU

I have a Dell sc1420 server with dual processors 3.2 ghz and hyper threaded
and run window 2003 os. the SQL server is very slow if I turn on Dual
processors and Hyper Thread (From Bios) . If I disable HyperThread and the
second CPU the SQL sever run must faster ? . I Wonder any person run into
the same problem?. Please help if you have any suggestion that I can try.
ThanksHere a possible explanation: the Win2003 was not installed with the HT and
the Dual Processor activated in the BIOS. If you want to make change to
these settings, you have to reinstall the whole thing.
If this was the case, then maybe a Sysprep might correct the problem;
otherwise, you may have to make a full re-installation of the system.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Hung Le" <HungLe@.discussions.microsoft.com> wrote in message
news:64BDC4D5-8345-486B-86C1-36C3F578B222@.microsoft.com...
> I have a Dell sc1420 server with dual processors 3.2 ghz and hyper
> threaded
> and run window 2003 os. the SQL server is very slow if I turn on Dual
> processors and Hyper Thread (From Bios) . If I disable HyperThread and
> the
> second CPU the SQL sever run must faster ? . I Wonder any person run
> into
> the same problem?. Please help if you have any suggestion that I can try.
> Thanks

HW question to run SqlServer 2k

I believe I am very lucky to come into getting an old server from my work.
However, I do have a question I hoped the gurus here could help me out with.
I currently run SQL Server on a desktop calibre box. It is a P3 650Mhz with
192MB and a 10GB HD. This server does double duty as my mail server.
Unfortunately the memory is quite low on this box. :< I'm not too worried
about that as the machine is more of a training box (for me :>) more than
anything.
The new server I got is a P3 350Mhx dual Xeon, with 1GB RAM and six SCSI
RAID 9GB HD. The processor speed is much lower, but it's a dual Xeon and it
has the memory I love.
I'm wondering if I'm indeed very lucky to come into this server, or if I
thought take out the 1GB RAM and put that into my existing server (assuming
I can do that?). I'm new to RAID, SCSI, and Xeon processors. What do the
gurus think about running SQL Server on a box like this? Am I going to get
the same or better performance than on my existing box?
Thank you for any and all comments! :>
PS The box is for my own personal db and email server at home, but I do run
a few websites on it which I would like acceptable performance.
"Flip" <[remove_me]phenry_w@.hotmail.com> wrote in message
news:%23W$w6zoGFHA.3648@.TK2MSFTNGP09.phx.gbl...
> I currently run SQL Server on a desktop calibre box. It is a P3 650Mhz
with
> 192MB and a 10GB HD. This server does double duty as my mail server.
> Unfortunately the memory is quite low on this box. :< I'm not too worried
> about that as the machine is more of a training box (for me :>) more than
> anything.
> The new server I got is a P3 350Mhx dual Xeon, with 1GB RAM and six SCSI
> RAID 9GB HD. The processor speed is much lower, but it's a dual Xeon and
it
> has the memory I love.
> I'm wondering if I'm indeed very lucky to come into this server, or if I
> thought take out the 1GB RAM and put that into my existing server
(assuming
> I can do that?).
Move the 1GB of memory to the P3 650Mhz? If so, compatibility would depend
on the speed of the memory in both computers.

> I'm new to RAID, SCSI, and Xeon processors. What do the
> gurus think about running SQL Server on a box like this? Am I going to
get
> the same or better performance than on my existing box?
You did not mention which operating system you are running on either device?
Performance should be generally better on the dual XEON processor with 1GB
memory.

> PS The box is for my own personal db and email server at home, but I do
run
> a few websites on it which I would like acceptable performance.
You should be fine with the dual processor machine, RAID gives you fault
tolerance if you loose a drive, so that is an advantage.
Steve
|||re forgot to mention the OS?
Sorry 'bout that, w2k3server with all the patches. I was going to joke
about runnig linux, but I pitched that and "upgraded" a while ago! :> I
broke into the "linux boys club" but didn't like the camaraderie. :< The MS
group seems to be (in general) MUCH more helpful and accepting than the
linux/unix crowd. I konw, I know that's a wide sweeping statement but
that's been my experience with seeking help/assistance/suggestions from
those newsgroups/magazines/etc. :<
re RAID
I was looking forward to the low cost disk space increase too!:>
re should be fine with it
Thank you for your suggestion! :>
Have a good one! :>

HW question to run SqlServer 2k

I believe I am very lucky to come into getting an old server from my work.
However, I do have a question I hoped the gurus here could help me out with.
I currently run SQL Server on a desktop calibre box. It is a P3 650Mhz with
192MB and a 10GB HD. This server does double duty as my mail server.
Unfortunately the memory is quite low on this box. :< I'm not too worried
about that as the machine is more of a training box (for me :>) more than
anything.
The new server I got is a P3 350Mhx dual Xeon, with 1GB RAM and six SCSI
RAID 9GB HD. The processor speed is much lower, but it's a dual Xeon and it
has the memory I love.
I'm wondering if I'm indeed very lucky to come into this server, or if I
thought take out the 1GB RAM and put that into my existing server (assuming
I can do that?). I'm new to RAID, SCSI, and Xeon processors. What do the
gurus think about running SQL Server on a box like this? Am I going to get
the same or better performance than on my existing box?
Thank you for any and all comments! :>
PS The box is for my own personal db and email server at home, but I do run
a few websites on it which I would like acceptable performance."Flip" <[remove_me]phenry_w@.hotmail.com> wrote in message
news:%23W$w6zoGFHA.3648@.TK2MSFTNGP09.phx.gbl...
> I currently run SQL Server on a desktop calibre box. It is a P3 650Mhz
with
> 192MB and a 10GB HD. This server does double duty as my mail server.
> Unfortunately the memory is quite low on this box. :< I'm not too worried
> about that as the machine is more of a training box (for me :>) more than
> anything.
> The new server I got is a P3 350Mhx dual Xeon, with 1GB RAM and six SCSI
> RAID 9GB HD. The processor speed is much lower, but it's a dual Xeon and
it
> has the memory I love.
> I'm wondering if I'm indeed very lucky to come into this server, or if I
> thought take out the 1GB RAM and put that into my existing server
(assuming
> I can do that?).
Move the 1GB of memory to the P3 650Mhz? If so, compatibility would depend
on the speed of the memory in both computers.
> I'm new to RAID, SCSI, and Xeon processors. What do the
> gurus think about running SQL Server on a box like this? Am I going to
get
> the same or better performance than on my existing box?
You did not mention which operating system you are running on either device?
Performance should be generally better on the dual XEON processor with 1GB
memory.
> PS The box is for my own personal db and email server at home, but I do
run
> a few websites on it which I would like acceptable performance.
You should be fine with the dual processor machine, RAID gives you fault
tolerance if you loose a drive, so that is an advantage.
Steve|||re forgot to mention the OS?
Sorry 'bout that, w2k3server with all the patches. I was going to joke
about runnig linux, but I pitched that and "upgraded" a while ago! :> I
broke into the "linux boys club" but didn't like the camaraderie. :< The MS
group seems to be (in general) MUCH more helpful and accepting than the
linux/unix crowd. I konw, I know that's a wide sweeping statement but
that's been my experience with seeking help/assistance/suggestions from
those newsgroups/magazines/etc. :<
re RAID
I was looking forward to the low cost disk space increase too!:>
re should be fine with it
Thank you for your suggestion! :>
Have a good one! :>

HW question to run SqlServer 2k

I believe I am very lucky to come into getting an old server from my work.
However, I do have a question I hoped the gurus here could help me out with.
I currently run SQL Server on a desktop calibre box. It is a P3 650Mhz with
192MB and a 10GB HD. This server does double duty as my mail server.
Unfortunately the memory is quite low on this box. :< I'm not too worried
about that as the machine is more of a training box (for me :> ) more than
anything.
The new server I got is a P3 350Mhx dual Xeon, with 1GB RAM and six SCSI
RAID 9GB HD. The processor speed is much lower, but it's a dual Xeon and it
has the memory I love.
I'm wondering if I'm indeed very lucky to come into this server, or if I
thought take out the 1GB RAM and put that into my existing server (assuming
I can do that?). I'm new to RAID, SCSI, and Xeon processors. What do the
gurus think about running SQL Server on a box like this? Am I going to get
the same or better performance than on my existing box?
Thank you for any and all comments! :>
PS The box is for my own personal db and email server at home, but I do run
a few websites on it which I would like acceptable performance."Flip" <[remove_me]phenry_w@.hotmail.com> wrote in message
news:%23W$w6zoGFHA.3648@.TK2MSFTNGP09.phx.gbl...
> I currently run SQL Server on a desktop calibre box. It is a P3 650Mhz
with
> 192MB and a 10GB HD. This server does double duty as my mail server.
> Unfortunately the memory is quite low on this box. :< I'm not too worried
> about that as the machine is more of a training box (for me :> ) more than
> anything.
> The new server I got is a P3 350Mhx dual Xeon, with 1GB RAM and six SCSI
> RAID 9GB HD. The processor speed is much lower, but it's a dual Xeon and
it
> has the memory I love.
> I'm wondering if I'm indeed very lucky to come into this server, or if I
> thought take out the 1GB RAM and put that into my existing server
(assuming
> I can do that?).
Move the 1GB of memory to the P3 650Mhz? If so, compatibility would depend
on the speed of the memory in both computers.

> I'm new to RAID, SCSI, and Xeon processors. What do the
> gurus think about running SQL Server on a box like this? Am I going to
get
> the same or better performance than on my existing box?
You did not mention which operating system you are running on either device?
Performance should be generally better on the dual XEON processor with 1GB
memory.

> PS The box is for my own personal db and email server at home, but I do
run
> a few websites on it which I would like acceptable performance.
You should be fine with the dual processor machine, RAID gives you fault
tolerance if you loose a drive, so that is an advantage.
Steve|||re forgot to mention the OS?
Sorry 'bout that, w2k3server with all the patches. I was going to joke
about runnig linux, but I pitched that and "upgraded" a while ago! :> I
broke into the "linux boys club" but didn't like the camaraderie. :< The MS
group seems to be (in general) MUCH more helpful and accepting than the
linux/unix crowd. I konw, I know that's a wide sweeping statement but
that's been my experience with seeking help/assistance/suggestions from
those newsgroups/magazines/etc. :<
re RAID
I was looking forward to the low cost disk space increase too!:>
re should be fine with it
Thank you for your suggestion! :>
Have a good one! :>