Yes the word unit will be repeated in each and every line and it will be termed as new line

GSquared thanks for the reply, but can you be more specific.

You mean to say that

If I have a table A, that has a primary key which is not being referenced...

But if I insert into V, will it be inserted into A too

Omhoge, this is the reply to your question.

I too did one SSIS, and had such a problem

But I deleted the catch block which i wrote in the sp and that...

Can I retrieve from the log file, if yes then how

Just try to comment out the lines begin transaction and commit transaction and just give a try.

Thanks for the reply Kishore.

i am using sql server 2005. I have not given any rollback or commit Neither do I have any triggers.

Just deleted some 100 records by mistake

What...

Thank you Grant and Pradeep

Chris Harshman (9/27/2008)

---

OK, so we have new information, I didn't realize before you were doing bulk loads every minute. How are your disks setup, RAID level etc. How...

First of all many thanks for the reply

I am inserting bulk records every minute, infact even less than that.

I wont be inserting million records per minute but i am inserting...

Neel thanks for the reply but, I cant create indexes, otherwise it would be too slow,

Moreover I will have to delete and create indexes whenever I have to do modifications.

There...

Thanks all for the reply.

Infact we dont have any indexes at all, Secondly both the files ldf and mdf are in the same drive.

In such circumstances what should we do?

I would like to clarify my question once again,

We have a plenty(around 20 lakhs) of records getting inserted into the table and also we move the records from the...

I think I have not framed my question properly,

We do bulkinsert only, but now while checking reports from our web application, the time taken is more, or if we write...

Thanks Mark for your reply.

Checked out. It works.

Regards

Hemalatha