I re-read the original message and determined that the data has a hidden constraint that for a customer, the values for date_ran must be consisten for all pools.

This can only...

Regarding such things as the currency symbol, measurement units or number formats,

these are all used for formatting or conversions and, for the most part,

do not exists within the DBMS portion...

The message returned on a foreign key constraint creation failure is, in my opinion, the most misleading message in SQL Server.

What it really means is that are some rows in...

Cast to numeric(10,0)

When was the last time that optimization was run?

SELECT t.name as TableName

, i.name as IndexName

, STATS_DATE(i.id, i.indid) as StatisticsDate

FROM sysobjects T

join sysindexes i

on t.id = i.id

where t.type = 'U'

MySQL verion 5 was just released on October 24, 2005 which includes Stored Procedures, Triggers and Views for the first time, there is very little experience with the compatability of...

Are the clients running Windows 2003 and Java ?

There is some new configuration that needs to be done for MS DTC/Java that occurs after a Windows 2003 SP/Patch is installed...

How to install and configure SQL Server is dependent on usage and hardware:

1. How many CPUs?

2. How much memory?

3. How are the disk drives configured including RAID,...

Based on your provided data, this is not possible without some other tie-break criteria.

For the client_name with a value "Cutomer1 ", there are three rows with the same value for...

No, as CustNo is the first column of a unique clustered index, this is OK.

Such as:

select

From StateZipDemographics

join Table2

on Table2.State = StateZipDemographics.State

and Table2.ZIP = StateZipDemographics.ZIP

WHERE ??

The where...

Question 1:

What is you version of SQL Server ? Run this SQL and post the output as if you are using 7 vs 2000 vs 2005, the answer may...

80004005 usually indicates a problem with OleDB/MDAC.

When you are running manually, are you logged on to the server (i.e. the machine where Sql Server is running) or another computer, such...

For Database and transaction log backups, the database is NOT in single user mode.

For integrity checks, the database will be in single user mode only when the checkbox...

To complicated for me.

select name

from sysobjects

where OBJECTPROPERTY (id,'ExecIsStartup') = 1

To run against all databases:

exec master.dbo.sp_msforeachdb @cmd1 = '

select name

from sysobjects

where OBJECTPROPERTY (id,''ExecIsStartup'') = 1'

The SQL you provided results in the master and detail tables keys, so just join to the master and detail tables (with the detail table appropriately aliased to "first" and...