Rollback a committed link of static data

[bjordan]

Hi,

I've linked a couple of tables and committed my changes to source control. One of the tables has over 100,000 rows. Now all teams members are unable to update their local repo. They either get an error or the "Calculating Changes" process is taking forever. I've unlinked them locally, and am now trying to commit the unlink, but again the "Calculating Changes" process is taking forever.

Is there a quick way to unlink and remove this data from source control, directly in the repo perhaps?

Cheers
Barry

[bjordan]

Hi,

In the end I manually edited the _data files directly in the central repository, leaving only a couple of insert statements in them. I then committed those and updated my local repository directly, using the command line. I then got latest using SQL Server Management Studio and the update was v quick.

Barry