how to error handling running osql under master.dbo.xp_cmdshell? - Database版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - how to error handling running osql under master.dbo.xp_cmdshell?

相关主题
● log shipping 问题	● Dynamic SQL的弱问题
● 请教一个在stored procedure 里用bcp的问题.	● question about import xml to sql table
● why this Trigger hang the Process *** thanks thanks	● SQL Server 2005 Exec( )
● 问一个SQL Server执行外部文件的问题	● 问一个db2的弱问题
● ORACLE Pro*C 远程接续一问?	● how to check the definition of a stored procedure in TOAD
● [转载] 真的没有人懂 ORACLE pro*c阿？ :((((	● error file或者exception file
● 我这个数据库怎么办啊？	● SQL debug step into a store procedure from another one (转载)
● embedded sql 问题	● get value returned by SQLstored procedure from python (转载)

相关话题的讨论汇总
话题: osql话题: error话题: cmdshell话题: handling话题: running

进入Database版参与讨论

1

(共1页)

m******y 发帖数: 588	1 When I'm running EXEC master..xp_cmdshell 'osql .. test.sql ..', I'm not able to use @@ERROR to catch any error happening when executing test.sql using osql utility. Is there anyway to error handling that? Thanks.
m******y 发帖数: 588	2 Right now whatI did is to write the osql result into a log file and then use EXEC sp_readerrorlog to find some keyword 'error' ,'invalid object' etc to handle the errors. Does anyone know a better way to do this? Thanks again.

1

(共1页)

进入Database版参与讨论

相关主题
● get value returned by SQLstored procedure from python (转载)	● ORACLE Pro*C 远程接续一问?
● run SQL stored procedure from python	● [转载] 真的没有人懂 ORACLE pro*c阿？ :((((
● 问几个认证的考题	● 我这个数据库怎么办啊？
● 关于FoxPro的容量问题	● embedded sql 问题
● log shipping 问题	● Dynamic SQL的弱问题
● 请教一个在stored procedure 里用bcp的问题.	● question about import xml to sql table
● why this Trigger hang the Process *** thanks thanks	● SQL Server 2005 Exec( )
● 问一个SQL Server执行外部文件的问题	● 问一个db2的弱问题

相关话题的讨论汇总
话题: osql话题: error话题: cmdshell话题: handling话题: running

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)