Home
RECOMMENDED FOR YOU:
SMS Gateway software
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android

C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code

PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website

SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
Ozeki 10 SMS Gateway

How to send sms from MS SQL Server

CREATE DATABASE messaging
GO
 
USE messaging
GO
 
CREATE TABLE ozekimessagein (
 id int IDENTITY (1,1),
 sender varchar(255),
 receiver varchar(255),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(30),
 msgtype varchar(30),
 reference varchar(30),
);
 
CREATE TABLE ozekimessageout (
 id int IDENTITY (1,1),
 sender varchar(255),
 receiver varchar(255),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(100),
 msgtype varchar(30),
 reference varchar(30),
 status varchar(30),
 errormsg varchar(250)
);
 
GO

create database and tables
Figure 1 - Create database and tables

select add new user or application
Figure 2 - Select 'Add new user or application'

install sql messaging user
Figure 3 - Install SQL Messaging User

install ms sql connection
Figure 4 - Install MS SQL Connection

define the ms sql database connection details
Figure 5 - Define the MS SQL database connection details

enable ms sql connection
Figure 6 - Enable MS SQL connection

insert message to the database table
Figure 7 - Insert message to the database table

message sent from database
Figure 8 - Message sent from database

received message inserted into database
Figure 9 - Received message inserted into database

More information