Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Connect to SQL Server 2005

Can you connect to SQL Server 2005 database with SQL 2000 EM?
Is the full SSMS for 2005 available for download. Express version does not have export data.
0
JRockFL
Asked:
JRockFL
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Can you connect to SQL Server 2005 database with SQL 2000 EM?
no. you can do the other way round, though.

0
 
JRockFLAuthor Commented:
Is the full SSMS for 2005 available for download?
0
 
Richard QuadlingSenior Software DeveloperCommented:
Hello JRockFL,

SQL 2000 EM allows for SQL 7 and SQL 2000
SQL 2005 EM allows for SQL 2000 and SQL 2005

If you are going to be using SQL at any level above dabbling, then I really recommend getting the Developer Editions. They are quite cheap and provide the full SQL server toolset. You are limited in how you can deploy the server, but if you are only developing apps with it (and doing local testing), then this is a great way to see what the big boys play with.

Regards,

RQuadling
0
 
JRockFLAuthor Commented:
Thank you, I just need the full SSMS client. We have the standard edtion installed on a remote dedicated server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now