jeff just looking for whole dates !!!

First you need to install sp1 followed by sp2 in order to full upgrade of binary files.

Burhan,

The order is not matter as long as you backup them up. Make sure you do system dbs with all the service packs upgrades.

Hope it help you

It is transactional replicaton, I did reinitialize the scrbscription, still Iam getting this error

yes I have timestamp column in the tbl

steve I'm connecting through EM

Hi Farell! Please advise how to fix above script with sample code to delete only partially rows in the table

Thanks

Thanks for your note! In below script @tablename i need to delete partially rows instead of whole row in the table. please advise me how to fix this?

DECLARE table_cursor CURSOR...

I need to delete partially rows here

- Delete the rows of this table.

SET @sql = 'DELETE FROM ' + @tablename

...

thanks for your input

logical read23456

Try using DTS Excute SQL Task in order to dump data to excel file or DTS Importor export wizard to dump the tables route.

check joins between the tables

steve.

Thanks you for your info. How to  clear data of Serial no in Equip_info tbl. I want to clear data in this tbl and set status_code column in this tbl...

You can use Import/Export Wizard of SQL server in order to import oracle data into Sql database