Well tried to create publication and got following error

A exception occurred while attempting to execute a tsql statement or batch

Can not find procedure “”

Can not find procedure “”

Change the database...

As always, SPOT ON. Great.

DECLARE @DatabaseName VARCHAR(50);

SET @DatabaseName = 'Big_VirtualLog_DB'

SELECT name, recovery_model_desc, log_reuse_wait_desc

FROM sys.databases

WHERE name = @DatabaseName

log_reuse_wait_desc is showing "REPLICATION". Because this...

Great.

So that was the base reason, which has cause the locking. REBUILD iNDEX commands for few indexes were issued without these two options and that has killed everything.

Re-enabling allow_page_lock and...

Hi,

May be following query will be helpful for you OR someone else.

select

object_schema_name(object_id),

object_name(object_id),

name,

'ALTER INDEX ' + name + ' ON '+object_schema_name(object_id)+'.'+object_name(object_id)+' REBUILD;'

,*

fromsys.indexes

wheretype > 0

order by

object_schema_name(object_id),

object_name(object_id)

Hi,

What can be the advantage OR dis-advantage, if both of these are ON

ALLOW_PAGE_LOCKS

ALLOW_ROW_LOCKS

I have already studied your comment where both are off.

If turning these both ON is beneficial? then...

Hi,

Well 4000 lines are one transaction with most of the object of our xml model.

XML model input is joining with many different tables based on different condition in the proc...

i am already running 1222, Following is the snapshot of one of the lock, if this gives you sufficent details for understanding.

So what do you suggest?

Thanks.

deadlock-list

deadlock victim=process1c8def2e8

process-list

...

Any joy?

Ok now we are moving to a next level. Now every server is either 2008 R2 OR 2008.

Do we now have any better choice?

Thanks.

So the possibility is there that rebuilding index can change things.

But how to narrow down this. what next step shall i take?

PS:

Well more than 80% and its not reducing...

Hi,

Manal Sync is quite tedius and maintenance cost is very high.

Do you know, if replication from R2 to 2005/08 is really possible and will really work? and without any version...

Yes you are right. t

The combined datalength(new_resultant_col) is more than 100,000.

But even then i can't see that even in note pad text file.

Why? and how to see such things...

Well size of combined one xml is not even 1MB.

Now i have added a new varchar(max) column in the table and did a simple update

update table set new_col = col1+col2+col3+col4+....

now...

Great Champ!!!! Excellent work.

BY giving the namespace in individual item, it worked as desired.

However, I am still not sure what's the purpose of this "*." in this clause ...

Excellent!!!

This works with single element in body. Of course one cannot write n number of outer apply for each element in body. I have tested following and its giving...

Great Now,

The pupose of question was to select from multiple nested namespaces and with the same name of namespace.

Now i also want to see as column value from <a:To ........