It doesn't accept invalid FK values.

Please post ddl (the actual please) of your involved tables as well as the sqljob giving the error as well as the actual error...

Certainly there has been something wrong with a foreign key value for the inserted batch.

I would query the source table using a where not exists correlated query using the foreign...

Stefan Krzywicki (4/20/2011)

---

CirquedeSQLeil (4/20/2011)

---

GilaMonster (4/20/2011)

---

LutzM (4/20/2011)

---

Is there any other method than using the mouse pointer? There are so many words on the screen. How else to keep track where the...

it should be col1 + col2

Ninja's_RGR'us (4/20/2011)

---

Nothing blunt in there... just solid experience. I don't...

Another thread requesting the same options:

http://www.sqlservercentral.com/Forums/Topic1096149-391-1.aspx

Ninja's_RGR'us (4/20/2011)

---

ALZDBA (4/20/2011)

---

GilaMonster (4/20/2011)

---

Ok, I'm going to be blunt (and probably unpopular)

I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance...

GilaMonster (4/20/2011)

---

Ok, I'm going to be blunt (and probably unpopular)

I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance promptly degraded...

Edward-445599 (4/20/2011)

---

ALZDBA (4/20/2011)

---

AWE is not needed on x64 OS with a x64 SQLinstance. ( it already has the ability to address all your ram )

Did you perform full db maintenance...

:w00t::w00t::w00t::w00t::w00t::-D:-D:-D:-D

How's that for a dyping error 😉

another msdtc resource: http://blogs.msdn.com/b/asiatech/archive/2009/11/18/how-to-configure-msdtc-resource-for-windows-2008-failover-cluster.aspx

Keep in mind , if these new addresses are not addressable from the current addresses (vlan/ranges) this needs to be an all in one operation or your cluster may become...

AWE is not needed on x64 OS with a x64 SQLinstance. ( it already has the ability to address all your ram )

Did you perform full db maintenance after your...

Did you have a look at http://support.microsoft.com/kb/244980

This is the script I use ( sql2005 for the moment )

/*

* DB Mirroring : followup

*

*/

/* show mirrored databases and their mirror-state */

Select db_name(database_id) as dbName

, *

from...