Asking for Strong SA password while installing!

Hi,
When I tried to install MSDE2000A in my WindowXP home edition,its asking for Strong SA passowrd and exiting from the setup?can anyone pls help me in this!!!!
Read the documentation files that came with MSDE 2000 - especially the part
about the command line parameters and their meaning. While you're at it
download the SQL Server Book Online from
http://www.microsoft.com/sql/techinf...2000/books.asp
Jim
"Sai" <anonymous@.discussions.microsoft.com> wrote in message
news:1E6CDC02-CADD-4221-AD5B-2592643954EF@.microsoft.com...
> Hi,
> When I tried to install MSDE2000A in my WindowXP home edition,its asking
for Strong SA passowrd and exiting from the setup?can anyone pls help me
in this!!!!
>
|||install from the command line
c:\msderila
setup SAPWD=yourstrongpassword <enter>
sql

Ask for Recomendation

Dear All,
Pls take a look at the attached picture.
Drive E, F and G -> Raid 5
Drive C and D -> Simple Partition
My Question:
1. Where should to place the MDF dan LDF file?
2. Is it necessary to have multiple filegroup since I use RAID5?
Thanks
Robert LieIf you are heading for performance and not safety there is a simple rule
Raid 5 bad, Raid 10 good.
But now your stuck in, i would lay them on separate disk (There is not much
place there left, based on the value of the picture, and you didnt give any
db value,so you have to decide it.)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:OBB%23J58SFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Pls take a look at the attached picture.
> Drive E, F and G -> Raid 5
> Drive C and D -> Simple Partition
> My Question:
> 1. Where should to place the MDF dan LDF file?
> 2. Is it necessary to have multiple filegroup since I use RAID5?
> Thanks
> Robert Lie
>|||Robert
If your goal is performance you should place.MDF and .LDF files on different
physical disk
As Jens has mentioned RAID-5 is 'bad' for writes and 'good' for reads. You
will have to determine whether your OLTP is heavily writing or reading and
then to make a decision
It would be good if you place your LOG file on mirrored disk array RAID-1&0
because the write activity tends to be sequential and is synchronous.
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:OBB%23J58SFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Pls take a look at the attached picture.
> Drive E, F and G -> Raid 5
> Drive C and D -> Simple Partition
> My Question:
> 1. Where should to place the MDF dan LDF file?
> 2. Is it necessary to have multiple filegroup since I use RAID5?
> Thanks
> Robert Lie
>

Ask for Recomendation

Dear All,
Pls take a look at the attached picture.
Drive E, F and G -> Raid 5
Drive C and D -> Simple Partition
My Question:
1. Where should to place the MDF dan LDF file?
2. Is it necessary to have multiple filegroup since I use RAID5?
Thanks
Robert Lie
If you are heading for performance and not safety there is a simple rule
Raid 5 bad, Raid 10 good.
But now your stuck in, i would lay them on separate disk (There is not much
place there left, based on the value of the picture, and you didnt give any
db value,so you have to decide it.)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:OBB%23J58SFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Pls take a look at the attached picture.
> Drive E, F and G -> Raid 5
> Drive C and D -> Simple Partition
> My Question:
> 1. Where should to place the MDF dan LDF file?
> 2. Is it necessary to have multiple filegroup since I use RAID5?
> Thanks
> Robert Lie
>
|||Robert
If your goal is performance you should place.MDF and .LDF files on different
physical disk
As Jens has mentioned RAID-5 is 'bad' for writes and 'good' for reads. You
will have to determine whether your OLTP is heavily writing or reading and
then to make a decision
It would be good if you place your LOG file on mirrored disk array RAID-1&0
because the write activity tends to be sequential and is synchronous.
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:OBB%23J58SFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Pls take a look at the attached picture.
> Drive E, F and G -> Raid 5
> Drive C and D -> Simple Partition
> My Question:
> 1. Where should to place the MDF dan LDF file?
> 2. Is it necessary to have multiple filegroup since I use RAID5?
> Thanks
> Robert Lie
>

Articles on foreach loop container over dataflow task?

Hi everyone,

do you know any articles on foreach loop container that loops over a dataflow task...pls tell me....

thanks in advance,

Praveen Dayanithi wrote:

Hi everyone,

do you know any articles on foreach loop container that loops over a dataflow task...pls tell me....

thanks in advance,

I presume that you mean a ForEach loop that contains a data flow.

Enumerating files in a Foreach loop
(http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx)

-Jamie

|||

Hi,

Thanks Jamie...

But i was looking for articles that involves foreach loop container that has a data flow task...

By saying dataflow task i mean i am goin to loop around all the records in the recordset of the dataflow task.

or you can tell me how to solve this issue....

I need to fetch data from table 2 for every record from the recordset which is mergejoin resultset of table1 and table2.

Thanks in advance,