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 |
|
Chucker
Starting Member
6 Posts |
 Posted - 2003-01-07 : 11:40:25
|
| I am using Enterprise manager to set up views in a SQL database.I need to link to an Access database and to another SQL database.How do go about setting this up? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-07 : 11:49:36
|
| You will need to create a linked server for the access database.Why not crate the views using scripts in query analyser (if you really need views). It will probably be easier than EM and give you something to save in sourcesafe.create view myviewasselect a.fld1, b.fld1from mydb..mytbl a join mydb..mytbl2 band a.pk = b.pkgo==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Chucker
Starting Member
6 Posts |
Posted - 2003-01-07 : 12:16:04
|
| I see by reading in the forums that EM is limited.As you can tell, I am new at SQL.What I don't quite understand is how to save a query that I write in Query Analyzer to the database.What I am doing is linking a GIS app to SQL. The GIS can only see tables or views created in the database. How can I get it to see unsupported EM operations like UNION? |
|
|
|
Chucker
Starting Member
6 Posts |
Posted - 2003-01-07 : 12:25:39
|
| I figured it out.use DATABASE_NAMEcreate view MY_NEW_VIEWasSELECT .... |
|
|
|
|
|
|
Can't see other databases in EM