Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access SQL server 2005 database from SQL server 2000

Status
Not open for further replies.

b00gieman

Programmer
Jul 9, 2007
60
DE
Hi,

Is it possible to access a MS SQL Server 2005 database using MS SQL Server 2000 using Enterprise Manager?

Thanks in advance!
 
I am fairly sure that the answer is no.

However, you can access it using Query Analyzer.
 
Correct the answer is no. You can use Query Analyzer to connect to a SQL Server 2005 database. If you need to manage the server, you'll need the new SQL Server 2005 client tool which is called Management Studio.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top