email trigger

I'd like to setup a trigger to send an email, but can't use SQLMail because
I don't control the password to the account that is running the MSSQLSERVER
service. Is there any other way to have SQL send an email when an insert is
made to a particular table? Plus IT doesn't like the idea of Outlook
installed on a production server.You could use xp_smtp_mail. It requires that the ability to access a smtp
mail server. Quite 'safe' for a production server -unlike MAPI.
Mail -Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Colin" <legendsfan@.spamhotmail.com> wrote in message
news:%23IQu$hjxGHA.3892@.TK2MSFTNGP03.phx.gbl...
> I'd like to setup a trigger to send an email, but can't use SQLMail
> because I don't control the password to the account that is running the
> MSSQLSERVER service. Is there any other way to have SQL send an email
> when an insert is made to a particular table? Plus IT doesn't like the
> idea of Outlook installed on a production server.
>|||Hi Colin
It is not really advisable to send emails from triggers as you will
potentially be increasing the transaction time significantly and therefore
increasing contention (blocking/deadlocking etc..). An alternative would be
to populate another table and then periodically have a process that emails
the information and clears the table down.
John
"Colin" wrote:
> I'd like to setup a trigger to send an email, but can't use SQLMail because
> I don't control the password to the account that is running the MSSQLSERVER
> service. Is there any other way to have SQL send an email when an insert is
> made to a particular table? Plus IT doesn't like the idea of Outlook
> installed on a production server.
>
>

email trigger

I'd like to setup a trigger to send an email, but can't use SQLMail because
I don't control the password to the account that is running the MSSQLSERVER
service. Is there any other way to have SQL send an email when an insert is
made to a particular table? Plus IT doesn't like the idea of Outlook
installed on a production server.You could use xp_smtp_mail. It requires that the ability to access a smtp
mail server. Quite 'safe' for a production server -unlike MAPI.
Mail -Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Colin" <legendsfan@.spamhotmail.com> wrote in message
news:%23IQu$hjxGHA.3892@.TK2MSFTNGP03.phx.gbl...
> I'd like to setup a trigger to send an email, but can't use SQLMail
> because I don't control the password to the account that is running the
> MSSQLSERVER service. Is there any other way to have SQL send an email
> when an insert is made to a particular table? Plus IT doesn't like the
> idea of Outlook installed on a production server.
>|||Hi Colin
It is not really advisable to send emails from triggers as you will
potentially be increasing the transaction time significantly and therefore
increasing contention (blocking/deadlocking etc..). An alternative would be
to populate another table and then periodically have a process that emails
the information and clears the table down.
John
"Colin" wrote:

> I'd like to setup a trigger to send an email, but can't use SQLMail becaus
e
> I don't control the password to the account that is running the MSSQLSERVE
R
> service. Is there any other way to have SQL send an email when an insert
is
> made to a particular table? Plus IT doesn't like the idea of Outlook
> installed on a production server.
>
>

Email passwords

I am desigining an intranet site using vb.net/asp.net. The sql - users table has a username, password, e-mail address and date field (date is for when the user last updated there password). My login page etc is working fine, but what I want to do is when someone types in the wrong password, to send an email to the address from my users table giving them the correct password. I am not sure how to go about doing this and would appreciate any advice on this.I am desigining an intranet site using vb.net/asp.net. The sql - users table has a username, password, e-mail address and date field (date is for when the user last updated there password). My login page etc is working fine, but what I want to do is when someone types in the wrong password, to send an email to the address from my users table giving them the correct password. I am not sure how to go about doing this and would appreciate any advice on this.
Won't that be a bit dangerous and a security risk?
To E-mail the password when the user typed it wrong?
What if His/Her significant other or a friend or a neighbor takes a peek at the e-mail?
:mad:sql

Email

Do you know a tool for email sending that make authentication of user and
password in my server external smtp of my net and that she makes use of
format HTML? thanks!Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
"Database Mail".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> Do you know a tool for email sending that make authentication of user and
> password in my server external smtp of my net and that she makes use of
> format HTML? thanks!|||I use the 2000!
"Tibor Karaszi" wrote:
> Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
> SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
> "Database Mail".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
> news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> > Do you know a tool for email sending that make authentication of user and
> > password in my server external smtp of my net and that she makes use of
> > format HTML? thanks!
>
>

EM wants to confirm user's password

Hi,
I'm having a problem with Enterprise Manager. The problem is that, whenever
I use EM to modify a user's SQL Server account (any modification), EM will a
sk me to confirm the user's pasword. I don't know the user passwords. A few
months ago I read about
this problem but now I can't find any info and have forgotten where I read a
bout this bug. I have other tools to use to make changes so, I haven't worri
ed about it. But now, I want to fix the bug. On my desk top I'm running SQL
2000 client tools. Our serv
ers are mostly SQL 2000 with SP3 with a few SQL 7 SP4.
Any information would be helpful.
Thanks,
JoeSounds like this may be the bug you are referring to:
FIX: You Are Prompted for Password Confirmation After You
Change a Standard SQL Server Login
http://support.microsoft.com/?kbid=826161
-Sue
On Fri, 26 Mar 2004 11:16:08 -0800, Joe <joeydba@.yahoo.com>
wrote:

>Hi,
> I'm having a problem with Enterprise Manager. The problem is that, whenever I use
EM to modify a user's SQL Server account (any modification), EM will ask me to conf
irm the user's pasword. I don't know the user passwords. A few months ago I read ab
out
this problem but now I can't find any info and have forgotten where I read a
bout this bug. I have other tools to use to make changes so, I haven't worri
ed about it. But now, I want to fix the bug. On my desk top I'm running SQL
2000 client tools. Our ser
vers are mostly SQL 2000 with SP3 with a few SQL 7 SP4.
> Any information would be helpful.
>Thanks,
>Joe

EM losing Server registrations in XP

Hi all
Every time we change a users password in XP Pro, the
client PC looses all of the Server registrations within
SQL 2000 Enterprise Manger.
Anyone else experienced this, and found any solution to it.
CheersFIX: Registered Remote Servers Disappear from SQL Enterprise Manager in
Windows XP When Non-Domain User Password is Changed
http://support.microsoft.com/?id=323280
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:119e201c3f614$b9bc73a0$a101280a@.phx
.gbl...
> Hi all
> Every time we change a users password in XP Pro, the
> client PC looses all of the Server registrations within
> SQL 2000 Enterprise Manger.
> Anyone else experienced this, and found any solution to it.
> Cheers
>|||Thanks
We are running with SP3 already installed.
I will however give the registry tweak a go and see if it
makes a difference
Cheers
>--Original Message--
>FIX: Registered Remote Servers Disappear from SQL
Enterprise Manager in
>Windows XP When Non-Domain User Password is Changed
>http://support.microsoft.com/?id=323280
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
><anonymous@.discussions.microsoft.com> wrote in message
> news:119e201c3f614$b9bc73a0$a101280a@.phx
.gbl...
it.
>
>.
>

E-learning Course in SQL

I started a course and got to the lab section. It asked for a password giving me the name of student. I don't know if I was given a password when subscribing for the course. Certainly no in the confirmation email.

Where did I go wrong?

John.

You didn't write down the information or save the email.|||

Hi Arnie,

Thanks for the reply.

I have contacted Microsoft.

I received only one email confilrming payment. It contains no passwods etc.

There may have been something on screen. I am usually very careful to make multiple copies of such info.

Thanks anyway.

John

|||

Who is the class being offered through? Can you contact their customer support to obtain your info and get you back on track?

Thanks,
Sam Lester (MSFT)

|||When you click launch on the left there may be a menu option All content, click that and search in the opened window for Password. I found out this from another website|||

Hi all,

That is the answer.

It only appears when one prints or right clicks and opens. The text in that area otherwise does not give any hint of a logon procedure.

Well done! )

John