Once again it is been prooven : a sound dba must pop the questions !

and the attitude will change from [b]"must now ... chop chop.. cannot do it other way..."...

KingCobra (2/24/2010)

---

There you go,

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...

You should indeed be able to define a linked server from sql2008 to mysql.

However, If you also want performance, that may not be your best choice !

If you don't need...

Thank you for the feedback.

That's a bummer :ermm:

Isn't each db engine like an "add on" for NHibernate ?

So maybe just adding MySQL in the config could do the trick.

My...

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 ?