Thanks for all replies.

Unfortunately this is a live enviroment so its not possible to take db offline and bring it back.

Thanks for all replies

I am sorry for the late reply my windows crashed and i had to reinistall everything :(.

i ran dbcc opentran and nothing came up , anything else to check or...

Thanks for ur reply

The thing i am confused about is that application has finished loading data already and function using this SQL has finished execution , why is the process...

Thanks John

Thanks for u too SQLFrenzy

Thanks Gail

ur replies were very helpfull.

i ran dbcc opentran to check if any open transactions, sql server stated there are no active transactions

No active open transactions.

DBCC execution completed. If DBCC printed error messages, contact your...

Dear All,

Yesterday i stayed up for a long time and finally i was able to find out the reason i couldnt drop index.

The application is using a view containing the...

Thanks for ur example

it made it very clear

Thanks Paul for ur reply, its very informative.

To make sure i understand u correctly, for the index if added field is a null value, just its metadata will be updated...

Thanks SQLFrenzy

Best Regards

Nader

Thanks All,

ur replies were very helpfull.

Best Regards

Nader

thanks SQLFrenzy

Do u have any idea what happens in that case and how will clustered index reference data in this new field

Thanks Gail,

U said a very important comment about dmv views which is when db or sql is restarted all this is cleared and actually one of my colleagues was going...