0

I want to send an SMS as a User logs in to the sql server database. is this possible in sql express? please help me with the code.

i would use a trigger for sending the message. As soon as the user would log into an sql database with correct credentials he would be send an sms on his mobile, message body comprising his Username.

For SMS what features shall i have on my PC. i have Windows XP and have a broadband internet connection. i would search for some free SMS APIs on the internet or buy one if not available,

but what's the whole criteria of implementing this task from bottom to top?

sqlchild
  • 8,754
  • 28
  • 105
  • 167

1 Answers1

2

Your calling application should send an SMS. It knows what the username is because these are required to connect to the database.

Generally databases do not actively interact with the outside world except with their calling application. This includes sending an SMS. There is no benefit is having SQL Server send an SMS here.

gbn
  • 422,506
  • 82
  • 585
  • 676
  • @gbn: sir, ok , you mean that sql cannot send sms itself. the code has to be written in c#. i have a winform in which the user will enter the userid and password which would be passed to the connection string , if valid then user will be successfully connected to the database and an sms would be sent on his/her mobile – sqlchild Mar 15 '11 at 06:19
  • @sqlchild: yes, that it's. c# is far better for thsi – gbn Mar 15 '11 at 06:41
  • @gbn: but is there any way in sql server without using c#, to do this task? – sqlchild Mar 15 '11 at 06:42
  • @gbn: sir, you din't tell me? – sqlchild Mar 17 '11 at 05:57
  • @gbn: what should i have for sending the sms. do i need sms api or gateway. – sqlchild Mar 17 '11 at 07:51
  • @gbn: sir, please help, what should i use, api or gateway, i have no knowledge about it. – sqlchild Mar 28 '11 at 07:03
  • Neither do I. We only send emails using SMTP. – gbn Mar 28 '11 at 07:06
  • ok sir, so for email can you give me some knowledge.am using sql server 2005 express, so there's no inbuilt feature to send mail, but my management studio is the latest one, so can i use database mail? i mean that for database mail , is sql server non-express necessary or management studio non-express would work together with sql server express. – sqlchild Mar 29 '11 at 04:47
  • so do you use .net to send mail? if yes , then please help me out with the code – sqlchild Mar 29 '11 at 04:47