Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 MS-SQL SERVER 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-17 : 13:40:44
Muralimohan writes "Can we execute a .exe file through a user defined stored procedure?


In detail:

If I create a .exe file in visual basic file,Can I include that .exe file in my stored procedure(This stored procedure is a user defined stored procedure)

When I execute this procedure , it has to execute the .exe file.How can I proceed?


Thanks

MuraliMohan"

izaltsman
A custom title

1139 Posts

Posted - 2002-06-17 : 15:50:48
In your stored procedure you can call xp_cmdshell, which will allow you to issue a DOS command to run your executable.
(see BOL for xp_cmdshell syntax)

Go to Top of Page
   

- Advertisement -