If it is possiable to send an SMS from SQLServer2005 to MobilePhone using any extended stored Procedures. Otherwise we can able to create any Stored Procedures for sending sms.
-
-
Dear Vinayagamurthy,
Do you get any source code for SMS sending thro sqlserver2000.
Please reply me, -
You can create any exe to send SMS that can even accept parameters and then call xp_cmdshell to execute it from SQL.
There are other ways like creating .NET assembly and calling it but it is not the place to explain all functionalities of SQL Server 2005.
See example here
http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/
_______________ _______________ __________Comment
Comment