iF YOU WANT TO UDATE THE FIELDS IN THE ORACLE TABLE WITH THE VALUES FROM THE SQL SERVER TABLES THEN YOU CAN TRY DOING IT THROUGH LINKED SERVERS IN SQLSERVER...

Hi,

In the sysperfinfo table there is a value  Transactions/sec in the column counter_type. So you would need to probably check the cntr_value corresponding to this row. you would need to...

HI ZOUL,

THE @@IDENTITY WOULD PROBABLY NOT WORK WITH SELECT. ITS WORKS WITH INSERT, SELECT INTO AND BULK COPY STATEMENTS.

TRY USING "IF EXISTS" TO CHECK WHETHER THE RECORD IS THERE OR...

Hi Jonathan

you were right. I cannot remove the identity. I need to drop and recreate the table without the identity.

Thanks

Thanks Jonathan,

But i removed the identity using ALTER TABLE ALTER COLUMS statement, by redifining the column without the identity

Cheers

Vikram:-)