Hi Barry,

Where can we see the created Master Key in Sql server Management Studio?

Or how to know whether the...

Good Morning Barry,

I'm trying to create end point for an instance. I've written the...

Thank you very much for your guidance

You are saying master key is unique to a database. Then how do we use the master key created in databaseA in databaseB of a different instance while setting up...

Hi Barry thanks for ur reply. When we are sending message from databaseA to databaseB in a different server do we need to create Master Key in databaseA and...

Hi Thanks a lot for ur answer. Can you explain me the major difference between a service broker service and service broker end point?

Thank you very much for your time

Hi Shaw,

Can you please tell me what all things we need to do for synchronizing two...

Hi Shaw,

thanks for your reply. Can you please send me a sample queue for the...

Hi Shaw,

We have created message types,contracts. We need to create stored procs that activates the queues....What i'm...

Hi Barry,

The reason for showing interest in service broker is the databases we are trying to synchronize are of...

Hi VG,

U gave the script for global variables as

FOR GLobal variables:

in script component, "readonly variables" type your 2...

Hi VG,

thanq very much i hve one more issue

There is a lookup query in the data driven query task of DTS package i'm migrating . That lookup tab in...

Hi VG,

How can the below script be written in SSIS script component

if (DTSSource("onyx_co_cd") = 0 OR ISNULL(DTSSource("onyx_co_cd"))) then

DTSDestination("vchURL") = "I"

else

DTSDestination("vchURL") =...

Hi VG,

thankq very much...that worked out for me.

I've one more doubt can you give me the code...