i need drive name & disk size in MB. & for that i need to convert it from varchar to int.

your query is working but i need values in MB

Hey, I have tried this already hence i told in my post that error is in conversion.

I have tried your query but gives me same error "Error converting data...

:crazy:

Getting same error since last 2 days.

OS: windows server 2008 R2

SQL : Sql server 2008 R2.

Tried TCP IP Chimney option but still getting the same error.

any Solution Guys ????

Yes, I can see the table through linked server , but while accessing it gives me an error.

Error:- The OLE DB provider "MSDAORA" for linked server "oracle" does not contain...

Thanks William and Perry for the response.

Also check the SSL setting in mail profile.

PFA

Check the below link.

http://social.technet.microsoft.com/Forums/en-AU/exchange2010/thread/b6e99b1e-790c-4694-82da-57c2ea7db52b

check if you are able to telnet the SMTP server from sql server.

Also check the password you have provided for mail setup.

The data which you are importing might be having text bigger than columns size of table.

Maximize the size of the table column and then try.

There are other quereis like select which are getting suspended.

No idea why this is happening

I also had the same issue.

It was due to the storage which was used for replication. During the storage replication

we used to get lots I/O messages,even sql services went down.

My...

Yes Gail, fragmentation value was not changed.

I checked the page count for those tables and it was below 100.

Thanks ALL.

If you are not able to view the script.

Pls click on scriptmanager.

I think you can not use variable in order by clause.

Variables are only allowed when ordering by an expression referencing a column name.

Thanks for the link Anthony.

I'll try to implement the steps and will inform you all guys!