Home Forums SQL Server 2005 SQL Server Express Is it possible to do database maintenance using an older version of SSMS? RE: Is it possible to do database maintenance using an older version of SSMS?

  • October 9, 2012 at 10:15 am

    #1547280

    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, Rod Connect with me on LinkedIn.