i want send all kind of phones arround world

hai,

I Want to send SMS all kind of phones arround the world,so what can i do for that pls help me...............

So, you want us to help you send spam to our phones?

Perhaps a better explanition of your problem is in order.

|||

hai james

here i order my problem

1)using webservice how to send SMS,i had some programs but i will not work.

2)i want to use console program to schedule,

3)Main thing i want know what are the datatypes,functions used for sending SMS via SMTP and how to use

|||SMS requires a special SMS modem and an SMS server to send the text messages and a subscription.

Sending EMAIL to phones using SMTP is no different than sending any other email. Stick to SMTP email.

|||

hai james,

I tried my e-mail configuration.I configured "database mail" it's in SQL .I tried TEST MAIL to all the mail service like GMAIL,YAHOO It goes,but i tried SMS it will not go,

here my design

Database Mail Profile: "our configured name"(SMTP configuration for E-Mail)

To : "mobile number with coountry code"@."service provider"

Subject : "some text"

Message : "message"

This is my E-Mail structure the above sturcture is altered for my SMS,i don't know why it will not go,you want me to change any setting or any thing else pls tell me a solution "to send SMS via database"|||You can NOT send SMS through SQL Server. Well, you can NOT do this using Database Mail. You don't have to alter anything to send MAIL to a phone. You simply send an e-mail to the phone. It arrives as a text message. That's it.|||You probably don't need the country code.

Are you sure that is the email address? My provider does not support "phonenumber@.service.com" because of all the spam. They make me create a unique email address for my phone. You will have to ask the recipient what their phone email address is.

Try just sending an email to the correct address, NOT from SQL. Then once that is working, send it from db mail.

This has nothing to do with SMS. The provider may convert the email you sent to SMS, but it is not your responsibility.

|||

hai,

i don't understand from where can i send SMS to the phone,but i tride throutgh SQL server database mail.Tell me where can i send give me a details and how to send with small example ,You said can't able to send through SQL then how can i...............

|||hai i don't know where to send SMS by using Mail service,u said send as normal mail using mobile number how to send tell me immediately......plssss|||Forget SMS.

Almost every single cell phone provider provides a method to send EMAIL using SMTP to a phone. The provider might convert that to an SMS message, but you don't need to know how that works.

Get the email address for the phone, for example 9999999999@.sprint.pcs.net, and send a regular SMTP email to it. Once that works, then you can add that email address to the DB Mail to send SQL messages.

i want know the difference between "SQL Server 2005 -Std Edition" and "SQL Server

hai to all,

i want know the difference between "SQL Server 2005 -Std Edition" and "SQL Server 2005 Std license"

can any one tel regarding that.

IF both descriptions refer to SQL Server, then there probably are no differences. The best way to know the product is to check the SKU.

However, since the word 'license' is not capitalized, I wonder if it should have been SQL Server 2005 Std Single Processor License"?

|||

thank u.

but which one i will go for that.

can ypu give me the details.

|||

You are going to have to provide more information. I've told you all that I can with the little information available.

Are you attempting to verify your product?

Are you attempting to verify a product that you may purchase?

Where did you get this product information?

|||

i need SQL server 2005 for my Application.

but in my office they give 2 things.

1.SQL Server 2005 -Std Edition

2.SQL Server 2005 Std license

but in my application they mention as SQL server 2005 thats all.

so we need to buy SQL Serer 2005 license version.

could u tel which one is best.

|||

The primary question to answer is how will users connect to the SQL Server.

Each Edition of SQL Server comes in two 'license' configurations, a version that requires each user to have a 'Client Access License' (CAL), and a version that allows unlimited users -and each users does not require a CAL.

If your application serves public internet users, where you cannot control or assure that each user has a valid CAL, you must use the 'Processor License'. If your application serves internal clients, where you can be certain that each user has a CAL, then you can use the version that requires CALs.

For definitive answers about licenses, call the folks at:

Licensing –VL Contact
(800) 426-9400

For Other licensing questions:

Licensing -FAQ
http://www.microsoft.com/sql/howtobuy/faq.mspx

I need SQL Query Help

Sir,

We are try to insert query like this

Insert into Table_1 (smDate,Description) Values ('Thu, Feb 15, 2007 03:00 PM', ' Hai, It's Just for Testing')

This is Exact Query about this...

We know about MS ACCESS it has Built in function like Format('Thu, Feb 15, 2007 03:00 PM','mm/dd/yyyy HH:MM')

But I am new to SQL. I dont know the The Date Format built in function in SQL Server.

How can i Insert this Quesry to SQL Table

and also How can insert "it's " this type of words into SQL..

Can you help me

this is very helpful for my project

Thanks With Regards

S.Senthil Nathan

The quickest way i've used and seen being used to put an apostrophe into a SQL statment, is to do a replace on the string with a double quote, then you will need to do a reverse replace on the double quote back to an apostrophe, not the best way but one solution, the other is to escape the apostrophe with another so it would beit''sbut this would still require some parsing of the string.

Have a look at this artilce for working with formatting the date/time in SQL :http://sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

|||

For your date format issue, if you can remove the "Day, " from the date, you can insert the string you have. I.e. 'Feb 15, 2007 3:00 PM' is a valid date string and will be formatted automatically by SQL server according to how SQL server is set up. For example, if using the defaults on a US-based setup, SQL server formats the date like you requested.

if you need to insert something with single quotes, you have two options. First, you can replace it with two single quotes, i.e. 'it''s' would putit's in the database.

Second, you can use parameters. Your sql statement would be like "INSERT INTO dbo.MyTable (StringValue) Values (@.StringValue)", and then add a sql parameter to your sqlcommand as if you were using a stored procedure. If you had a Data.SqlClient.SqlCommand named command:

command.CommandType = Data.CommandType.Textcommand.CommandText = strSQL' this is your insert statement with a parametercommand.Parameters.AddWithValue("@.StringValue", "it's")

I prefer the second choice becuase it's easier than remembering to replace quotes and other sql syntax.

I need SQL Query Help

Sir,

We are try to insert query like this

Insert into Table_1 (smDate,Description) Values ('Thu, Feb 15, 2007 03:00 PM', ' Hai, It's Just for Testing')

This is Exact Query about this...

We know about MS ACCESS it has Built in function like Format('Thu, Feb 15, 2007 03:00 PM','mm/dd/yyyy HH:MM')

But I am new to SQL. I dont know the The Date Format built in function in SQL Server.

How can i Insert this Quesry to SQL Table

and also How can insert "it's " this type of words into SQL..

Can you help me

this is very helpful for my project

Thanks With Regards

S.Senthil Nathan

Senthil:

look up CAST AND CONVERT under CONVERT in books online to get a look at date and time formats. The ISO format is format 112. This should get you moving in the right direction.

Dave

|||Hi,

convertion was already explained by another posted, the issue with the quotes can be solved using two single quotes instead of one.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de