sp &amp&#59; select


I have two SQL Server 2000 (one is localhost, one is remote with VPN IP 192.168.5.4).

I can select * from [192.168.5.4].db.dbo.test but I can't exec [192.168.5.4].db..spAdd in localhost.

These select and sp is OK for 1 or 2 week without any problem,but it didn't work one day.

Can some one explain why






Re: Can exec select but can't exec sp

Madhu K Nair


Check the permission on the SP. Also post back the error

Madhu







Re: Can exec select but can't exec sp

sp & select

Pemission is OK.

The process is OK before, but it didn't work one day.

And I have checked no lock in the remote system.

No error display, just like some process can't finish.

It's always run, run, run..........endless






Re: Can exec select but can't exec sp

Madhu K Nair

try to connect to remote server and execute this sp, it will give us a clue whether its the problem with the sp or linked server

Madhu






Re: Can exec select but can't exec sp

sp & select

The linked server has the same problems.

But how can linked server have such problems






Re: Can exec select but can't exec sp

Madhu K Nair

are you saying the sp itself is taking time then you need to check the sp

Madhu