Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Connect to SQL Server 2005
Posted on 2008-09-30
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.
Is the full SSMS for 2005 available for download. Express version does not have export data.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
4 Comments
>Can you connect to SQL Server 2005 database with SQL 2000 EM?
no. you can do the other way round, though.
no. you can do the other way round, though.
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction:
When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database.
Problems start when you try to combine that with some "user input" pass…
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 23 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.