Lowell,

On the Job Step Properties, I am specifying the user database. The SQL is reading (unqualified) tables in the user database and inserts into a table that's in another...

Thanks Noel.

This worked just great:

DBCC UPDATEUSAGE(0) WITH COUNT_ROWS

Thanks Jo.

I'll stick with select count(*) when I need to know the real time row count.

I tried "UPDATE STATISTICS censusdatageneric with FULLSCAN" and I tried simply updating one of the...

Thanks govinn and Noel.  I now see how string manipulation will help.

Best Regards,

rnpatter

govinn:

Thanks.  I think I'm getting closer.

But, the strings I want to convert will ultimately come from a table where they reside in a CHAR column without the space.  So, I still...

Yes, my login was assigned to the System Administrators server role on the test server.  That was the difference.

Thanks.

How about just pushing the table into another temp table and use that:

Insert #NewTempWebNotes (........) SELECT CC025_ORG_CODE, CC025_EXT_ACCT_CODE, CC025_NOTE_CLASS, CC025_PROD_CODE, max(Note_text), max(HTML_text)

FROM #TEMP_WEB_NOTES

GROUP BY CC025_ORG_CODE, CC025_EXT_ACCT_CODE, CC025_NOTE_CLASS, CC025_PROD_CODE

Hey, nice script. Thanks a lot.

Thanks for the assist Frank. This also seems to work ok: DECLARE @oldtable sysname SET @oldtable = (select a.name from sysobjects b inner join sysobjects a on (a.id...