SMS-it support forum
|Welcome to the SMS-it
Before entering a query/request
please search the forum to see if someone else has asked the question before.
Please feel also free to
respond to queries from other users if you have experienced the same type
of problem and found a solution to it.
Our support team will monitor
this forum and endeavour to provide answers to the queries posted.
Please make sure to post
your query to the right forum as there is a separate forum for each application
provided by MAW Software.
Back to the forum
, the 06.13.2006, xtreme wrote at 20:19:46 :
Send SMS using SQL Server 2000 and get return values
I am trying to send sms from SQL server 2000 by using the xp_cmdshell. When i pass the commands using the command line it works fine without any problem. The query i used in SQL is like this..
Exec xp_cmdshell 'c:\Progra~1\sms-it\sms-it.exe SMST John "message goes here" '
Now i want to know whether the sms has been sent or failed.. when i check from the interface in your software i can see the status of messages.. how can i retrieve those information through sql.. is it possible? or is there any way to check the return value after executing that command from SQL sever?
CGIForum (C) Markus Triska