Using SSMS 2008 to access 2005 database

  • I was told Microsoft recommends against this but I didn't find any info to support that.

    Connecting to SSIS 2005 does not work from SSMS 2008 but other than that I've had no issues.

    Any thoughts. Are there any risks. I've been using SSMS 2008 for a couple months and have no issues connecting to the 2005 servers.

  • Works fine. No intellisense (if you're still using the build in garbage), other than that, no issues that I've had.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Just to suppor what Gail said, I used SSMS for 2008 R2 to manage all my SQL Servers including SQL 2005 instances.

    Gethyn Elliswww.gethynellis.com

  • Ditto, well, not manage, Test maybe.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply