what is the problem in passing the entire xml to a sp as an input parameter of datatype text?

i have not worked on this product, but you may want to evaluate this product called

"symbiator"

I have multiple subscribers and maintain the history with triggers at the distributor. to avoid unnecessary history trigger load on the production servers.

In this scenario, i am not getting all...

small correction

for eg. for id = 1, i would need the the child ids as 2,3,4,5,6

and the levels deep can be dynamic.

is the trigger set up with "NOT FOR REPLICATION" option?

steve is just asking you to create a sp to check for all the changes, generate and send one single email with all those changes. to create a job, go...

insert into tblCustPreference(

custguid,

name,

) SELECT

x.custguid,

x.name,

FROM OPENXML (@xdoc, '*/cust/coldata',1)

...

I have come across the same situation and still I am trying to figure out what is wrong?

I would prefer to go the BCP way.

thanks steven,

what is the easiest way to change all my 100+ triggers and add the "not for replication option"?

this would work.

select * from openquery (servername,'exec dbname.dbo.spname')

cool.thanks

yes. you need to login as the service account and install a mapi client on the server.

I am looking at a way to find out what are the tables that are currently pinned?

sp_tableoption gives you an option to pin or unpin the table. I would also...

the query that is running slow is an sql enterprise 2000 and other is sql standard 2000. I kinda suspect the subsystem to be a bottleneck. what can i check...