I don't know the 3790 build.

Please post the full result of

Select @@version

The article is dated April 2003. (sql2000)

The NONO is about 64-bit.

Experiences with 64-bit...

Superflokky (2/23/2010)

---

Thx you for the responses so far!

I want to point out that my test environment hasn't changed that much. The only thing I've changed (on the MySQL server side)...

You should also check your mail server, because it may withhold your mail because of e.g. spam settings, ...

Regarding your SP2 question:

SP2 has many cumulative hotfixes (as does SP3), so...

These is one big NONO with your configuration:

Don't set the same value for min and max server memory ! It confuses sqlserver...

That's exactly what I like about linked servers or OpenQuery stuff :sick::sick:

So, that's why always advise to try to avoid them in the first place.

- Check for differences in the...

Apparently you have been bitten by your own messing around with logical names !

If you start fooling around with systems info or settings, don't be surprised you may not...

I always use these scripts to diagnose DBMail issues ...

use msdb

go

/* is dbmail config activated ? */

Select *

from sys.configurations

where [name] = 'Database Mail XPs'

go

exec sysmail_help_queue_sp -- @queue_type = 'Mail'

go

select...

Greg Snidow (2/22/2010)

---

Yep, after reading more about it, I realize now why it is not for users, as it could be dangerous. My problem is that there is a...

I would advise you to read Jeffs great article :

"The "Numbers" or "Tally" Table: What it is and how it replaces a loop."

http://www.sqlservercentral.com/articles/T-SQL/62867/

I'm not quit with you on your statement .. :ermm:

Why do you want to detach the database ?

What's the point of detaching your dbs ?

Is SQLServer Errorlog showing any extra info regardnig dbmail ?

If not, post your dbmail ddl

You've been pointed to the solution 😎

But, what's the reason you want to detach all databases without actually stopping the SQL instance ?

BOL states:

ComputerNamePhysicalNetBIOS

NetBIOS name of the local computer on which the instance of SQL Server is currently running.

For a clustered instance of SQL Server on a failover cluster,...

as you know usage of xp_cmdshell is to be avoided.

We don't use xp_cmdshell out of sysadmin context, but I believe you can grant it by altering settings for sqlagent.

SQLAgent properties...