Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL

Apparently the query analyser of sql server does not recognise a
database with a point in it, like
mail.archive.mdf

I receive the following error when I use it:

Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'mail'. No entry
found with that name. Make sure that the name is entered correctly.

Please help, thanks
Premselect * from master..sysdatabases
where name ='mail.archive'

mdf is not part of the name

Denis the SQL Menace
http://sqlservercode.blogspot.com/

Prem wrote:
> Apparently the query analyser of sql server does not recognise a
> database with a point in it, like
> mail.archive.mdf
> I receive the following error when I use it:
> Server: Msg 911, Level 16, State 1, Line 1
> Could not locate entry in sysdatabases for database 'mail'. No entry
> found with that name. Make sure that the name is entered correctly.
> Please help, thanks
> Prem|||Prem (premmetje@.zonnet.nl) writes:
> Apparently the query analyser of sql server does not recognise a
> database with a point in it, like
> mail.archive.mdf
> I receive the following error when I use it:
> Server: Msg 911, Level 16, State 1, Line 1
> Could not locate entry in sysdatabases for database 'mail'. No entry
> found with that name. Make sure that the name is entered correctly.

Need to use brackets or double quotes for identifiers with characters
that are not identifier characters normally:

USE [mail.archive.mdf]

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Database Maintenance plans log

I receive every 30 min 5 event into my event viewer application log telling
me something like this
18265 :
Log backed up: Database: UserDatabases, creation date(time):
2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
devices: 1, device information: (FILE=1, TYPE=DISK:
{'H:\SQLBackup\UserDatabases\UserDatabases_tlog_20 0505120800.TRN'}).
Is there a way to remove the log to event viewer from a maintenante plan?
First its not giving anything good and its hard to find error since my event
viewer is full of those information.
Hi
You might be logging it into an Event Viewer. Just try to update the same or
try to remove the logging
best Regards,
Chandra
http://chanduas.blogspot.com/
"fatp" wrote:

> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_20 0505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>
|||Short answer: No. These entries are not written by Maint Plan nor by Agent. They are written by SQL
Server. Each time SQL Server does a backup, it will write that to the eventlog. For other error
messages, you can configure whether they should be written to the eventlog or not, but that
configuration (sp_altermessage) is ignored for backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"fatp" <fatp@.discussions.microsoft.com> wrote in message
news:AC8C5172-D6CA-4E33-8F36-D7D59B822692@.microsoft.com...
> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_20 0505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>

Database Maintenance plans log

I receive every 30 min 5 event into my event viewer application log telling
me something like this
18265 :
Log backed up: Database: UserDatabases, creation date(time):
2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
devices: 1, device information: (FILE=1, TYPE=DISK:
{'H:\SQLBackup\UserDatabases\UserDatabases_tlog_200505120800.TRN'}).
Is there a way to remove the log to event viewer from a maintenante plan?
First its not giving anything good and its hard to find error since my event
viewer is full of those information.Hi
You might be logging it into an Event Viewer. Just try to update the same or
try to remove the logging
--
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"fatp" wrote:
> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>|||Short answer: No. These entries are not written by Maint Plan nor by Agent. They are written by SQL
Server. Each time SQL Server does a backup, it will write that to the eventlog. For other error
messages, you can configure whether they should be written to the eventlog or not, but that
configuration (sp_altermessage) is ignored for backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"fatp" <fatp@.discussions.microsoft.com> wrote in message
news:AC8C5172-D6CA-4E33-8F36-D7D59B822692@.microsoft.com...
> I receive every 30 min 5 event into my event viewer application log telling
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> {'H:\SQLBackup\UserDatabases\UserDatabases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my event
> viewer is full of those information.
>

Database Maintenance plans log

I receive every 30 min 5 event into my event viewer application log telling
me something like this
18265 :
Log backed up: Database: UserDatabases, creation date(time):
2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dum
p
devices: 1, device information: (FILE=1, TYPE=DISK:
& #123;'H:\SQLBackup\UserDatabases\UserDat
abases_tlog_200505120800.TRN'}).
Is there a way to remove the log to event viewer from a maintenante plan?
First its not giving anything good and its hard to find error since my event
viewer is full of those information.Hi
You might be logging it into an Event Viewer. Just try to update the same or
try to remove the logging
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"fatp" wrote:

> I receive every 30 min 5 event into my event viewer application log telli
ng
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of d
ump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> & #123;'H:\SQLBackup\UserDatabases\UserDat
abases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my eve
nt
> viewer is full of those information.
>|||Short answer: No. These entries are not written by Maint Plan nor by Agent.
They are written by SQL
Server. Each time SQL Server does a backup, it will write that to the eventl
og. For other error
messages, you can configure whether they should be written to the eventlog o
r not, but that
configuration (sp_altermessage) is ignored for backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"fatp" <fatp@.discussions.microsoft.com> wrote in message
news:AC8C5172-D6CA-4E33-8F36-D7D59B822692@.microsoft.com...
> I receive every 30 min 5 event into my event viewer application log tellin
g
> me something like this
> 18265 :
> Log backed up: Database: UserDatabases, creation date(time):
> 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of d
ump
> devices: 1, device information: (FILE=1, TYPE=DISK:
> & #123;'H:\SQLBackup\UserDatabases\UserDat
abases_tlog_200505120800.TRN'}).
>
> Is there a way to remove the log to event viewer from a maintenante plan?
> First its not giving anything good and its hard to find error since my eve
nt
> viewer is full of those information.
>

Database mail configuration

I have configured database mail using the wizard, but when I try to send a test message I receive the following error:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 Exception Message: Cannot send mails to mail server. (Failure sending mail.)

Is there some more configuration I must do? I have enabled mail using the surface area configurator.

Thanks

I would try using xpsmtp mail and forget standard SQL mail...it is a pain in the rear. You can get it (yes it is free) here http://www.sqldev.net/xp/xpsmtp.htm

It is easy to set up and use and has teriffic documentation.

I know this is not an answer to your question but I hope this helps some.

Regards,

Brad Feaker
|||We are using SQL Server 2005 and its database mail option, not the old SQL mail that 7 and 2000 use.|||Sorry about that - I should have noticed your mention of the Surface Area Configurator. My bad! I don't have any experience setting up SQL Mail in 2005 yet. Hope you get an answer soon. No one seems to be able to answer my question either...Good luck!!!
|||

Hi Tim,

I had the same problem as yours and I solved it configuring the Relay options of my SMTP server.

HTH,

DATABASE Mail Account Setup Error

When I attempt to setup a new Mail Account using the GUI I receive error:
Cannot insert the value NULL into 'servername', table
'msdb.dbo.sysmail_server'
column does not allow Nulls.
I feel in all the fields on the Account Setup Screen and put in a valid smtp
server name or the IP. Then it fails. If i run the stored proc that sets up
the account, sysmail_add_account_sp, it works. After I run the sp I go into
the modify the account and it looks just like it did when I ran the GUI.
I am running 2005 on a virtual server.
Any help would be appreciated.
On Mar 15, 1:50 pm, Thom <T...@.discussions.microsoft.com> wrote:
> When I attempt to setup a new Mail Account using the GUI I receive error:CannotinsertthevalueNULLinto'servername',tab le
> 'msdb.dbo.sysmail_server'columndoes not allow Nulls.
> I feel in all the fields on the Account Setup Screen and put in a valid smtp
> server name or the IP. Then it fails. If i run the stored proc that sets up
> the account, sysmail_add_account_sp, it works. After I run the sp I gointo
> the modify the account and it looks just like it did when I ran the GUI.
> I am running 2005 on a virtual server.
> Any help would be appreciated.
Don't use the wizard. I was having the same problem and ended up
scripting it out instead:
from: http://www.sql-server-performance.com/da_email_functionality.asp
EXECUTE msdb.dbo.sysmail_add_account_sp
@.account_name = 'Dinesh',
@.description = 'Dinesh Mail on dynanet.',
@.email_address = 'dinesh@.dynanet.com',
@.display_name = 'Dinesh Asanka',
@.mailserver_name = 'mail.dynanet.com'
Use the sysmail_add_profile procedure to create a Database Mail
profile called Dinesh Mail Profile:
EXECUTE msdb.dbo.sysmail_add_profile_sp
@.profile_name = 'Dinesh',
@.description = 'Dinesh Profile'
User the sysmail_add_profileaccount procedure to add the Database Mail
account and Database Mail profile you created in previous steps.
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@.profile_name = 'Dinesh',
@.account_name = 'Dinesh',
@.sequence_number = 1
Use the sysmail_add_principalprofile procedure to grant the Database
Mail profile access to the msdb public database role and to make the
profile the default Database Mail profile:
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@.profile_name = 'Dinesh',
@.principal_name = 'public',
@.is_default = 1 ;

DATABASE Mail Account Setup Error

When I attempt to setup a new Mail Account using the GUI I receive error:
Cannot insert the value NULL into 'servername', table
'msdb.dbo.sysmail_server'
column does not allow Nulls.
I feel in all the fields on the Account Setup Screen and put in a valid smtp
server name or the IP. Then it fails. If i run the stored proc that sets up
the account, sysmail_add_account_sp, it works. After I run the sp I go into
the modify the account and it looks just like it did when I ran the GUI.
I am running 2005 on a virtual server.
Any help would be appreciated.On Mar 15, 1:50 pm, Thom <T...@.discussions.microsoft.com> wrote:
> When I attempt to setup a new Mail Account using the GUI I receive error:CannotinsertthevalueNULLinto'servername',table
> 'msdb.dbo.sysmail_server'columndoes not allow Nulls.
> I feel in all the fields on the Account Setup Screen and put in a valid smtp
> server name or the IP. Then it fails. If i run the stored proc that sets up
> the account, sysmail_add_account_sp, it works. After I run the sp I gointo
> the modify the account and it looks just like it did when I ran the GUI.
> I am running 2005 on a virtual server.
> Any help would be appreciated.
Don't use the wizard. I was having the same problem and ended up
scripting it out instead:
from: http://www.sql-server-performance.com/da_email_functionality.asp
EXECUTE msdb.dbo.sysmail_add_account_sp
@.account_name = 'Dinesh',
@.description = 'Dinesh Mail on dynanet.',
@.email_address = 'dinesh@.dynanet.com',
@.display_name = 'Dinesh Asanka',
@.mailserver_name = 'mail.dynanet.com'
Use the sysmail_add_profile procedure to create a Database Mail
profile called Dinesh Mail Profile:
EXECUTE msdb.dbo.sysmail_add_profile_sp
@.profile_name = 'Dinesh',
@.description = 'Dinesh Profile'
User the sysmail_add_profileaccount procedure to add the Database Mail
account and Database Mail profile you created in previous steps.
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@.profile_name = 'Dinesh',
@.account_name = 'Dinesh',
@.sequence_number = 1
Use the sysmail_add_principalprofile procedure to grant the Database
Mail profile access to the msdb public database role and to make the
profile the default Database Mail profile:
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@.profile_name = 'Dinesh',
@.principal_name = 'public',
@.is_default = 1 ;

DATABASE Mail Account Setup Error

When I attempt to setup a new Mail Account using the GUI I receive error:
Cannot insert the value NULL into 'servername', table
'msdb.dbo.sysmail_server'
column does not allow Nulls.
I feel in all the fields on the Account Setup Screen and put in a valid smtp
server name or the IP. Then it fails. If i run the stored proc that sets u
p
the account, sysmail_add_account_sp, it works. After I run the sp I go into
the modify the account and it looks just like it did when I ran the GUI.
I am running 2005 on a virtual server.
Any help would be appreciated.On Mar 15, 1:50 pm, Thom <T...@.discussions.microsoft.com> wrote:
> When I attempt to setup a new Mail Account using the GUI I receive error:C
annotinsertthevalueNULLinto'servername',
table
> 'msdb.dbo.sysmail_server'columndoes not allow Nulls.
> I feel in all the fields on the Account Setup Screen and put in a valid sm
tp
> server name or the IP. Then it fails. If i run the stored proc that sets
up
> the account, sysmail_add_account_sp, it works. After I run the sp I goint
o
> the modify the account and it looks just like it did when I ran the GUI.
> I am running 2005 on a virtual server.
> Any help would be appreciated.
Don't use the wizard. I was having the same problem and ended up
scripting it out instead:
from: http://www.sql-server-performance.c...nctionality.asp
EXECUTE msdb.dbo.sysmail_add_account_sp
@.account_name = 'Dinesh',
@.description = 'Dinesh Mail on dynanet.',
@.email_address = 'dinesh@.dynanet.com',
@.display_name = 'Dinesh Asanka',
@.mailserver_name = 'mail.dynanet.com'
Use the sysmail_add_profile procedure to create a Database Mail
profile called Dinesh Mail Profile:
EXECUTE msdb.dbo.sysmail_add_profile_sp
@.profile_name = 'Dinesh',
@.description = 'Dinesh Profile'
User the sysmail_add_profileaccount procedure to add the Database Mail
account and Database Mail profile you created in previous steps.
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@.profile_name = 'Dinesh',
@.account_name = 'Dinesh',
@.sequence_number = 1
Use the sysmail_add_principalprofile procedure to grant the Database
Mail profile access to the msdb public database role and to make the
profile the default Database Mail profile:
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@.profile_name = 'Dinesh',
@.principal_name = 'public',
@.is_default = 1 ;

Database Mail 101

Question 1: From what I understand, Database Mail can only be used to Send, not Receive, email. Is this correct?

Question 2: I can hear our developers saying "way too complicated. When an error conditon is sensed by our app we can simply have the app send an email to our email server. Done." With that in mind what does Database Mail have to offer our developers that they can't easily do in their app?

TIA,

Barkingdog

Hello,

1: Yes. DBMail can only be used to send.

2: For a start, Dbmail can be used to issue e-mail alerts in response to database-engine related events (job completion, errors etc) as well as including query results in the message. I believe you'd have a hard (time consuming) time incorporating this functionality into an application to the same degree of reliability that DBmail provides out-of-the-box.

Cheers,

Rob

Database Mail - Status sent but email never received

From SQL Management Studion I go to Management > Database Mail and I am trying to send a test email but I never receive anything. I checked my SMTP Mail Server Logs and I saw no entry of my test email.

I also I checked my SQL Database Mail Logs and everything seems fine, no errors are reported.

The msdb.dbo.sysmail_allitems shows my email status as "sent".

So what am I missing? What steps would you recommend for troubleshooting my problem?

Thank you,

Ric

Quick question if you are using Express if yes then your mail was not sent because the MSDN is home to the Agent and the Agent is not included with Express. Hope this helps.|||

No I am not using express, I am using the SQL Server 2005 standard version. Did I post at the wrong place?

Ric

|||

No you did not post in the wrong place but your problem is related to configuration and permissions. I have found two tutorials by SQL Server users check them to see what is missing in your configuration. Hope this helps.

http://www.sqlservercentral.com/columnists/cBunch/introtodatabasemailinsql2005.asp

http://www.databasejournal.com/features/mssql/article.php/3626056

|||

Thanks for your reply Gift. I did exactly what is mentionned in your articles however I get the exact same results. My test emails seems to be sent, no error message, status is mark as sent but no I see no trace of such email on the smtp server.

Issp_send_dbmail waiting for a reply from the SMTP server before to mark the email status as sent? Also if I had a problem of permission I guest I would have some kind of error? Same thing if the port 25 was block I guess?

Ric

|||

(msdb.dbo.sysmail_allitems)

The above from your original post tells me either you and the Agent or just one need permissions in the Server and MSDB database because I don't know why these things are not documented but most auxiliary automation tasks like mail runs out of the Agent database the MSDB database. So try that and post again if you still need help.

|||

Sorry Gift but you are loosing me here, I don't understand what you mean. If you think that I have a permission problem where should I look? Which permission and on what? How to give the proper rights if that is what's missing?

Thanks again,
Ric

|||

(Configuration component has two sub components. One is the Database Mail account, which contains information such as the SMTP server login, Email account, Login and password for SMTP mail.

The Second sub component is Database Mail Profile. Mail profile can be Public, meaning members of DatabaseMailUserRole in MSDB database can send email.)

I got the above from one of the links you need to create account both in your SQL Server and MSDB database and grant it DatabaseMailUserRole public role before your configuration will work. So go to the Security section under management in Management Studio and the new security section within MSDB to create the account with the right permissions. Hope this helps.

Database Mail

Hi All,
sql server 2005 sp2
I am able to receive email notifications when a maintenance plan is executed
but not when the sql server agent job is executed.
According to the error log, "an attempt was made to send an email when no
email session has been established"
Any reason why it works for one but not the other?
Thanks.
JNDid you enable mail for SQL Agent? You need to configure
mail for Agent - If you view the properties for agent, go to
the Alert System window and set mail up on the screen.
-Sue
On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
<jnsimex@.hotmail.com> wrote:

>Hi All,
>sql server 2005 sp2
>I am able to receive email notifications when a maintenance plan is execute
d
>but not when the sql server agent job is executed.
>According to the error log, "an attempt was made to send an email when no
>email session has been established"
>Any reason why it works for one but not the other?
>Thanks.
>JN
>|||Yes, I have a check mark besides "Enable mail profile" and configured the
sql server agent mail properties under the Alert System to use the Database
Mail with the Mail profile that I want to use.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:ebm9635bakqghvfrelio40l4je9gmghed9@.
4ax.com...
> Did you enable mail for SQL Agent? You need to configure
> mail for Agent - If you view the properties for agent, go to
> the Alert System window and set mail up on the screen.
> -Sue
> On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
> <jnsimex@.hotmail.com> wrote:
>
>

Database Mail

Hi All,
sql server 2005 sp2
I am able to receive email notifications when a maintenance plan is executed
but not when the sql server agent job is executed.
According to the error log, "an attempt was made to send an email when no
email session has been established"
Any reason why it works for one but not the other?
Thanks.
JNDid you enable mail for SQL Agent? You need to configure
mail for Agent - If you view the properties for agent, go to
the Alert System window and set mail up on the screen.
-Sue
On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
<jnsimex@.hotmail.com> wrote:
>Hi All,
>sql server 2005 sp2
>I am able to receive email notifications when a maintenance plan is executed
>but not when the sql server agent job is executed.
>According to the error log, "an attempt was made to send an email when no
>email session has been established"
>Any reason why it works for one but not the other?
>Thanks.
>JN
>|||Yes, I have a check mark besides "Enable mail profile" and configured the
sql server agent mail properties under the Alert System to use the Database
Mail with the Mail profile that I want to use.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:ebm9635bakqghvfrelio40l4je9gmghed9@.4ax.com...
> Did you enable mail for SQL Agent? You need to configure
> mail for Agent - If you view the properties for agent, go to
> the Alert System window and set mail up on the screen.
> -Sue
> On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
> <jnsimex@.hotmail.com> wrote:
>>Hi All,
>>sql server 2005 sp2
>>I am able to receive email notifications when a maintenance plan is
>>executed
>>but not when the sql server agent job is executed.
>>According to the error log, "an attempt was made to send an email when no
>>email session has been established"
>>Any reason why it works for one but not the other?
>>Thanks.
>>JN
>

Database Mail

Hi All,
sql server 2005 sp2
I am able to receive email notifications when a maintenance plan is executed
but not when the sql server agent job is executed.
According to the error log, "an attempt was made to send an email when no
email session has been established"
Any reason why it works for one but not the other?
Thanks.
JN
Did you enable mail for SQL Agent? You need to configure
mail for Agent - If you view the properties for agent, go to
the Alert System window and set mail up on the screen.
-Sue
On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
<jnsimex@.hotmail.com> wrote:

>Hi All,
>sql server 2005 sp2
>I am able to receive email notifications when a maintenance plan is executed
>but not when the sql server agent job is executed.
>According to the error log, "an attempt was made to send an email when no
>email session has been established"
>Any reason why it works for one but not the other?
>Thanks.
>JN
>
|||Yes, I have a check mark besides "Enable mail profile" and configured the
sql server agent mail properties under the Alert System to use the Database
Mail with the Mail profile that I want to use.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:ebm9635bakqghvfrelio40l4je9gmghed9@.4ax.com...
> Did you enable mail for SQL Agent? You need to configure
> mail for Agent - If you view the properties for agent, go to
> the Alert System window and set mail up on the screen.
> -Sue
> On Mon, 4 Jun 2007 11:05:22 -0400, "JN"
> <jnsimex@.hotmail.com> wrote:
>