xp_cmdshell -- sql server programming

Stephen
6/17/2004 11:45:01 PM

Hi Guru's

In Win98 I can get a trigger to call any executeable with xp_cmdshell but
this is not true in Win2000. I only seem to be able to call OS based calls
like 'net send' or 'echo..' or 'dir ..'

My objective is to get data from a recently added record out of SQL2000 into
an external program running on the same machine but am hampered with my lack
of knowledge of VB and C. I work primarily with Pascal. (Delphi).

This task has me baffled, I already have set the MSSQL service to interact
with the desktop as advised earlier by one of you Gentlemen.

Please please please help.

Stephen

Tibor Karaszi
6/18/2004 10:14:57 AM

On NT and later, SQL Server is a service. A service doesn't have a windows context. This means that
you cannot run applications that interact with GUI Windows.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

[quoted text, click to view]

sql server programming : xp_cmdshell