Change Tracking experts, any idea??

SQL Server Gurus any solution to mu question?

Thanks for all your inputs.

We donot maintain any DB diagram on the SQL 2008 Instance, modelling in done on a seprate tool.

Wanted to know if this table can be deleted & will impact any...

I see, in that case I have to provide access to MSDB, while creating Linked server.

But thanks for your suggestion, that should work as far as I see.

Thanks Man

Hey,

I have one more question, what if the subscriber is a pull subscription & the job is created on different instance?

How can we call the subscriber job remotely?

Thanks

Asir

U da Man...... 🙂

Bet this is what I was looking for, let me try this...Thanks a lot Buddy, apprecaite ur prompt reply.

You have a better HW on the 2008 server. So we can forget about that. Couple of things you might want to look at is the Disk configuration.

Are both the...

Are there any network issues between the pub and the 2008 box? Do you see any network IO waits?

Are the two subscribers having the same HW configuration?

-Roy

++++++++++++++++++++++++++++++++++++++++++

Hi...

I am not so gud with virtualization, could you please advice how can I do that?

Pablo,

I am setting logshipping on 2 different instance installed on the same machine. I have already set this in the past on some different machine which was in network.

The...

DBA Guru's ... Any1 has an answer to my question???

Thanks for the update, I have followed ur steps & all looks gud except the maintaince plan.

As per ur advice i have scripted all the jobs of maintainance plan...

Thanks for the prompt reply.

If that is the case, then what about the information of the user DB of 2000 that will be moved to 2005? Master DB also...