I’ve detected that if you have the same table in DSA and MDW. let say DSA.Invoices and MDW.Invoices for example, and you define partition for that, both tables share the same partition schemas and partition functions in the SQL Server database.
It’s a problem when you try to add or remove field from whatever table.
Best answer by Christian Hauggaard
View original