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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-05 : 15:40:35
|
Jonas Hilmersson writes "Hi!
I have a database, SUB, running on SQL 7 that is a subsystem to a datawarehouse database, DW, also on SQL 7. The SUB database accesses tables and stored procs in the DW database. The machines used run Windows NT 4 Server/SP5+ and SQL 7 SP1+, both uni and multiple processor.
Now to the question, is there a way to create an alias to the DW database if there are several of them, or if the name of the database perhaps change periodically? I thought that it might work with linked servers, but found that I got some troubles when using cursor accessing "remote" tables as they where executed on the linked server but the cursor was not.
Brgds
Jonas Hilmersson" |
|
|
|
|
|
Creating an database