21 reputation
2
bio website
location
age
visits member for 2 years
seen Oct 25 '13 at 2:22

Oct
17
comment Adding Massive amount of Articles to existing publication cause screen to hang forever
I managed to create the snapshot. During subscription, the job fails because it's unable to replicate the view which has nested views.
Oct
17
revised Adding Massive amount of Articles to existing publication cause screen to hang forever
added 392 characters in body
Oct
17
awarded  Editor
Oct
17
revised Adding Massive amount of Articles to existing publication cause screen to hang forever
added 734 characters in body
Oct
17
comment Adding Massive amount of Articles to existing publication cause screen to hang forever
it's running now but at a rate of 40 seconds per article, i m just doing replication for view. Estimated to finish is 0.9 day. It's still too slow.
Oct
17
comment Adding Massive amount of Articles to existing publication cause screen to hang forever
i generated the script via New Publication Wizard . Did some coding and generated the rest of the scripts. now running over 1.8k views for replication. fingers crossed.
Oct
17
comment Adding Massive amount of Articles to existing publication cause screen to hang forever
Do you have example script for views and user defined function ? It's a little complicated for me .
Oct
17
asked Adding Massive amount of Articles to existing publication cause screen to hang forever
Apr
6
awarded  Student
Apr
6
asked Exporting SQL Server 2008 R2 Activity Monitor Log