Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
halexic
Starting Member
8 Posts |
 Posted - 2007-12-18 : 15:44:22
|
| Hello,Is it possible to access MS SQL 2000 database from SQL 2005 Express Enterprise manager? Database servers are on different machines, but in same Intranet. I know that I can access to other database that is on same server from Store Procedure / adding a database name prefix in front of table name...ThanksAlex |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-12-18 : 16:09:27
|
| >>SQL 2005 Express Enterprise manager?I think you mean SQL Server Management Studio Express, right?Yes, it works fine, but you may not be able to perform all of the administrative tasks that you could with the non-express version of SSMS or with Enterprise Manager.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-18 : 16:09:52
|
YOu can register the 2000 server with your EM as a linked server. But remember the 2000 box won't have the same functionality as the 2005 box.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-18 : 21:21:45
|
| No, you can't register sql 2000 server with EM as a linked server. You can create linked server to sql2k in ssmse on sql2k5e. |
|
|
|
halexic
Starting Member
8 Posts |
Posted - 2007-12-19 : 02:33:34
|
| Thanks, Linked server done the job. |
|
|
|
|
|
|
Access SQL 2000 database from SQL 2005 Express?