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 |
|
Andy Williams
Starting Member
3 Posts |
 Posted - 2008-06-24 : 07:26:04
|
| I have two SQL servers that reside on separate servers.DB1 - SQL 2000 IP 194.X.X.1DB2 - SQL 2005 IP 194.X.X.2I am creating a view using OPENDATASOURCE in DB1 (Enterprise Manager) that selects a table from DB2.The data is returned and is succesful.When I come to save the VIEW, Enterprise Manager just locks up and I endup having to end the process.Has anyone had this problem or can anyone suggest the reason why it should do this?Any help would be appreciated.Many thanks. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-06-24 : 07:31:53
|
| Try creating view from Query Analyzer instead.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Andy Williams
Starting Member
3 Posts |
Posted - 2008-06-24 : 07:38:51
|
| Thanks for the response.I have tried that, built the query and that works, and I can save it without any problem. The only issue is that I have to save it as a VIEW in the actual database. So that the CRM package that I am developing with can see it?Is there another way to create a VIEW? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-24 : 09:38:59
|
| Run this in query AnalyserCreate View your_view_nameasYour_queryMadhivananFailing to plan is Planning to fail |
|
|
|
Andy Williams
Starting Member
3 Posts |
Posted - 2008-06-24 : 10:28:13
|
| Thank you. That as created my VIEW.I will let you know how I progress!Thanks |
|
|
|
|
|
|
SQL View using OPENDATASOURCE