<div>
<br />
Thanx nigelrivett for your valuable suggustion... <br />

</div>



Thanx nigelrivett for your valuable suggustion...


<div>
<div class="content wysiwyg-content">
Hi all...<br />
<br />
I m trying to run an external program through a trigger on data modification... But it is not perofrming the required function.. even it is not giving any error..<br />
<br />
'''''''''''''''''''''<br />
CREATE TRIGGER try1_trigger<br />
ON try1<br />
FOR INSERT, UPDATE, DELETE <br />
AS <br />
&nbsp;DECLARE @sCmd varchar(256)<br />
&nbsp;EXEC master.dbo.xp_cmdshell &nbsp;'C:\winnt.sbs\notepad.exe'<wbr /><br />
''''''''''''''''<br />
<br />
<br />
please let me know where i m wrong...<br />
<br />
thanx
</div>
</div>


Hi all...

I m trying to run an external program through a trigger on data modification... But it is not perofrming the required function.. even it is not giving any error..

'''''''''''''''''''''
CREATE TRIGGER try1_trigger
ON try1
FOR INSERT, UPDATE, DELETE 
AS 
 DECLARE @sCmd varchar(256)
 EXEC master.dbo.xp_cmdshell  'C:\winnt.sbs\notepad.exe'
''''''''''''''''


please let me know where i m wrong...

thanx

run a external program from a trigger

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.