开发者

Send an SMS as a User logs in to the sql server database with valid credentials

开发者 https://www.devze.com 2023-02-17 00:54 出处:网络
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 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?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号