Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Query about Remote server query time out in SQL 20

Author  Topic  sqlcheck Starting Member 1 Post Posted - 2009-10-16 : 03:03:43 Hi, This is a query about Remote server query time out in SQL 2000. 1. We have two SQL servers – Server A and Server B 2. From Server A (job) we are running a stored procedure in Server B. (EXEC ServerB.DBName.DBO.SP_NAME) 3. The Query time out for Server A is 9600 sec and for server B it is 12600. 4. The problem is exactly after 9600 seconds we are getting error message in the SQL job. PFB the error message ??????????? : NT AUTHORITY\SYSTEM? ???? ???? 'TKSV1060' ???????? 'aJ_SP_DWH_SO_SELLOUT_SUMMARY_ACCOUNT' ??????????????? [SQLSTATE 42000] (??? 7221) [SQLSTATE 01000] (??? 7312). ???????????? [From Remote server B – the stored procedure’s result cannot be relayed. [SQLSTATE 42000] (Error 7221) [SQLSTATE 01000] (Error 7312)] Even though the server B’s setting shows 12600 seconds, the job fails after 9600 seconds. 5. I confirmed that the SQL versions for both the servers are same. PFB the same. Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 6. I found one Article in Microsoft site regarding this and found that it is a bug in Microsoft and it can be corrected using patch release. But this article says that this bug was corrected in SP1. I found that SP4 patch is the latest whereas we have SP2. http://support.microsoft.com/kb/275901/en-us Thanks Aravindh aravindh