I would like to use the Database Diagram feature of SQL 2008 as I have in previous versions. I'm new to this company and for some reason the database properties have not been set to reflect the owner. For whatever it is worth, this database is used with Microsoft Great Plains.
I'm concerned that if I set the owner incorrectly, it will throw off the permissions for any application that uses the database. I'm finding it hard to believe the diagram feature is set up in such a way that it makes it so difficult to use it.
Any input here?
The picture below shows the error messages I get for the backup and production database servers. I know the one message is harmless and if I say yes to it the diagram feature will be enabled. I was just hoping to view diagrams using the backup server.....