Hi Andy Leonard and MG,

Thank you for your replies. Hearing that schema-change notifications can be done via SSIS is such a great news. Andy, can you point me out how...

Thank you for your suggestions. I am sorry i was not clear. English is not my first language.

500++ tables are not in a data warehouse, they are from...

I did have some trainings and produced DW but this time i am facing a huge db that's why i am trying to find shortcut.

Hi Michael,

Thank you for your reply. I dont know what SCD means though. Can you tell me a bit please? I am new to SQL Server 2005. But have to...