Thanks. a lot for the responce.

We used the Alter Statement.

We have clusterd index on the Table.

we used the following query

Alterdatabase database Name with Reindex . THis was a maintainance plan that was created. We have a high amount of Data insert, updation and deletion.

Set up a Transaction Replication between Sql and DB2 . We are currently doing the same in one of our project. and it is working fine. and try using...

I have been using sp_who2 for a long time Did not notice this option. Thanks for the Answer.

Sandeep.

This is due to Kerberros Authentication Failure.

Both

Thanks 2 all the the Responce.I was right i had mentioned 'xp_restore_verifyonly' , when i replied that you can test it in ur test env he strangely told me...

Split backup would mean where the size of the db to be backedup is high and you have 3 different vol drive where you can place them .