Comments
Sort by recent activity
Done...
For the next guy, while we wait for it to make it to the top of the pile, here's what I did manually
UPDATE MyDB.dbo.sysdiagrams
SET definition = (
SELECT definition
from MyOtherDB.dbo.sysdiagrams
WHERE name = MyDB')
WHERE name = 'MyDB'
(that works on the same server - different servers may be more challenging) / comments
Done...
For the next guy, while we wait for it to make it to the top of the pile, here's what I did manually
UPDATE MyDB.dbo.sysdiagrams
SET definition = (
SELECT definition
from MyOtherDB.dbo.sys...