I can't get email notification to work

I posted this on the Sql Server Notification Services newsgroup, but there's
been no response, and I now see that it doesn't get much use. So here it is
again:
I have been given the job of database administrator. I very good at SQL
programming, but am just learning about things like backups, replication,
etc. and am VERY shaky on anything involving network administration. I am
not the one who installed Sql 2005 database, so I don't know if any steps
were missed.
Email notification does not work, and I don't know if it ever did. I have
to remember to run a CheckJobs script periodically because the system is not
going to tell me if something goes wrong.
I would like to get this working, but I don't know where to start. The
70-431 Training Kit says that Database Mail must be enabled through the SQL
Server Surface Area Configuration tool, but when I open that up, I have no
idea what I'm supposed to do.
I also went through the Database Mail Configuration Wizard; no error
messages but also no messages coming through my email. When I view the
history, I see a lot of failures, but nothing that tells me why.
How do I fix this?
Also, could the failure in email notification be connected to the fact that
I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
fixing one problem will fix both? I was really surprised when I failed in
this simple exercise, since I had no problem setting up a linked server while
working on a client system a couple of years back. I also bombed in my
endpoint exercises, but that's something that's completely new to me.Fire up SQL Server Surface Area Configuration tool and click on Surface Area
Configuration for Features. Find your instance and click on it. Expand
"Database Engine" and go to Database Mail. Enable it and then restart your
SQL Server service using SQL Server Configuration Manager.
Open up SSMS (Management Studio) and connect to your instance. Go to
Management and right click on Database Mail it. Choose Configure Database
Mail.
Set up Database Mail. Create a Profile, and then create an account.
Determine if it's gonna be a public or private profile. Profiles are either
public or private. A private profile is accessible only to specific users or
roles. A public profile allows any user or role with access to the mail host
database (msdb) to send e-mail using that profile.
Right click on Database Mail again and try a test mail.
If it works without any problem, then you can use this notification method
for your jobs or whatever.
P.S.
Ensure the data you enter for account configuration is correct and works
fine.
--
Ekrem Ã?nsoy
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:C00E859A-B110-4FCC-B22A-2F7A69AE732D@.microsoft.com...
>I posted this on the Sql Server Notification Services newsgroup, but
>there's
> been no response, and I now see that it doesn't get much use. So here it
> is
> again:
> I have been given the job of database administrator. I very good at SQL
> programming, but am just learning about things like backups, replication,
> etc. and am VERY shaky on anything involving network administration. I
> am
> not the one who installed Sql 2005 database, so I don't know if any steps
> were missed.
> Email notification does not work, and I don't know if it ever did. I have
> to remember to run a CheckJobs script periodically because the system is
> not
> going to tell me if something goes wrong.
> I would like to get this working, but I don't know where to start. The
> 70-431 Training Kit says that Database Mail must be enabled through the
> SQL
> Server Surface Area Configuration tool, but when I open that up, I have no
> idea what I'm supposed to do.
> I also went through the Database Mail Configuration Wizard; no error
> messages but also no messages coming through my email. When I view the
> history, I see a lot of failures, but nothing that tells me why.
> How do I fix this?
> Also, could the failure in email notification be connected to the fact
> that
> I can't set up a linked server to the Sql 2000 Server on my PC? Like
> maybe
> fixing one problem will fix both? I was really surprised when I failed in
> this simple exercise, since I had no problem setting up a linked server
> while
> working on a client system a couple of years back. I also bombed in my
> endpoint exercises, but that's something that's completely new to me.|||Hi Bev
I assume that you are alerting an operator when the job has completed/failed
etc?
Ekrem has described setting up database, but you description implies that it
has already been configured? Do you get any information in the database mail
log ( right click the database mail node and view the log) ?
It could be that your firewall is not configured correctly, can you ping and
telnet to the smtp relay (I assume that you are not using SQL Mail!).
If database mail is working, you may want to try and create a new operator
and see if they can be emailed notifications.
John
"Bev Kaufman" wrote:
> I posted this on the Sql Server Notification Services newsgroup, but there's
> been no response, and I now see that it doesn't get much use. So here it is
> again:
> I have been given the job of database administrator. I very good at SQL
> programming, but am just learning about things like backups, replication,
> etc. and am VERY shaky on anything involving network administration. I am
> not the one who installed Sql 2005 database, so I don't know if any steps
> were missed.
> Email notification does not work, and I don't know if it ever did. I have
> to remember to run a CheckJobs script periodically because the system is not
> going to tell me if something goes wrong.
> I would like to get this working, but I don't know where to start. The
> 70-431 Training Kit says that Database Mail must be enabled through the SQL
> Server Surface Area Configuration tool, but when I open that up, I have no
> idea what I'm supposed to do.
> I also went through the Database Mail Configuration Wizard; no error
> messages but also no messages coming through my email. When I view the
> history, I see a lot of failures, but nothing that tells me why.
> How do I fix this?
> Also, could the failure in email notification be connected to the fact that
> I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> fixing one problem will fix both? I was really surprised when I failed in
> this simple exercise, since I had no problem setting up a linked server while
> working on a client system a couple of years back. I also bombed in my
> endpoint exercises, but that's something that's completely new to me.|||Since I'm not allowed to make changes during normal working hours, and I
can't stay late tonight, I will tackle these suggestions tomorrow night.
I do not know if the database mail has already been configured. I also
don't know if the problem lies in our firewall, but we've had problems with
it before in terms of it being way too restrictive. There was a time when it
blocked us from accessing even our own website, which put a real crimp in my
job as website administrator.
So, how do I "ping and telnet to the smtp relay?"
"John Bell" wrote:
> Hi Bev
> I assume that you are alerting an operator when the job has completed/failed
> etc?
> Ekrem has described setting up database, but you description implies that it
> has already been configured? Do you get any information in the database mail
> log ( right click the database mail node and view the log) ?
> It could be that your firewall is not configured correctly, can you ping and
> telnet to the smtp relay (I assume that you are not using SQL Mail!).
> If database mail is working, you may want to try and create a new operator
> and see if they can be emailed notifications.
> John
>
> "Bev Kaufman" wrote:
> > I posted this on the Sql Server Notification Services newsgroup, but there's
> > been no response, and I now see that it doesn't get much use. So here it is
> > again:
> >
> > I have been given the job of database administrator. I very good at SQL
> > programming, but am just learning about things like backups, replication,
> > etc. and am VERY shaky on anything involving network administration. I am
> > not the one who installed Sql 2005 database, so I don't know if any steps
> > were missed.
> > Email notification does not work, and I don't know if it ever did. I have
> > to remember to run a CheckJobs script periodically because the system is not
> > going to tell me if something goes wrong.
> > I would like to get this working, but I don't know where to start. The
> > 70-431 Training Kit says that Database Mail must be enabled through the SQL
> > Server Surface Area Configuration tool, but when I open that up, I have no
> > idea what I'm supposed to do.
> > I also went through the Database Mail Configuration Wizard; no error
> > messages but also no messages coming through my email. When I view the
> > history, I see a lot of failures, but nothing that tells me why.
> > How do I fix this?
> > Also, could the failure in email notification be connected to the fact that
> > I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> > fixing one problem will fix both? I was really surprised when I failed in
> > this simple exercise, since I had no problem setting up a linked server while
> > working on a client system a couple of years back. I also bombed in my
> > endpoint exercises, but that's something that's completely new to me.|||Hi Bev
ping and telnet are command line utilities, you can find information about
them in the windows help. Commands such as netstat and nslookup may also be
useful. You may want to get the network and firewall guys to check the logs
whilst you attempt to send mail. You may have to get through more than one
firewall.
As far as database mail configuration goes I suggest you find a test machine
that has not got it configured or a machine you can set up SQL Server on and
go through the actions of configuring it so that you are familiar.
John
"Bev Kaufman" wrote:
> Since I'm not allowed to make changes during normal working hours, and I
> can't stay late tonight, I will tackle these suggestions tomorrow night.
> I do not know if the database mail has already been configured. I also
> don't know if the problem lies in our firewall, but we've had problems with
> it before in terms of it being way too restrictive. There was a time when it
> blocked us from accessing even our own website, which put a real crimp in my
> job as website administrator.
> So, how do I "ping and telnet to the smtp relay?"
> "John Bell" wrote:
> > Hi Bev
> >
> > I assume that you are alerting an operator when the job has completed/failed
> > etc?
> >
> > Ekrem has described setting up database, but you description implies that it
> > has already been configured? Do you get any information in the database mail
> > log ( right click the database mail node and view the log) ?
> >
> > It could be that your firewall is not configured correctly, can you ping and
> > telnet to the smtp relay (I assume that you are not using SQL Mail!).
> >
> > If database mail is working, you may want to try and create a new operator
> > and see if they can be emailed notifications.
> >
> > John
> >
> >
> > "Bev Kaufman" wrote:
> >
> > > I posted this on the Sql Server Notification Services newsgroup, but there's
> > > been no response, and I now see that it doesn't get much use. So here it is
> > > again:
> > >
> > > I have been given the job of database administrator. I very good at SQL
> > > programming, but am just learning about things like backups, replication,
> > > etc. and am VERY shaky on anything involving network administration. I am
> > > not the one who installed Sql 2005 database, so I don't know if any steps
> > > were missed.
> > > Email notification does not work, and I don't know if it ever did. I have
> > > to remember to run a CheckJobs script periodically because the system is not
> > > going to tell me if something goes wrong.
> > > I would like to get this working, but I don't know where to start. The
> > > 70-431 Training Kit says that Database Mail must be enabled through the SQL
> > > Server Surface Area Configuration tool, but when I open that up, I have no
> > > idea what I'm supposed to do.
> > > I also went through the Database Mail Configuration Wizard; no error
> > > messages but also no messages coming through my email. When I view the
> > > history, I see a lot of failures, but nothing that tells me why.
> > > How do I fix this?
> > > Also, could the failure in email notification be connected to the fact that
> > > I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> > > fixing one problem will fix both? I was really surprised when I failed in
> > > this simple exercise, since I had no problem setting up a linked server while
> > > working on a client system a couple of years back. I also bombed in my
> > > endpoint exercises, but that's something that's completely new to me.|||Click Start-Run and enter 'cmd' to get a DOS prompt from the computer you
are trying to send email from.
C: \> ping your.mailserver.com
Did it get through, or did you lose the packets. Did it resolve the IP
address correctly?
Assuming that you're sending email via SMTP and that the mail server is
using the default mail port of 25 ...
C:\> telnet your.mailserver.com 25
A fail looks like:
Connecting To your.mailserver.com...Could not open connection to
the host, on port 25: Connect failed
On success, you will get a message and the cursor will be on the left side
of the creen (no prompt). Enter (I think) HELO and see if you get a
response. If so, you are connected to the mail server.
Jay
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:9C1D3DB5-AB2E-4C81-BAD0-3B9A95739CF9@.microsoft.com...
> Since I'm not allowed to make changes during normal working hours, and I
> can't stay late tonight, I will tackle these suggestions tomorrow night.
> I do not know if the database mail has already been configured. I also
> don't know if the problem lies in our firewall, but we've had problems
> with
> it before in terms of it being way too restrictive. There was a time when
> it
> blocked us from accessing even our own website, which put a real crimp in
> my
> job as website administrator.
> So, how do I "ping and telnet to the smtp relay?"
> "John Bell" wrote:
>> Hi Bev
>> I assume that you are alerting an operator when the job has
>> completed/failed
>> etc?
>> Ekrem has described setting up database, but you description implies that
>> it
>> has already been configured? Do you get any information in the database
>> mail
>> log ( right click the database mail node and view the log) ?
>> It could be that your firewall is not configured correctly, can you ping
>> and
>> telnet to the smtp relay (I assume that you are not using SQL Mail!).
>> If database mail is working, you may want to try and create a new
>> operator
>> and see if they can be emailed notifications.
>> John
>>
>> "Bev Kaufman" wrote:
>> > I posted this on the Sql Server Notification Services newsgroup, but
>> > there's
>> > been no response, and I now see that it doesn't get much use. So here
>> > it is
>> > again:
>> >
>> > I have been given the job of database administrator. I very good at
>> > SQL
>> > programming, but am just learning about things like backups,
>> > replication,
>> > etc. and am VERY shaky on anything involving network administration.
>> > I am
>> > not the one who installed Sql 2005 database, so I don't know if any
>> > steps
>> > were missed.
>> > Email notification does not work, and I don't know if it ever did. I
>> > have
>> > to remember to run a CheckJobs script periodically because the system
>> > is not
>> > going to tell me if something goes wrong.
>> > I would like to get this working, but I don't know where to start. The
>> > 70-431 Training Kit says that Database Mail must be enabled through the
>> > SQL
>> > Server Surface Area Configuration tool, but when I open that up, I have
>> > no
>> > idea what I'm supposed to do.
>> > I also went through the Database Mail Configuration Wizard; no error
>> > messages but also no messages coming through my email. When I view the
>> > history, I see a lot of failures, but nothing that tells me why.
>> > How do I fix this?
>> > Also, could the failure in email notification be connected to the fact
>> > that
>> > I can't set up a linked server to the Sql 2000 Server on my PC? Like
>> > maybe
>> > fixing one problem will fix both? I was really surprised when I failed
>> > in
>> > this simple exercise, since I had no problem setting up a linked server
>> > while
>> > working on a client system a couple of years back. I also bombed in my
>> > endpoint exercises, but that's something that's completely new to me.

I cannot get DBMAIL to work

This is the only thing holding up our deployment of SQL 2005.
I configured it and sent a "test message" with the "send test email"
control, and it works instantly.
When I send an email using procedure, nothing happens.
The log shows status as "sent". No errors. But no email is delivered.
I use the same email address as the test email. I don't get it.
EXEC msdb.dbo.sp_send_dbmail
@.profile_name= N'test',
@.recipients= N'myemailaddress',
@.Subject = N'test subject',
@.body= N'the body';
This returns "mail sent". But it is never delivered.
Like I said, the "test email" with the same profile works.We found the problem, the recipient had a bad rule on their end!
"Croco Stimpy" <none@.none.com> wrote in message
news:uhO1Ny0TGHA.4132@.TK2MSFTNGP11.phx.gbl...
> This is the only thing holding up our deployment of SQL 2005.
> I configured it and sent a "test message" with the "send test email"
> control, and it works instantly.
> When I send an email using procedure, nothing happens.
> The log shows status as "sent". No errors. But no email is delivered.
> I use the same email address as the test email. I don't get it.
> EXEC msdb.dbo.sp_send_dbmail
> @.profile_name= N'test',
> @.recipients= N'myemailaddress',
> @.Subject = N'test subject',
> @.body= N'the body';
>
> This returns "mail sent". But it is never delivered.
> Like I said, the "test email" with the same profile works.
>

I cannot get DBMAIL to work

This is the only thing holding up our deployment of SQL 2005.
I configured it and sent a "test message" with the "send test email"
control, and it works instantly.
When I send an email using procedure, nothing happens.
The log shows status as "sent". No errors. But no email is delivered.
I use the same email address as the test email. I don't get it.
EXEC msdb.dbo.sp_send_dbmail
@.profile_name= N'test',
@.recipients= N'myemailaddress',
@.Subject = N'test subject',
@.body= N'the body';
This returns "mail sent". But it is never delivered.
Like I said, the "test email" with the same profile works.We found the problem, the recipient had a bad rule on their end!
"Croco Stimpy" <none@.none.com> wrote in message
news:uhO1Ny0TGHA.4132@.TK2MSFTNGP11.phx.gbl...
> This is the only thing holding up our deployment of SQL 2005.
> I configured it and sent a "test message" with the "send test email"
> control, and it works instantly.
> When I send an email using procedure, nothing happens.
> The log shows status as "sent". No errors. But no email is delivered.
> I use the same email address as the test email. I don't get it.
> EXEC msdb.dbo.sp_send_dbmail
> @.profile_name= N'test',
> @.recipients= N'myemailaddress',
> @.Subject = N'test subject',
> @.body= N'the body';
>
> This returns "mail sent". But it is never delivered.
> Like I said, the "test email" with the same profile works.
>

I cannot get DBMAIL to work

This is the only thing holding up our deployment of SQL 2005.
I configured it and sent a "test message" with the "send test email"
control, and it works instantly.
When I send an email using procedure, nothing happens.
The log shows status as "sent". No errors. But no email is delivered.
I use the same email address as the test email. I don't get it.
EXEC msdb.dbo.sp_send_dbmail
@.profile_name= N'test',
@.recipients= N'myemailaddress',
@.Subject = N'test subject',
@.body= N'the body';
This returns "mail sent". But it is never delivered.
Like I said, the "test email" with the same profile works.
We found the problem, the recipient had a bad rule on their end!
"Croco Stimpy" <none@.none.com> wrote in message
news:uhO1Ny0TGHA.4132@.TK2MSFTNGP11.phx.gbl...
> This is the only thing holding up our deployment of SQL 2005.
> I configured it and sent a "test message" with the "send test email"
> control, and it works instantly.
> When I send an email using procedure, nothing happens.
> The log shows status as "sent". No errors. But no email is delivered.
> I use the same email address as the test email. I don't get it.
> EXEC msdb.dbo.sp_send_dbmail
> @.profile_name= N'test',
> @.recipients= N'myemailaddress',
> @.Subject = N'test subject',
> @.body= N'the body';
>
> This returns "mail sent". But it is never delivered.
> Like I said, the "test email" with the same profile works.
>

Hyperthreading info for SQL and Citrix

Just got this email from someone in Ops:
http://news.zdnet.co.uk/0,39020330,39237341,00.htm
http://blogs.msdn.com/slavao/archive...12/492119.aspx
Synopsis - Hyperthreading (Intel specific technology) can seriously impedes
performance in SQL and Citrix especially under heavy load.
Is this correct? Any ideas from the SQL peanut gallery here? We only run SQL
clusters, 25-30 of them all on at least dual Xeon's with Hyperthreading.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
There is no way to make an accurate blanket statement that HT helps or hurts
performance. I have certainly seen it do both depending on the type of
workload. The only way to know for sure is to do extensive testing in your
exact environment with it on and then again with it off.
Andrew J. Kelly SQL MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OgI%23x%2337FHA.1020@.TK2MSFTNGP15.phx.gbl...
> Just got this email from someone in Ops:
> http://news.zdnet.co.uk/0,39020330,39237341,00.htm
> http://blogs.msdn.com/slavao/archive...12/492119.aspx
> Synopsis - Hyperthreading (Intel specific technology) can seriously
> impedes performance in SQL and Citrix especially under heavy load.
> Is this correct? Any ideas from the SQL peanut gallery here? We only run
> SQL clusters, 25-30 of them all on at least dual Xeon's with
> Hyperthreading.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
|||I agree with Andrew. The only way to tell if Hyperthreading is good in your environment is do testing. It may be good for
some environments and may not be good for others.
There is a nice blog from Slava Oks on hyperthreading that you may find useful
Be aware: To Hyper or not to Hyper
http://blogs.msdn.com/slavao/archive...12/492119.aspx
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security
Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against
viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Hyperlink to send an Email

Hello,
I am looking for a way for users to click on a textbox and send an Email. I
got that to work if I set up 'On action' URL to
'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
If a user clicks next to A then Email should go to A@.myemail.com and if they
click next to B email should go to B@.myemail.com so on and so forth. I have A
and B here is value in my field MYFIELD. I tried using
mailto:Fields!MYFIELD.value that won't work.
Any ideas will be appreciated.
Thanks.Hi,
You can use the following expresion in the 'Jump to URL':
="mailto:" & Fields!MYFIELD.value
Use this with the equal sign and spaces. You can add
& "@.mycompany.com" if your field doesn't have the domain included
Jan Pieter Posthuma
"amitj" wrote:
> Hello,
> I am looking for a way for users to click on a textbox and send an Email. I
> got that to work if I set up 'On action' URL to
> 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> If a user clicks next to A then Email should go to A@.myemail.com and if they
> click next to B email should go to B@.myemail.com so on and so forth. I have A
> and B here is value in my field MYFIELD. I tried using
> mailto:Fields!MYFIELD.value that won't work.
> Any ideas will be appreciated.
> Thanks.|||Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
didn't add the field name.
"Jan Pieter Posthuma" wrote:
> Hi,
> You can use the following expresion in the 'Jump to URL':
> ="mailto:" & Fields!MYFIELD.value
> Use this with the equal sign and spaces. You can add
> & "@.mycompany.com" if your field doesn't have the domain included
> Jan Pieter Posthuma
>
> "amitj" wrote:
> > Hello,
> >
> > I am looking for a way for users to click on a textbox and send an Email. I
> > got that to work if I set up 'On action' URL to
> > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > and B here is value in my field MYFIELD. I tried using
> > mailto:Fields!MYFIELD.value that won't work.
> >
> > Any ideas will be appreciated.
> >
> > Thanks.|||Hi,
You have to add also the qoutes (") and & symbols. You have to use the equal
(=) to let RS to calculate the field. The next part is a string "mailto:"
including the quotes. Then you concatenate by using the &-sign to the value
part: Fields!MYFIELD.value.
Totally will be: <code>="mailto:" & Fields!MYFIELD.value</code>
That will work.
Jan Pieter Posthuma
"amitj" wrote:
> Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
> mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
> didn't add the field name.
> "Jan Pieter Posthuma" wrote:
> > Hi,
> >
> > You can use the following expresion in the 'Jump to URL':
> > ="mailto:" & Fields!MYFIELD.value
> >
> > Use this with the equal sign and spaces. You can add
> > & "@.mycompany.com" if your field doesn't have the domain included
> >
> > Jan Pieter Posthuma
> >
> >
> > "amitj" wrote:
> >
> > > Hello,
> > >
> > > I am looking for a way for users to click on a textbox and send an Email. I
> > > got that to work if I set up 'On action' URL to
> > > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > > and B here is value in my field MYFIELD. I tried using
> > > mailto:Fields!MYFIELD.value that won't work.
> > >
> > > Any ideas will be appreciated.
> > >
> > > Thanks.

Hyperlink

Is it possible to store an email address as a hyperlink in SQL Server table?
Thanks
No, there is not a hyperlink data type in SQL. You will have to store the
value as a different data type and do the programming on the front end
application to use it as a hyperlink. I would suggest varchar, but I am
fairly new to SQL and there may be a better data type.
"Brennan" wrote:

> Is it possible to store an email address as a hyperlink in SQL Server table?
> Thanks
|||You can store the email address as character data in SQL Server. However,
hyperlink functionality (launch email client or browser) is a function of
the front-end application, not the relational database. For example, if you
are rendering data in html, you could enclose the email address in an anchor
tag:
<a href="http://links.10026.com/?link=mailto:me@.mydomain.com">me@.mydomain.com</a>
Hope this helps.
Dan Guzman
SQL Server MVP
"Brennan" <Brennan@.discussions.microsoft.com> wrote in message
news:879832D4-68A3-4500-9410-D424A19C7EBC@.microsoft.com...
> Is it possible to store an email address as a hyperlink in SQL Server
> table?
> Thanks

Hyperlink

Is it possible to store an email address as a hyperlink in SQL Server table
?
ThanksNo, there is not a hyperlink data type in SQL. You will have to store the
value as a different data type and do the programming on the front end
application to use it as a hyperlink. I would suggest varchar, but I am
fairly new to SQL and there may be a better data type.
"Brennan" wrote:

> Is it possible to store an email address as a hyperlink in SQL Server tab
le?
> Thanks|||You can store the email address as character data in SQL Server. However,
hyperlink functionality (launch email client or browser) is a function of
the front-end application, not the relational database. For example, if you
are rendering data in html, you could enclose the email address in an anchor
tag:
<a href="http://links.10026.com/?link=mailto:me@.mydomain.com">me@.mydomain.com</a>
Hope this helps.
Dan Guzman
SQL Server MVP
"Brennan" <Brennan@.discussions.microsoft.com> wrote in message
news:879832D4-68A3-4500-9410-D424A19C7EBC@.microsoft.com...
> Is it possible to store an email address as a hyperlink in SQL Server
> table?
> Thanks

hyperlink

Hi
I am trying to add a hyperlink to the table column so that it opens as an email ..that is
if user clicks onxyz@.X.com field the email should open with this addr in the to box.Any suggestions..
ThanksYou could use a template column:
<asp:TemplateColumn HeaderText="email" ItemStyle-Width="40" HeaderStyle-HorizontalAlign="center" ItemStyle-HorizontalAlign="center">
<ItemTemplate>
<a href="http://links.10026.com/?link=mailto:<%#DataBinder.Eval(Container.DataItem, "email").ToString()%>"><%#DataBinder.Eval(Container.DataItem, "email").ToString()%></a>
</ItemTemplate>
</asp:TemplateColumn>|||If you are trying to add hyperLink in SRServices then its very simple u can do that
In the layout mode click on the cell where to use MailTo and press F4 to open properties, go down and click on Action property and click...
and select Jump to URL radio button and in the text box write="mailto:" & Fields!Customer_Email.Value.
i think that is what u want
Thanks
Rohit

Hyperlink

Is it possible to store an email address as a hyperlink in SQL Server table?
ThanksNo, there is not a hyperlink data type in SQL. You will have to store the
value as a different data type and do the programming on the front end
application to use it as a hyperlink. I would suggest varchar, but I am
fairly new to SQL and there may be a better data type.
"Brennan" wrote:
> Is it possible to store an email address as a hyperlink in SQL Server table?
> Thanks|||You can store the email address as character data in SQL Server. However,
hyperlink functionality (launch email client or browser) is a function of
the front-end application, not the relational database. For example, if you
are rendering data in html, you could enclose the email address in an anchor
tag:
<a href="http://links.10026.com/?link=mailto:me@.mydomain.com">me@.mydomain.com</a>
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Brennan" <Brennan@.discussions.microsoft.com> wrote in message
news:879832D4-68A3-4500-9410-D424A19C7EBC@.microsoft.com...
> Is it possible to store an email address as a hyperlink in SQL Server
> table?
> Thanks