I think, in essence, I'm always going to get a table scan with select * so indexes may not help. Let me go a different direction with this then.. what...

Not a thing, Sean. No primary key, no indexes, nothing. And the entire select statement consists of

select * from table

Oh how I wish I could just...

Oh sorry, Gail, I forgot to mention that there are no where conditions.. this is pulling the entire table back.

Here you go Lynn.

declare @strSQL nvarchar(max)

declare @tblName nvarchar(255)

declare @columnList nvarchar(255)

declare @conditions nvarchar(1000)

declare queryList cursor local static forward_only read_only for

select source.name, left(source.dtcolumns, len(source.dtcolumns)-1) dtColumns, left(source.conditions, len(source.conditions)-3) dtConditions

from

(

select st.name

, (select sys.all_columns.name...

That's an awful lot like one of my favorite expressions in SSIS... lol

Go BIG or go HOME you sql noobs! :w00t:

Either you give 100% fill factor or you might as well give 0% fill factor. 😀

Yes, it's a sarcastic morning here at...

I would expect, considering the number of parts in a car and the number of shared parts across cars that your recursive query is probably going to return all cars...

Not necessarily..

current row in your audit table should match current row in your live table:

ergo. (assuming you have an incremental identity on your audit table...say you do!)...

I hesitate to suggest it but the error is self-explanitory? Make sure you've got the table right.. you also may want to enclose the table name in [] as it...

I'm not sure what the issue is.. it doesn't matter how many records you have when you only have 3 formulae for the case statement. It's not like the case...

Have a look at this, perhaps it will help.

http://msdn.microsoft.com/en-us/library/ms188427(v=sql.105).aspx

Excellent. That was the conclusion I had come to as well so I've changed the snapshot replication to drop and recreate and will report back tomorrow if that doesn't solve...

The result is what you would expect. The rowcounts match and data space used matches...for the first replication..

If I continue to for replicate it, to mimic the growth of...

lol... thank you. It's nice to be special.

I have this happening in more than one place as well. The SQL versions are identical, the structures are identity, the rowcounts...

Thanks, Muthyala, I will look into that for the...