Hi,

The problem got resolved now..

in the openquery i have added SET FNTONLY OFF and now it working fine..

Thanks for the help:-)

Hi,

My base part of the procedure is only this..

If that wont work then I will not go further with other procedures...

I have been asked to make test plans for the...

Also... a few days back both were not working and then my live and dev started working..

Now at this moment my dev is only not working..

Exactly what I am doing...

But how come i do not have the error for the same in Live... and i get the error in warm server!!!

i am doing excatly the same process in both...

Thanks,

Thats was helpful...

If the versions are diffrent will there be any problems in linking the servers?

If I do a cross query within the servers would I get any errors for any differences...

Hi ,

you are understanding the incorrect part......

After 10 mins I am not able to access the B server via query.

If I access the within 10 mins i am able...

Hi,

I discovered one more thing...

When I am executing the query from A server through QA I am logged in as windows authentication but I have the rights as adminitrator....

did not helped.

The problem is still there...

Hi,

Both have Sp4

When the job is running its using a login what is made specially as an adminstrator rights for the jobs. I know what the job is doing. It...

Its the other way round

At 10:30 my job is executed.

at 10:32 in QA I execute the query select * from A.dbname.dbo.tablename- Retirves data

At 10:45 my job is executed.

at 10:56...

my database size is 104587.31 MB

and unallocated space is 3959.97 MB

reserved data ...

Hi,

I using the login for SQL administrator.

I think I know whats the problem but cannot resolve it.

There is some server connection timeout happening between the server.

As I said once my...

Its not possible for me to reboot the machine or restart the server..

This happens very frequently... and its happening now also.

I am not familiar with the client network utility..

what should...

SQL server 2000 Windows 2003