Buy a copy of SQL Data Compare - it will compare data in any number of tables on the same server or separate servers and create a script to sync...

You may also want to take a look at the error trapping

EXEC (@sql)

SELECT @sql =''

SET @intErrorCode=@@error

In the above...

I can't speak to the Apex tool but I have been using SQL Compare for the last 2 years - it has saved me hours and hours of work -...

Thanks for the sample code and excellent explanation.

Regards,

Harley

GSquared,

Can you give me an idea what the SP dbo.Error_CatchCommon contains?

Thanks,

Harley

Steve,

The plans are very different - index seek on xDate in both - then loop join to TableB - then

> the poor plan scans TableC and shows 77M records...

Steve,

Dates from mid-Nov back all behave the same and seem to operate properly when run either way - the more recent dates are subject to the odd pattern - the...

Another vote for SQL Compare - very fast and accurate - well worth the cover charge! 

Regards,

Harley

Steve and Redd,

Thanks for the well thought-out responses.  Given the supporting apps running on the server, and the lack of an ability to do meaningful comparisons of various configs, it sounds...

Edogg,

Thanks for the response - actually, the service company recommended lowering the SQL max to 12GB to leave 4 for the OS and other apps noted above - again, I'm...

Alan,

One way to handle it is with a UDF - thanks to whoever posted this -

CREATE FUNCTION fn_ConcatStrings

(@ID int)

RETURNS varchar(500)

AS

BEGIN

declare @String varchar(500)

select @String = coalesce(@String,'') + Col +...

Thanks for the responses - the change was made without any supporting metrics - it was based on a blanket statement by an admin that 2003 in a clustered environment will...

Wayne,

I have great sympathy - I work as DBA for a large financial institution where data security is a high priority.  I have read-only access to PROD data but no...

SQLGuru,

I agree with your thought - bouncing SQL seemed to remove it from the list of suspects...and no, I have no access to the box at all - except through the...

The only time I have seen a sev 19 error was once when we had disk controller problems on the SAN.......you can try rebooting, run diagnostics on the drives and then...