Hi Twin.devil,

THe out put i am looking is 3 columns (i just separated middle column/value in bold font)

"EmployeeID" "IndustryDome" "description "

1166586 3951LX01 Description10

we need to read 2nd column from

<IndustryDome>3951LX01</IndustryDome>

and...

Thank you LutzM.

Can you also tell me how to get the CustomerID in the resultset ?

SO the output should looks like:

A8339 123456

A8339 7890123

Thank you all.

Hi bala, thanks for the reply.

Sorry, Onething i forgot. I dont want a job which will be keep on monitoring the tables (CDC tables or Audit Tables). There are already...

Yes RBarryYoung. I only (with owner "fl\user2012" as windows authenticated , admin access ) created/setup everything and i am the owner of all the objects.

Thanks,

kumar

Hi RBarryYoung,

As you suggested I tried with Cross-db changing setup. But no luck. I got the same error. Can you please explain step by step code to do this ?...

Hi RBarryYoung,

Thank you for replying. Yes the PROC executing/calling by Service broker is on different database (FileTableDB).

While i see the server log it is:

The activated proc '[dbo].[spMessageProcSample]' running on...