t.brown 89142 (10/9/2012)
I tried this as I have SSMS 2005 and SSMS 2008 R2 installed on the same machine.
opening SSMS 2005, I CAN connect to the 2008 R2 database.
When I check database options, it does not have an entry in compatibility level, though in object explorer it does report the server as 10.50.200
Obviously no intellisense, but it seems to work fine.
However the design view doesn't work as you state, but nothing to stop you using ALTER TABLE etc
I've thought about doing an ALTER TABLE to add the constraint, but that doesn't sit well with my colleagues. If they don't have a nice GUI to work with, then forget it. So I'm downloading SQL Server 2008 R2 RTM Express with Advanced Services now on a test machine, so I can see if I can give them their GUI. I can get SSMSE later for my colleague; I just want to see what it looks like and how to do it, first.
Kindest Regards,RodConnect with me on LinkedIn