/**/ /* --?SET?NOCOUNT?的問題

SQL?版本 :?SQL?Server?2005?3159

故障描述:
當滿足下述條件時,?SET?NOCOUNT?導(dǎo)致?TRY?...?CATCH?無法正確處理錯誤
1.?使用?EXEC(<SQl>)?AT?<Linked?Server>?或者?EXEC?<Linked?Server>.<database?name>.dbo.sp_executesql?<SQl>
2.?<SQL>?中包括輸出參數(shù)
3.?<SQL>?中包括?SET?NOCOUNT?ON?和?USE?<Database?Name>?語句(注意不能更換出現(xiàn)次序)

具體的參考下面的測試示例

與此問題相關(guān)的帖子:
http://topic.csdn.net/u/20080103/12/3dafc07c-3376-40c1-b4bd-7cbd76afed1a.html?seed=182508736
-- */
-- ?添加鏈接服務(wù)器
EXEC ?sp_addlinkedserver?? ' srv_lnk ' , '' , ' SQLOLEDB ' , ' . '
EXEC ?sp_serveroption? ' srv_lnk ' , ' rpc?out ' , ' true ' ????
GO

-- ?測試語句
-- SET?NOCOUNT?ON
BEGIN ?TRY
???? DECLARE
???????????? @error_number ? int ,
???????????? @error_message ? nvarchar ( 2048 )

???? EXEC (N '
SET?NOCOUNT?ON

USE?tempdb

BEGIN?TRY
????DELETE?FROM?[NEWID()]
END?TRY
BEGIN?CATCH
????SELECT
??????????=?ERROR_NUMBER(),
??????????=?ERROR_MESSAGE()
END?CATCH
' ,
???? @error_number ?OUTPUT,
???? @error_message ?OUTPUT
????)AT?srv_lnk
END ?TRY
BEGIN ?CATCH
???? SELECT ?
???????? 2 ,?
????????ERROR_NUMBER(),
????????ERROR_MESSAGE()
END ?CATCH
GO

-- ?刪除鏈接服務(wù)器
EXEC ?sp_dropserver? ' srv_lnk ' ,? ' droplogins '
GO