I have seen this when working with SSMS and connecting to SQL 2000 Servers mostly, with other SQL 2005 Servers it would be normal.

What is the issue you want to...

Glad I could hep.. 🙂

When you insert into the table_new, the values in the CreationDateTime will be inserted into the New Column (ScanDateTime), Default GetDate() would be used when the column value is not...

Use the script.

-- Create the New table first

CREATE TABLE [ItemLocationHistory_New](

[IdItemLocationHistory] [uniqueidentifier] NOT NULL,

[IdItemLocation] [int]...

Ian has a good point.

The problem the OP is trying to solve is an upgrade from SQL 2000 to 2005. The OP has a concern that the data has to...

Do you need new column to be at the end of the table (last column) or beside the CreationDateTime Column ?

Couldn't ask last time since I did not have the...

I would not suggest trigger for this.

Never been in this situation, but I have solution ready.

Post the create table script here, I shall reply with completed script that you can...

Silverfox (11/26/2009)

I wont be on the forums much, from now on for a while, Just been told my last working day is tomorrow, So looking for a new contract. Hard...

Would be glad, I shall let you know when I post it.

Thanks,

You can suggest something..

I am planning to introduce few more sections adding a section each month.

Coming backto this thread, the OP posted the thread in DTS, hence expecting it...

Not sure, whether the OP was using SQL 2000 or 2005 ?

sqlserver12345 (11/25/2009)

---

How do I Run a SSIS package using a stored procedure which runs every 1 hr (using a job in sql enterprise manager ) or without using the job...

Post here when you have an update.

Happy Thanksgiving

That was right, not a big riddle. When compared to forum questions from a newbie asking for a query help without any clue...

I don't remember when was the last time I...