Any error messages?

John

If you take a full backup immediately before running the log backup job, does it still fail? It's possible that someone is running a BACKUP LOG WITH TRUNCATE_ONLY or...

So please can we see DDL for the dependent tables, as well as for the foreign key constraints between them and the Product tables? Would you also be looking...

Abhijit

Surely you just create a table with an identity column, and then insert the values from your two tables into it? If this is too simplistic, then please describe...

Nayak

Try this

CREATE TABLE #Sequence (

-- Don't include hotel_name because might affect performance

-- inserting these values if you have a very large table.

-- You will want to test that this benefit...

Nayak

You've posted in the SQL Server 7,2000 forum. Please will you confirm that you are indeed using one of those platforms? If you're using SQL Server 2005 or...

OK, I may be wrong on this, and feel free to correct me if I am, but isn't an Object type variable for holding results sets? You use it...

1. Full database backups should indeed be done regularly, although they won't make any difference to this situation.

2. Whether to shrink the log depends on whether it is expected to...

What data type is your variable StartDateTime? Why are you converting it to a datetime data type and then to a string data type?

John

Well, I don't think you have any choice. Data integrity is more important than performance. Experiment with temp tables, staging tables, outer...

Or, if the duplicates are definitely all within the text file (and not duplicates of data that's already in the destination table) then you don't need a lookup - you...

I think it's your quotation marks. You need a double quote at the beginning of the expression. You also need to make sure that all of the non-numeric parameters...

Something like this?

DECLARE @test-2 TABLE (a int, b int)

insert into @test-2 values (1,2)

insert into @test-2 values (2,1)

insert into @test-2 values (3,1)

insert into @test-2 values (4,1)

insert into @test-2 values (1,4)

insert...

You need to join back to your original table to get this. Something like this (not tested because you didn't supply any table DDL or sample data):

WITH LatestJob AS...

InfiniteError (8/19/2010)

---

what happen is that it updates the row randomly using there own value. like for example the original value of ID:1 is Amount=13230 but after random updates it become...