Database Mail is not working for me on 64 bit SQL 2005

I am trying to get Database mail working on our win 2003 EE 64 bit SQL 2005
SP 1 EE 64bit server. I have done a ton of searching around other posts &
have checked everything that people have said would work. Nothing has worked
so far with me. The mail service is enabled, broker service is enabled &
relay permission is allowed for the service. Here is the error message I am
getting: Could not retrieve items from the queue. If I look at the queue,
it does have several test messages in there waiting to be sent. Any ideas on
what else I could try to get this to work?
Thanks!
Johnhmm..what login is the mail service running under? Are you sure that user
has permissions to read the msdb system database?
"John D." <JohnD@.discussions.microsoft.com> wrote in message
news:28596E29-6110-4A44-806F-6E82C2A86983@.microsoft.com...
>I am trying to get Database mail working on our win 2003 EE 64 bit SQL 2005
> SP 1 EE 64bit server. I have done a ton of searching around other posts &
> have checked everything that people have said would work. Nothing has
> worked
> so far with me. The mail service is enabled, broker service is enabled &
> relay permission is allowed for the service. Here is the error message I
> am
> getting: Could not retrieve items from the queue. If I look at the
> queue,
> it does have several test messages in there waiting to be sent. Any ideas
> on
> what else I could try to get this to work?
> Thanks!
> John
>|||Pardon my ignorance but how where do you set what login the mail service is
running under? Does it use the login that SQL Agent is running under? I
enabled it in the surface area configuration tool.
"Tim Greenwood" wrote:
> hmm..what login is the mail service running under? Are you sure that user
> has permissions to read the msdb system database?
>
> "John D." <JohnD@.discussions.microsoft.com> wrote in message
> news:28596E29-6110-4A44-806F-6E82C2A86983@.microsoft.com...
> >I am trying to get Database mail working on our win 2003 EE 64 bit SQL 2005
> > SP 1 EE 64bit server. I have done a ton of searching around other posts &
> > have checked everything that people have said would work. Nothing has
> > worked
> > so far with me. The mail service is enabled, broker service is enabled &
> > relay permission is allowed for the service. Here is the error message I
> > am
> > getting: Could not retrieve items from the queue. If I look at the
> > queue,
> > it does have several test messages in there waiting to be sent. Any ideas
> > on
> > what else I could try to get this to work?
> >
> > Thanks!
> > John
> >
>
>

Database last accessed

We have a Windows 2000 server with SQL 2000 on it and a ton of databases
(300+). Is there a way to find out which databases are still being used
(last time accessed) so I can archive some of them an only have the databases
that are actually being used.No, SQL Server doesn't log all access to a database...
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.|||Too bad you aren't on sql2005. You could possibly use
sys.dm_db_index_usage_stats, or login triggers for your needs.
--
TheSQLGuru
President
Indicium Resources, Inc.
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.|||> Too bad you aren't on sql2005. You could possibly use
> sys.dm_db_index_usage_stats, or login triggers for your needs.
For logon triggers, that won't capture things like logging into database A
(or the default database) and running SELECT foo FROM databaseB.dbo.table;|||Hi
In this case you may try to run SQL Server Profiler , so you can order by
database , see BOL for details
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.

Database last accessed

We have a Windows 2000 server with SQL 2000 on it and a ton of databases
(300+). Is there a way to find out which databases are still being used
(last time accessed) so I can archive some of them an only have the databases
that are actually being used.
No, SQL Server doesn't log all access to a database...
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.
|||Too bad you aren't on sql2005. You could possibly use
sys.dm_db_index_usage_stats, or login triggers for your needs.
TheSQLGuru
President
Indicium Resources, Inc.
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.
|||> Too bad you aren't on sql2005. You could possibly use
> sys.dm_db_index_usage_stats, or login triggers for your needs.
For logon triggers, that won't capture things like logging into database A
(or the default database) and running SELECT foo FROM databaseB.dbo.table;
|||Hi
In this case you may try to run SQL Server Profiler , so you can order by
database , see BOL for details
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.

Database last accessed

We have a Windows 2000 server with SQL 2000 on it and a ton of databases
(300+). Is there a way to find out which databases are still being used
(last time accessed) so I can archive some of them an only have the database
s
that are actually being used.No, SQL Server doesn't log all access to a database...
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.|||Too bad you aren't on sql2005. You could possibly use
sys.dm_db_index_usage_stats, or login triggers for your needs.
TheSQLGuru
President
Indicium Resources, Inc.
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.|||> Too bad you aren't on sql2005. You could possibly use
> sys.dm_db_index_usage_stats, or login triggers for your needs.
For logon triggers, that won't capture things like logging into database A
(or the default database) and running SELECT foo FROM databaseB.dbo.table;|||Hi
In this case you may try to run SQL Server Profiler , so you can order by
database , see BOL for details
"spinkid" <spinkid@.discussions.microsoft.com> wrote in message
news:C8A5C8AE-8671-41D7-A4B0-5FF6B3D1EBD3@.microsoft.com...
> We have a Windows 2000 server with SQL 2000 on it and a ton of databases
> (300+). Is there a way to find out which databases are still being used
> (last time accessed) so I can archive some of them an only have the
> databases
> that are actually being used.