I'm attaching the DB Mail log as (db_mail.txt.zip) as requested and also want to add that I'm seeing this message below in the SQL logs over and over again almost...

All,

Attached is the DDL for the tables as you suggested.

BatchTrans row count - 160 million+ rows

ForeignBins row count- 7500 rows

Thanks for the assistance everybody! 🙂

What I'm trying to do is compare acct nums that are 8 digits long and a substring'ed 10 digit long acct num (i.e. SUBSTRING(AcctNum, 3, 8) because I'm planning on...

Wayne,

I tried the following, but got the error shown below. Any ideas what the prob is?

declare @proc sysname

set @proc = 'InsertWarehouseCountExisting'

SELECT schema_name(sp.schema_id) [Schema], object_name(sasm.object_id) [Procedure]

FROM sys.all_sql_modules sasm

INNER JOIN...

ok thanks for the info!

Ritesh,

Thanks for the info. So you restored a good last full backup from Prod onto the secondary using "stand-by" mode and how did you continue the log ship (LS)...

Gail,

The execution plan is on it's way. I had to re-run the query since I didn't set the options last time I ran it. It'll take almost 5...

1. For '@EPOSManual' I believe the only available options are "'Manual','All','EPOS'".

2. Can you tell me in more detail why cursor C is not needed in the code? ...

I've attached the table defs to this query as well as the input and output in an Excel sheet. Let me know what you guys think! Thanks!

Gail,

Thanks for the tip on the article. It was good reading and good advise. I'll definitely use that approach this go around.

Thanks,

David

Alright let me work on that...thanks.

Yes, that's what I'm trying to do. Select money (.0000)

Thanks for the response and I apologize for getting back to you so much after the original posting. Holidays...uhgg. Now when I run the query it seems to...

I need to run Update Stats. I failed last nite and I think that's the problem all. Thanks!

Chris,

I'm confused. I tried using the EXISTS syntax you showed me as an example and it wouldn't compile. Can you clarify?

Thanks,

Dave :w00t: