Thanks Dewayne, I will check for DBCC errors.

Sorry, Forgot to Mention the Edition - My server edition is SQL Server 2012 - Standard edition.

I have 5 Databases. I don't know on which DB to run DBCC checkDB....

Thanks Gail.

Yes Thanks, But i want to know that If there is limit for the script size.

I Thank Everyone for the support. I will write to MS regarding the issue.

Yes, it's not the transaction log.

pls see the screenshot - https://drive.google.com/file/d/0BwQesWwtB8meN0VQeVlQUU9iN2c/view?usp=sharing

No, I can't see the File properties

Yes, E drive is present. I can't see database files, either by Properties or by sys.filegroupgs(I get the above mentioned error - second error)

Thanks, Gail:-)

Thanks Jeff.:-)

As already mentioned the data is huge, select or update is taking long time.

Thanks a lot for the solution...:-)

Kudos, Thanks a lot Hugo. Great help.:-)

Kudos, Thanks for the solution john.

Thanks for the Reply gail, but however I was able to script out all data by changing execution time out settings, since I have all data now can I...