Hello,

I don't think that works because i ran the trace last night.I am thinking profiler might have captured those there should be some where in the profiler i am just having hard...

Thanks Very Much!

Henk,

You need not pay for it..what you are seeing is just a commercial..after that you should be able to see what you want...

Hope this helps...

Thanks,

Thanks For The Heads UP!

Guys,

Thanks For your advice..It's a third party app i did said to figure out this from the app side rather than having an another instance.

But i am asking this because...

Ok..Then i understood you correct.

When ever a failover occurs there will be two instances on the failover node ..am i right.

Thanks Again..

Mike,

So you want to make the cluster ACTIVE/ACTIVE and then install a named stand alone instance on the failover node.Is my assumption correct.

Thanks,

That's what I thought.

Thanks For The Confirmation though!

I just did sp_Changedbowner 'DOMIAN/GroupName',it says login doesn't exist which is not true.

At the same time i can add an individual windows id like mine DOMAIN/Chinn..this works.

I am thinking  i...

I think you cannot script multiple jobs VIA EM...But you can transfer all the jobs you want to another server using DTS.

Hope this helps

Thanks,

I am thinking of doing this .let me know if this is correct

On the active node, stop the sql cluster service

Change the account under services, start the cluster...

Rsharma,

Thanks Very Much.It worked.

Thanks Very Much...

I am just trying to learn..

Yes..Wayne.

I would like more information about XML as it is integrated into or with SQL Server.

Thanks,