Thanks Gail.

Thanks Gail.

Some more add ons...

On production server is this a good practise to change the recovery mode to simple , ReBuild indexes and switch back to FULL.? Please confirm.

If yes...

:hehe:

Yes both the instances on the machine or of 64 BIT standard edition.

One instance is linked fine but the other failed.

how much is the memory allocated on your BOX ?

Agree..

Jeff is correct. with simple changes in update query will help to overcome your problem.

- Win.

Different instance names with same database name on same machine is possible with different database file locations.

- Win.

yes am able to Ping the server...

Also able to create linked server on the same server with another Instance...

But this instance is not able to...

Any thoughts...

Some more points to add:

OLE DB provider "SQLNCLI" for linked server "OPSRVDB" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "OPSRVDB" returned message "An error has occurred...

Named Pipes

Remote Connections

TCP/IP ports

Firewall

Network all are fine...

When i add the same linked server to another server its working fine, even local machine PC is also connected but the TEST server...

excel is in .xls or .xlsx ?

Rename the sheet to the table name and check if the same number of coulmns are there in the sheet as per table.

Check:...

Raju,

Dont use complete sentence in CAPITAL letters. It shows that you are asking a question as shouting on others.

Correct it while you post next time.

Hi, Bru, what's the difference between "Open" And "Run as administrator"?

______________________________________________________________________________

It switches the SQL Server to run with the administrator account.

how about shrinking the file ??

Still i have the same issue with my office machine and my PC as well...

The mail could not be sent to the recipients because of the mail server failure. (Sending...

Correct.. I agree that it might be a network issues if that doesnot happened in the past.

If the same persisits:

1. Open the maintenance plan,

2. Re check the configure with credentials...