Ok, Thank you!

Thanks for the replies...I've enabled trace flag 1117 n 1118

Thank you!...batch size was the key in this case indeed..2 Bil rows successfully imported. Thank you Phil, Frederico n Kevaburg..appreciate it!

Check this...https://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/

Mr.Pavan, Either you are not paying attention and reading the replies or you have no clue on what you are doing!....

Phil Parkin clearly mentioned there's no 32-bit windows support for...

1. Remove table from replication

2. Reinitialize subscription

3. Add table to replication

4. Reinitialize subscription

Awesome stuff...Thanks so much!

Thank you for your time..Gail & Andrew!

Thanks much Eric...this was helpful..I just made slight changes to suit my requirement

select

object_name(referencing_id) as ViewName

,o.type_desc

,referenced_database_name + '.' + referenced_schema_name + '.' + referenced_entity_name as ReferencedTable

--,*

from sys.sql_expression_dependencies d

inner join...

Hi Gail,

am sorry that I made it look confusing...Yes, you are right...am talking about virtual memory setting on windows machine which is 64bit and I think we can set it...

Yes...Virtual memory is currently set to 60 GB on windows server.....n Yes, server has 3TB ram..this is datawarehouse env where lot of cube jobs run on daily basis and that's...

Simple

Jeff, its weekly full and daily differential for this Db..I took care of this now though ...thanks

can you share the script with me please?

Thank you!