can you post your table DDL?

that insert will work 2008 as well

The way I would do it would be to use a staging table on your destination server to stage the 1 millions updated rows and then do the update via...

if that table is as stated with the date columns as datetime then that insert should work,

any chance there is a trigger on the table?

its a connection to the sql server object library, you can't select data from it like you would an OLEDB connection, you can only select objects.

Underneath i think it...

why don't they write a procedure to restore log backups ?

also you can also t-log backup can be done with diff backups so they wouldn;t be losing anything if...

mw112009 (9/26/2011)

---

I kind of expected that someone would help me how to use the

"Trasnfer SQl Server Objects Task" component.

This might be the best way to get around the issue.

The...

if you are interested in Nano seconds.

then use;

select SYSDATETIME()

mw112009 (9/26/2011)

---

Not clear what you are saying ?

Are you telling me a variable can handle more lines of code ?

1.)So then put the stored proc inside the variable ?

2.)Asign the...

are you also doing some form of caching in the web server?

put the stored proc into a procedure and then use the variable in the task

Get your backup car out of the garage and drive that..

problem...

can you let us know a bit more about the problem, because you say you want truncated data back, and then you say your db is...

do you have a backup?

you need to answer this in order for us to really help.

you could setup your SSIS packages to do an incremental load based upon a create/modified date in the source, and then from there use either an update transformation or...

prakash 67108 (9/26/2011)

---

Hi,

Whats the difference between delete and truncate then..?

i hope this is the difference...i have read at some where that

restoring the data back is possible if we truncate the...