email for db changes

Other than Log Explorer, is there a tool that can email me whenever db
changes are made? (Tables/ Procs/ etc.)
TIA, ChrisRwww.LogPi.com, but no e-mails.
Wait for SQL 2005 where this functionality is provided for system tables.
For SQL server 2000 and 2005, user table auditing is best done though
triggers.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ChrisR" <noemail@.bla.com> wrote in message
news:%2390HsdwNFHA.3988@.tk2msftngp13.phx.gbl...
> Other than Log Explorer, is there a tool that can email me whenever db
> changes are made? (Tables/ Procs/ etc.)
> TIA, ChrisR
>

email for db changes

Other than Log Explorer, is there a tool that can email me whenever db
changes are made? (Tables/ Procs/ etc.)
TIA, ChrisR
www.LogPi.com, but no e-mails.
Wait for SQL 2005 where this functionality is provided for system tables.
For SQL server 2000 and 2005, user table auditing is best done though
triggers.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ChrisR" <noemail@.bla.com> wrote in message
news:%2390HsdwNFHA.3988@.tk2msftngp13.phx.gbl...
> Other than Log Explorer, is there a tool that can email me whenever db
> changes are made? (Tables/ Procs/ etc.)
> TIA, ChrisR
>

email for db changes

Other than Log Explorer, is there a tool that can email me whenever db
changes are made? (Tables/ Procs/ etc.)
TIA, ChrisRwww.LogPi.com, but no e-mails.
Wait for SQL 2005 where this functionality is provided for system tables.
For SQL server 2000 and 2005, user table auditing is best done though
triggers.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ChrisR" <noemail@.bla.com> wrote in message
news:%2390HsdwNFHA.3988@.tk2msftngp13.phx.gbl...
> Other than Log Explorer, is there a tool that can email me whenever db
> changes are made? (Tables/ Procs/ etc.)
> TIA, ChrisR
>

Email Attachements

Whenever I try to create an attachment with email, the attachment is created
but it is empyu in the case of Excel or I get an open error when creating a
PDF file attachment. If insted of using email, I create a file on a server
share it works fine and I see the report. Also if I include a link on the
email that works fine also and I see the report. It's only the attachments
that aren't working. We are using Lotus Notes for our email system.It's a known bug. Apply the hotfix described in M$ KB # 872774
X
"Jeff" wrote:
> Whenever I try to create an attachment with email, the attachment is created
> but it is empyu in the case of Excel or I get an open error when creating a
> PDF file attachment. If insted of using email, I create a file on a server
> share it works fine and I see the report. Also if I include a link on the
> email that works fine also and I see the report. It's only the attachments
> that aren't working. We are using Lotus Notes for our email system.|||A hotfix has been issued for this issue:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:A8509E81-7A2C-460F-B82E-F4D06B8C4A83@.microsoft.com...
> Whenever I try to create an attachment with email, the attachment is
> created
> but it is empyu in the case of Excel or I get an open error when creating
> a
> PDF file attachment. If insted of using email, I create a file on a
> server
> share it works fine and I see the report. Also if I include a link on the
> email that works fine also and I see the report. It's only the
> attachments
> that aren't working. We are using Lotus Notes for our email system.

Email Alert in SQL Server2000

can somebody help me to setup email alerts in SQL Server 2000 standard edition whenever, backup is successful OR failed to complete.

Thanks,

I'll assume you're doing scheduled backups via SQL Server Agent

1. Configure SQL Server to use SQL Mail (Check Books Online SQL Mail)

2. Add an operator to SQL Server Agent with the relevant email address

3. In your SQL Job, notifications tab, check the box to email, select your operator and also selec to alert whenever the job completes.

HTH!

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 Script Error

I've have a minor problem with my enterprise manager. Whenever I try to look at the database screen I get the following pop-up, and then it just leaves the screen saying "Loading Database Information"

I tried a ground up re-install of the EM, no joy. I'm running a Dell GX260 with WinXP SP1.

Any ideas. It's just an annoyance.Think there is a problem with SQL installation. Try re-installing the SQL.|||I did re-install the SQL. Still no luck.|||do onething, open any other MMC and add SQL Server in that.|||Same error. :(|||Then there is a problem with your service pack.