master..xp_cmdshell

[ZeeshanMirza]

Hi there,

My task is to hit on a URL when ever there is an insert or update in data base table. I have made a batch file and from there i have opened required URL sucessfully.

I have made a trigger on required table and used the follwoing command to run my batch file

exec master..xp_cmdshell 'c:\test.bat'

when i insert a row in table I got 3 output lines as fallows

1. Null
2. Full path of of URL
3. Null

But i dont know why IE does not open and i did not see my required URL. First i though there might be some problem in my batch file, when i double clicked on it my IE got opened with URL given in it.

Kindly require solution of it urgently. looking for reply. thank's in advance.

[rmiao]

Sql doesn't handle interactive nor gui program that way.

[ZeeshanMirza]

SQL dont be handling but a batch file can handle. I just wanted to run batch file which handles the request automatically.

[rmiao]

But not as you expected.

[ZeeshanMirza]

So can you suggest me what should i do ?

What i want is when there is any insert on db table i want to hit a URL e.g http://www.google.com. kindly help me out in this regards i will be very thankful.

[rmiao]

You can't ask rdbms to do everything even not related to rdbms. :-)

Maybe try with clr if you have sql2k5 or up?