Alerts SP3 Vs SP4

Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem?
Any help is appreciated.
Thanks.You mean notification thought NET SEND? If so, verify that the windows services are started (alerter
and messenger), I believe the services are disables with more recent of OS and service pack.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
> Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
> Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem?
> Any help is appreciated.
> Thanks.|||That was it. Thank you very much.
"Tibor Karaszi" wrote:
> You mean notification thought NET SEND? If so, verify that the windows services are started (alerter
> and messenger), I believe the services are disables with more recent of OS and service pack.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "KMP" <KMP@.discussions.microsoft.com> wrote in message
> news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
> > Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
> > Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem?
> > Any help is appreciated.
> >
> > Thanks.
>

Alerts SP3 Vs SP4

Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem?
Any help is appreciated.
Thanks.
You mean notification thought NET SEND? If so, verify that the windows services are started (alerter
and messenger), I believe the services are disables with more recent of OS and service pack.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
> Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
> Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem?
> Any help is appreciated.
> Thanks.
|||That was it. Thank you very much.
"Tibor Karaszi" wrote:

> You mean notification thought NET SEND? If so, verify that the windows services are started (alerter
> and messenger), I believe the services are disables with more recent of OS and service pack.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "KMP" <KMP@.discussions.microsoft.com> wrote in message
> news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
>

Alerts SP3 Vs SP4

Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem
?
Any help is appreciated.
Thanks.You mean notification thought NET SEND? If so, verify that the windows servi
ces are started (alerter
and messenger), I believe the services are disables with more recent of OS a
nd service pack.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
> Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
> Server 2000 SP3 and saw an alert window pop up. Has anyone seen this probl
em?
> Any help is appreciated.
> Thanks.|||That was it. Thank you very much.
"Tibor Karaszi" wrote:

> You mean notification thought NET SEND? If so, verify that the windows ser
vices are started (alerter
> and messenger), I believe the services are disables with more recent of OS
and service pack.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "KMP" <KMP@.discussions.microsoft.com> wrote in message
> news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
>

Alerts Not Working

I defined an Alert in Enterprise Manager for Severity 19 - Fatal Error In Resource. The alert is enabled, the type is "sql server event alert" and the alert is defined against a specific database. SQLSERVERAGENT and SQL Mail session are both started. I test the alert using the following statement in the specified database.

raiserror (50001,19,1) with log

A message is placed in the SQL Server log, however no alert is fired. The alert history indicates the alert has never occurred. What am I missing?

Thanks, DaveHere's an update.

I refreshed EM earlier in the day and still saw no history. This time I disconnected and reconnected the instance. For some reason I have to do this in certain situations. After reconnecting I noticed a history existed under a demo for Severity 19. I didn't realize the demos were enabled. I just disabled the demo alert and all appears to be working.

Thanks, Dave|||all the demos are enabled for each of the severity levels if you are defining errors soley based on severity they will as you found out hit first
also ...
[BOL] Says

Error messages with a severity level of 19 or higher stop the current batch. Errors messages with a severity level of 20 or higher are considered fatal errors and terminate the client connection. Errors messages in this range may affect all of the processes in the database, and may indicate that a database or object is damaged. Error messages with a severity level from 19 through 25 are written to the error log.

you might want to consider refining your alert to fire on the event id's that are acutally being thrown..
just a suggest

by the way good debugging on your part.|||The error message I'm seeing is being generated by a vendor's software package.

Error: 1204, Severity: 19, State: 1
The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration..

There are multiple performance problems associated with this application. I suspect the error above is connected to many of the problems. I don't believe the database is damaged. I'm guessing it's just a matter of poorly written code. Now I have to figure out how to setup Profiler to look for this error.

Thanks, Dave|||http://www.sql-server-performance.com/deadlocks.asp to prevent deadlocks and error defined.

Ensure to run the statement in batches if it is affecting large number of rows. Another option is to specify a hint like table or page lock so that the number of locks can be reduced.

What are lock settings defined at SQL server?|||The lock setting is still at the default of 0. I'm not sure what code is causing this problem to occur. I need to setup Profiler to trap the logic. I just setup Profiler to look for Severity 19, but the filter does not appear to be working. I'm still seeing all server activity. Am I missing something?

- Filters
- Severity
- Equals 19

Dave|||Oh, then follow this link http://www.sql-server-performance.com/blocking.asp to monitor the blocking and capture the trace.|||Not missing much about profiler. Any null value is returned as a valid hit. You may want to just run profiler to a table with the SQL statement complete, RPC complete, and some of the error events getting logged. Once you have a pile of data in a table, you can run queries off of that for severity 19, then try to work back via the identity column to figure out what statement did it.|||Can you tell Profiler to ignore NULL?

I'll give your suggestion a try.

Thankssql

Alerts not firing off jobs.

sql2k
sp3
Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
checked to fire off a job when it occurs. I then generate a deadlock, but the
job never gets fired off. Some important fun facts:
1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
2; I've tried running different jobs manually. They both work.Is the alert itself firing? Make sure that the EventLog
service and SQL Agent are running. Check the Event log to
make sure that it is not full. Check if the event is writing
to the Application log. There is also a topic in books
online with more information on troubleshooting alerts.
Check the topic: Troubleshooting Alerts
-Sue
On Thu, 13 Apr 2006 15:36:02 -0700, ChrisR
<ChrisR@.discussions.microsoft.com> wrote:
>sql2k
>sp3
>Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
>checked to fire off a job when it occurs. I then generate a deadlock, but the
>job never gets fired off. Some important fun facts:
>1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
>2; I've tried running different jobs manually. They both work.
>

Alerts not firing off jobs.

sql2k
sp3
Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
checked to fire off a job when it occurs. I then generate a deadlock, but th
e
job never gets fired off. Some important fun facts:
1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
2; I've tried running different jobs manually. They both work.Is the alert itself firing? Make sure that the EventLog
service and SQL Agent are running. Check the Event log to
make sure that it is not full. Check if the event is writing
to the Application log. There is also a topic in books
online with more information on troubleshooting alerts.
Check the topic: Troubleshooting Alerts
-Sue
On Thu, 13 Apr 2006 15:36:02 -0700, ChrisR
<ChrisR@.discussions.microsoft.com> wrote:

>sql2k
>sp3
>Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox
>checked to fire off a job when it occurs. I then generate a deadlock, but t
he
>job never gets fired off. Some important fun facts:
>1; I ran dbcc traceon with 1205 and 1205 to log deadlocks.
>2; I've tried running different jobs manually. They both work.
>

Alerts for SQL Service stoppages

Does anyone know if there is a way to get a page alert if SQL Service stops?Andre,
On Windows 2003 and XP you can specify actions on service failures, both in
itial and subsequent.
a command line email client could take it from there ( Recovery tab of a ser
vice's properties ).
If you are on a lower OS then depending on your enthusiasm, it is possible t
o write your own
service to monitor other services, including stopping and starting them, usi
ng API calls to the
service control manager.
If there is any easier way, it's not one I've used !
Regards
AJ
"Andre" <anonymous@.discussions.microsoft.com> wrote in message
news:D7A53734-28F0-418E-8BD2-4898AFFACDD1@.microsoft.com...
> Does anyone know if there is a way to get a page alert if SQL Service stops?[/colo
r]

Alerts for new login accounts

Hi all,
Looking for a method on sql server 2k of automated monitoring and
notification of creation of new login accts. When new login is created,
alert would go to one or more IT mgt people, perhaps also mgt of business
unit that use the database.
We use Blat (freeware email util) for sending emails & alerts. Situation
is we want to grant SecurityAdmin rights to one or two individuals (up to
now only sa acct/server admin accts have been used) to be able to review
sql error logs. Best I can tell, we have to grant them the Security Admin
role to do that through Enterprise Manager. However this also gives them
the right to create login accounts, so they could create their own login
acct, go in and browse around data they have no business looking at, then
delete the login account.
I have looked around, found that triggers are not supported on system
tables (idea was to create trigger on sysxlogins). Best I could find was a
method of using a scheduled sql agent job to capture data from the
sysprocesses table and record connections that are not in a "not" list to
the server event log:
http://www.databasejournal.com/feat...cle.php/2243271
thksIf you only want the users to be able to view the SQL Server
error logs, why not just grant them permissions to view the
log file at the OS level? The logs are just text files -
they can view them without using Enterprise Manager and
without having access to SQL Server.
If you did want to monitor for the addition of logins, with
SQL Server 2000 you can capture the addition of logins,
database users, adding logins/users to server/database
roles, etc using Profiler (or a server side trace). You can
find the events you can monitor in books online in the
topic: Security Audit Event Classes.
-Sue
On Tue, 1 Jun 2004 10:26:06 -0700, "GM"
<anonymous@.discussions.microsoft.com> wrote:

>Hi all,
>Looking for a method on sql server 2k of automated monitoring and
>notification of creation of new login accts. When new login is created,
>alert would go to one or more IT mgt people, perhaps also mgt of business
>unit that use the database.
>We use Blat (freeware email util) for sending emails & alerts. Situation
>is we want to grant SecurityAdmin rights to one or two individuals (up to
>now only sa acct/server admin accts have been used) to be able to review
>sql error logs. Best I can tell, we have to grant them the Security Admin
>role to do that through Enterprise Manager. However this also gives them
>the right to create login accounts, so they could create their own login
>acct, go in and browse around data they have no business looking at, then
>delete the login account.
>I have looked around, found that triggers are not supported on system
>tables (idea was to create trigger on sysxlogins). Best I could find was a
>method of using a scheduled sql agent job to capture data from the
>sysprocesses table and record connections that are not in a "not" list to
>the server event log:
>http://www.databasejournal.com/feat...cle.php/2243271
>thks

Alerts for failed backups

I want to setup an alert to let me know when backups fail (they mainly fail
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
CraigIf the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notification.
"Craig HB" wrote:
> I want to setup an alert to let me know when backups fail (they mainly fail
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craig

Alerts for failed backups

I want to setup an alert to let me know when backups fail (they mainly fail
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
Craig
If the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notification.
"Craig HB" wrote:

> I want to setup an alert to let me know when backups fail (they mainly fail
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craig

Alerts for failed backups

I want to setup an alert to let me know when backups fail (they mainly fail
when we run out of disk space).
Also, can you setup an alert to let you know when a disk is fulling up (we
have that problem on the disk that contains our MDF files).
Thanks,
CraigIf the backup is a scheduled job, setup operators and then set the
notifications. You can also write queries to read the sysjobs table and
serach for failure. Use XP_sendmail to send a message to your
pager/phone/home email.
Use the FSO to write a little win32 app to examine disk space and if it
begins to fill up, run a procedure/jhob, etc. that performs the notificatio
n.
"Craig HB" wrote:

> I want to setup an alert to let me know when backups fail (they mainly fai
l
> when we run out of disk space).
> Also, can you setup an alert to let you know when a disk is fulling up (we
> have that problem on the disk that contains our MDF files).
> Thanks,
> Craigsql

Alerts and Jobs for transaction log processing

Scenario: I have an alert defined which monitors the transaction log. It should start a job which should backup the transaction log once the log is 75 percent full.

So far so good.

The challenge is to give the database name to the command for backing up (in our case it is a external tool) the appropriate transaction log

I know, that you can use tokens (A-DBN) to do this.

I know, that there is a bug in this area, so tokens are not set correctly in SP1

Question:

Is there any trick/alternative to create a workaround?

Regards

Norbert

If you created a WMI Event alert you may be able to read the Database name as part of the event $(WMI(DatabaseName))

alerts

How can I set an alert to email me when a Login fails? I have been getting
several "Login failed for user '(null)'. Reason : Not associated witha
trusted SQL Server Connection." I need to find out what web site is doing
this.You can create alerts for specific error numbers - this one
I think is error number 18452
I don't think that will help you find out what web site is
failing causing the error. You'd probably have to monitor at
the network level.
-Sue
On Thu, 25 Aug 2005 11:01:06 -0700, "Rich"
<Rich@.discussions.microsoft.com> wrote:
>How can I set an alert to email me when a Login fails? I have been getting
>several "Login failed for user '(null)'. Reason : Not associated witha
>trusted SQL Server Connection." I need to find out what web site is doing
>this.

alerts

How can I set an alert to email me when a Login fails? I have been getting
several "Login failed for user '(null)'. Reason : Not associated witha
trusted SQL Server Connection." I need to find out what web site is doing
this.
You can create alerts for specific error numbers - this one
I think is error number 18452
I don't think that will help you find out what web site is
failing causing the error. You'd probably have to monitor at
the network level.
-Sue
On Thu, 25 Aug 2005 11:01:06 -0700, "Rich"
<Rich@.discussions.microsoft.com> wrote:

>How can I set an alert to email me when a Login fails? I have been getting
>several "Login failed for user '(null)'. Reason : Not associated witha
>trusted SQL Server Connection." I need to find out what web site is doing
>this.
sql

alerts

How can I set an alert to email me when a Login fails? I have been getting
several "Login failed for user '(null)'. Reason : Not associated witha
trusted SQL Server Connection." I need to find out what web site is doing
this.You can create alerts for specific error numbers - this one
I think is error number 18452
I don't think that will help you find out what web site is
failing causing the error. You'd probably have to monitor at
the network level.
-Sue
On Thu, 25 Aug 2005 11:01:06 -0700, "Rich"
<Rich@.discussions.microsoft.com> wrote:

>How can I set an alert to email me when a Login fails? I have been getting
>several "Login failed for user '(null)'. Reason : Not associated witha
>trusted SQL Server Connection." I need to find out what web site is doing
>this.

Alert When SQL Server shuts down

Hello All
Does anybody know of a way to send a mail, when the SQL Server shuts down. I
am not able to find any help with regard to that.
Advanced thanks for any body who could provide me information
Saravanan
Sorry forgot about other stuff.
OS: Windows 2000 Server
SQL Server 2000
Saravanan
"Saravanan" wrote:

> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down. I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan
|||last time I had to do this, I used a different sql server to attempt a
connection and alert if it failed.
Barring that, you'll need to be looking at it from the perspective of the
SQL Server service
Kevin3NF
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...[vbcol=seagreen]
> Sorry forgot about other stuff.
> OS: Windows 2000 Server
> SQL Server 2000
> --
> Saravanan
>
> "Saravanan" wrote:
|||If you want to set something up yourself, you need to proble the SQL instance
at a regular interval from a different machine, and if the proble can't
connect to the instance, it fires off an email. This is a standard approach
in any monitoring tool. But for this kind of stuff, you may be better off to
get a monitoring package since this will not be the only thing you want to
monitor.
Linchi
"Saravanan" wrote:

> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down. I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan
|||Could you please point me to any links on how to do this?
Saravanan
"Kevin3NF" wrote:

> last time I had to do this, I used a different sql server to attempt a
> connection and alert if it failed.
> Barring that, you'll need to be looking at it from the perspective of the
> SQL Server service
> Kevin3NF
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...
>
>
|||Could you please point me to any links please on how to do this?
Saravanan
"Linchi Shea" wrote:
[vbcol=seagreen]
> If you want to set something up yourself, you need to proble the SQL instance
> at a regular interval from a different machine, and if the proble can't
> connect to the instance, it fires off an email. This is a standard approach
> in any monitoring tool. But for this kind of stuff, you may be better off to
> get a monitoring package since this will not be the only thing you want to
> monitor.
> Linchi
> "Saravanan" wrote:

Alert When SQL Server shuts down

Hello All
Does anybody know of a way to send a mail, when the SQL Server shuts down. I
am not able to find any help with regard to that.
Advanced thanks for any body who could provide me information
--
SaravananSorry forgot about other stuff.
OS: Windows 2000 Server
SQL Server 2000
--
Saravanan
"Saravanan" wrote:

> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down.
I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan|||last time I had to do this, I used a different sql server to attempt a
connection and alert if it failed.
Barring that, you'll need to be looking at it from the perspective of the
SQL Server service
Kevin3NF
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...[vbcol=seagreen]
> Sorry forgot about other stuff.
> OS: Windows 2000 Server
> SQL Server 2000
> --
> Saravanan
>
> "Saravanan" wrote:
>|||If you want to set something up yourself, you need to proble the SQL instanc
e
at a regular interval from a different machine, and if the proble can't
connect to the instance, it fires off an email. This is a standard approach
in any monitoring tool. But for this kind of stuff, you may be better off to
get a monitoring package since this will not be the only thing you want to
monitor.
Linchi
"Saravanan" wrote:

> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down.
I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan|||Could you please point me to any links on how to do this?
--
Saravanan
"Kevin3NF" wrote:

> last time I had to do this, I used a different sql server to attempt a
> connection and alert if it failed.
> Barring that, you'll need to be looking at it from the perspective of the
> SQL Server service
> Kevin3NF
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...
>
>|||Could you please point me to any links please on how to do this?
--
Saravanan
"Linchi Shea" wrote:
[vbcol=seagreen]
> If you want to set something up yourself, you need to proble the SQL insta
nce
> at a regular interval from a different machine, and if the proble can't
> connect to the instance, it fires off an email. This is a standard approac
h
> in any monitoring tool. But for this kind of stuff, you may be better off
to
> get a monitoring package since this will not be the only thing you want to
> monitor.
> Linchi
> "Saravanan" wrote:
>

Alert When SQL Server shuts down

Hello All
Does anybody know of a way to send a mail, when the SQL Server shuts down. I
am not able to find any help with regard to that.
Advanced thanks for any body who could provide me information
--
SaravananSorry forgot about other stuff.
OS: Windows 2000 Server
SQL Server 2000
--
Saravanan
"Saravanan" wrote:
> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down. I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan|||last time I had to do this, I used a different sql server to attempt a
connection and alert if it failed.
Barring that, you'll need to be looking at it from the perspective of the
SQL Server service
Kevin3NF
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...
> Sorry forgot about other stuff.
> OS: Windows 2000 Server
> SQL Server 2000
> --
> Saravanan
>
> "Saravanan" wrote:
>> Hello All
>> Does anybody know of a way to send a mail, when the SQL Server shuts
>> down. I
>> am not able to find any help with regard to that.
>> Advanced thanks for any body who could provide me information
>> --
>> Saravanan|||If you want to set something up yourself, you need to proble the SQL instance
at a regular interval from a different machine, and if the proble can't
connect to the instance, it fires off an email. This is a standard approach
in any monitoring tool. But for this kind of stuff, you may be better off to
get a monitoring package since this will not be the only thing you want to
monitor.
Linchi
"Saravanan" wrote:
> Hello All
> Does anybody know of a way to send a mail, when the SQL Server shuts down. I
> am not able to find any help with regard to that.
> Advanced thanks for any body who could provide me information
> --
> Saravanan|||Could you please point me to any links on how to do this?
--
Saravanan
"Kevin3NF" wrote:
> last time I had to do this, I used a different sql server to attempt a
> connection and alert if it failed.
> Barring that, you'll need to be looking at it from the perspective of the
> SQL Server service
> Kevin3NF
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:01643CF2-633F-45C4-B190-3A9F15705DC0@.microsoft.com...
> > Sorry forgot about other stuff.
> > OS: Windows 2000 Server
> > SQL Server 2000
> > --
> > Saravanan
> >
> >
> > "Saravanan" wrote:
> >
> >> Hello All
> >> Does anybody know of a way to send a mail, when the SQL Server shuts
> >> down. I
> >> am not able to find any help with regard to that.
> >>
> >> Advanced thanks for any body who could provide me information
> >> --
> >> Saravanan
>
>|||Could you please point me to any links please on how to do this?
--
Saravanan
"Linchi Shea" wrote:
> If you want to set something up yourself, you need to proble the SQL instance
> at a regular interval from a different machine, and if the proble can't
> connect to the instance, it fires off an email. This is a standard approach
> in any monitoring tool. But for this kind of stuff, you may be better off to
> get a monitoring package since this will not be the only thing you want to
> monitor.
> Linchi
> "Saravanan" wrote:
> > Hello All
> > Does anybody know of a way to send a mail, when the SQL Server shuts down. I
> > am not able to find any help with regard to that.
> >
> > Advanced thanks for any body who could provide me information
> > --
> > Saravanansql

Alert when backup fails

I am using SQL Server 2000, and I would like to configure an email alert to
occur when any backup job on the server fails. I have SQL Mail working,but
I don't see any obvious option in Alerts that would trigger a notification
when a backup job fails. I did a google search on the subject in this
newsgroup, and found several people asking this question, but none were
answered. Is there a way to configure an alert like this? Surely there
must be a way to accomplish this."J.Marsch" <jeremy@.ctcdeveloper.com> wrote in message
news:uH%23BFLQlDHA.1656@.tk2msftngp13.phx.gbl...
> I am using SQL Server 2000, and I would like to configure an email alert
to
> occur when any backup job on the server fails. I have SQL Mail
working,but
> I don't see any obvious option in Alerts that would trigger a notification
> when a backup job fails. I did a google search on the subject in this
> newsgroup, and found several people asking this question, but none were
> answered. Is there a way to configure an alert like this? Surely there
> must be a way to accomplish this.
>
The easiest way is probably to have scheduled jobs for the backups, then
send a notification if the job fails.
Simon|||Hello,
Thanks for Simon's help. I agree with him. Also, I'm including some
supplemental information below:
SQL Server Agent Mail (the SQLAgentMail service) can use its own domain
account and mail profile, rather than the one set up for SQL Mail. With SQL
Server, you can configure SQL Agent Mail to send e-mail messages when:
1. An alert is triggered.
Alerts can be configured to send e-mail notification of specific events
that occur without implementing SQL Mail. For example, alerts can be
configured to notify an operator of a particular database event that may
need immediate action.
2. A scheduled task (such as a database backup or replication event)
succeeds or fails.
E-mail messages can be sent to a list of recipients informing them of the
status of scheduled jobs for possible user action. You can expand the
capabilities of jobs to include sending a result set by e-mail to a list of
recipients. For example, a monthly inventory report could send SQL Agent
Mail notification to the designated operators and the result set to the
purchasing manager and supplier.
In this case, we can set the "E-mail operator" option in Notifications Tab
of Job Properties to send a notification when a database backup job failed.
E-mail operator specifies that an operator is notified by e-mail when a
Microsoft? SQL Server? event completes. Select the name of the operator to
notify by e-mail, or click the browse (...) button to add a new operator or
edit the properties of an existing operator. Also, select the completion
status about which the operator will be notified.
For additional information regarding this issue, please refer to the
following articles on the SQL Server Books Online.
Topic: "SQL Mail"
Topic: "Job Properties (Notifications Tab)"
Please feel free to let me know if this solves your problem or if you would
like further assistance.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Alert User of Invalid Parameter Entry

Does anyone know if there is a way to alert the user that the parameter
value is invalid prior to the report rendering?
One of the parameters is an account number '########'. The user is
accustomed to seeing it as '###-####-#' and may enter it in that
format. I've already put the usual '(With no dashes)' next to the
prompt. However, if they do put dashes, (or some other invalid format),
the report runs as normal and spits out a blank report.
I would like the user to be aware of invalid parameter entries, similar
to a web app, or windows form.
TIA.On Dec 21, 11:06 am, Michael <Mich...@.discussions.microsoft.com>
wrote:
> Does anyone know if there is a way to alert the user that the parameter
> value is invalid prior to the report rendering?
> One of the parameters is an account number '########'. The user is
> accustomed to seeing it as '###-####-#' and may enter it in that
> format. I've already put the usual '(With no dashes)' next to the
> prompt. However, if they do put dashes, (or some other invalid format),
> the report runs as normal and spits out a blank report.
> I would like the user to be aware of invalid parameter entries, similar
> to a web app, or windows form.
> TIA.
There are a couple different things you can do. Either you can add a
textbox control to the report and set it to an expression like:
=iif(InStr(Parameters!AcctNumber.Value, "-") > 0, "Invalid Account
Number", Nothing)
-or-
You can do a replace on the Acct Number parameter entered by the user
via an expression in your dataset. An expression like this might help.
=Replace(Parameters!AcctNumber.Value, "-", "")
and you can embed them in each other to catch other stray characters
(i.e., remove all hyphens and asterisks)
=Replace(Replace(Parameters!AcctNumber.Value, "-", ""), "*", "")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant