Thanks a lot for all your valuable inputs.

Now, creating a table with new structure, dumping the data and renaming the table is the only option!!!.

M getting incorrect syntax error. and m asked to insert this column in between existing columns.

thanks winslet.

let me try those options.

Thanks for the reply.

It is a Test server.

M using Local System account in both instances (SQL Server services) .

My System Account is Administrator.

i connected both instances with windows login.

Standard Edition...

i have tried with FQDN and

SP2 also has been installed and tried.

getting the same error.

both instances are having same account - local system.

Thank you SQL Expertise..

i tried Mirroring failover to verify the data is updated in mirrored database.

it has come:-)

Thanks for the replies...

let me try to do fail over mirroring....

Thank you once again...

Regards,

Chandhini

Thanks a lot.

let me try these option.

Hi,

Fragmentation will occur if physical and logical order are different..

but there is a confusion, what exactly are we referring physical order and logical order?

My understand of them,

Physical Order : Contiguous...

Thanks a lot for your responses.

i thought it consumes memory so that we can get rid of them.

Thanks.

Thanks a lot Lowell

Let me try this .

Thanks Roy. Thanks a lot....

Regards,

Ramani

Very nice article. it is very clear..

Tempdb will go like anything because of row versioning also.. so is there anyway to remove old row versioning data from tempdb or sql...

i need to implement optimistic isolation level according to my requirement.

To avoid update conflict scenario when i use optimistic isolation level,

1. either updlock should be implemented with select stmt for...

Thank you.

Regards,

Ramani