I have sql server 2005 (full version) installed on my local machine, while the databases (on the server) I want to program against are in sql 2000. Could I program against sql 2000 databases using sql 2005? If yes, what do I need to know before I start doing that? Any suggestions are welcome.

Hi dilber,

You can connect with your SQL Server 2000 using SQL Server 2005...

All you need is to

1: Open SQL Server Management Studio

2: Go to File Menu, Select Connect Object Explorer menu item ( Connect to Server Dialogbox will be open)

3. Enter your 2000 Server name in Server Name Drop Down, Chooze Auhtentication Type & Enter User Name and password if Authentication is SQL Server Authentication..

4. If you type correct information ( SQL Server Name, User Name & Password).. then Your 2000 Server will be connected...and you can do all with your databases that u can perform on using SQL Server 2000 Enterprise Manager...

Thanks,

Best Regards,

Muhammad Akhtar Shiekh