so use both -W and -N switch? also, what would i see different in the file to confirm its in unicode?

Sorry. Yes BCP.

In other words, user needs to see list of conflicted dates so that he knows which new dates to put in.

Let me see if this helps. Select list of conflicted dates from the table with the new startdate or enddate or both. I am thinking of putting each condition in...

Sorry, output should be something like select from mytasklist where conflict dates exist. If no conflict dates exist, should be nothing.

Got you. Thanks Gail for the clarification.

No. Last row doesn't have status 2. I will try to shrink lil later today and see if that will reduce the size. I tried taking log backups from yesterday...

yes.there is a row with status 2.

Did the log backup, and ran the shrinkfile command for transaction log, but the size is still not getting smaller.

No. This is the first time doing it.

Ah...I thought it truncates the log as well. My drive is running out of space so I am thinking taking log bacup will shrink the size of transaction log and...

Thanks I got it working using certificate. Question though...How about linked server? If I have the proc loads records in a table in different server?

But he second db's table where the insert is going to take palce is owned by different schema.

Stupid question. Can I install SQL2012 upgrade advisor on Windows 2003 server to check for the SSIS packages compatibility?

It worked after converted inline statments to stord proc. thanks for your help.