Hi Jeff,

Thanks for the reply, you mentioned that it depended on a couple of things, in a nutshell, what are those things?

Regards,

D.

Thought as much. Thank you.

Regards,

D.

GilaMonster (4/10/2009)

---

Either they were restored from backups of published databases or there was replication at one point and it was removed improperly.

Set the server up for replication, create a publication...

...

Hello,

Sorry Aaron, I misread the question, I have had a look and some tables to not have PK or FK, most tables have a createdate column, but some tables have...

Aaron,

Thanks for replying...

Do you have a field in each table that you can confidently rely upon to provide a monthly cut off, Or a field which provides a FK reference...

Thanks for those excellent references, I'm finishing up an upgrade from mcitp 2008 to 2012, then I was going to hit data warehousing in more detail (part of the...

I couldn't agree more, but it's tough to get into with limited experience, and after the effort it would be a kick in the nuts if everyone has started using...

Thanks Perry, this is what I did.

Regards,

D

Hello,

Thanks for getting back, I had in fact already come across this article, as it would be a temporary measure, I may go with log shipping or T-replication.

Regards,

D.

Hello,

Thanks for getting back, I had in fact already come across this article, as it would be a temporary measure, I may go with log shipping or T-replication.

Regards,

D.

In response to the original post..(Thank you Bill Ramos)

In digging into this problem, the MDW reports access several collection set views in msdb. The mdw_reader and mdw_admin roles apply only...

Hello,

Basically the only way around it is to set up the MDW's locally and then it works fine, M$ is not going to fix this (so stupid to let a...

Hello,

Thank you both for getting back. Sunder,Yes I am running SSMS locally.

Yeah, I think I am going to have to use different names. I did restart the SQL services,...

Hey I realise this is an old post, but I am having a similar issue except my error line ends with 'DS_TraceEvents'. I did come a across a MS connects...