Various functons within SQL Server Management studio have stopped working on my dev machine (which has both 'Full' MSSQL, and SQL Express installed). On any instance of SQL, if I try for instance to add a new table from the right click/new table menu option,
then I get the error message:
Method 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found. (SQLEditors).
I can add a table via and SQL Query no problem, it's just the front end gui that seems stuffed. Some other options don't work either, but a few still do.
I've tried repairing from the instalation disk (MSDN), and applying updates, but nothing fixes it. I suppose I could try an uninstall/re-install, but I don't really want to lose all the databases tbh.
View Complete Post