Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.
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
This article will describe one method to parse a delimited string into a table of data.
Why would I do that you ask? Let's say that you need to pass multiple parameters into a stored procedure to search for. For our sake, we'll say that we wa…
There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005.
The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Recently, I was involved in a di…
- SQL
- Microsoft SQL Server 2008
- Microsoft SQL Server
- Microsoft SQL Server 2005
- T-SQL
- *microsoft sql server 2012
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month9 days, 15 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.