ya i agree but thats what my requirment .. any other way to over come this ?

Thank you very much for your valuble reply.

Regards,

ravi@sql

I have done that column propertied like name,size , data type every thing is perfect. still am getting this error.

Error: Data conversion failed. The data conversion for column ""...

No actually i exported 3 lakh records with around 150 columns dude , i splitted the records based on source using query . for that only it was...

Hi thank you all for the support.

Finally i exported data using SSIS and it works fine .

Regards,

Ravindranath.s

more than 11 lakh

sql server 2008 and .xlsx file...

yes you are right if i guess right ... but one senior guy telling that mdf and log files are corrupted now resore it from any other back only the...

no actually i closed sql server and opened am able to see other databases except which i wanted to connect.

Thank you all .

Regards,

Ravi@sql

ok cant i point my log file path any other drive ? if yes how can i do that ? pls share the query ?

Thanks

Ravi@sql

ya maxsize is given for autogrowth

recovery_model_desclog_reuse_wait_desc

SIMPLE NOTHING

Thank you all for your help full reply .

Basically i have table will large data and table had clustred index also . still query performance is poor b'coz...

Thank you all ,

Its one of the interview question which is fired to me ....

I said Aithrmetic overflow error,Syntax error, constrains like foreign key...