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 |
|
mhundie
Starting Member
1 Post |
 Posted - 2007-01-28 : 23:53:02
|
| I have problem connecting to 2 SQL Servers both Entreprise Edition SP4 updated. I have 1 database running in Server1 and 1 database to Server2. If i update records to Server1, Server2 database should be updated also. I'm running all my activity using stored procedure. I already tested it on a single server and working fine but when I try it on two server. A error appeared:Server: Msg 911, Level 16, State 1, Line 1Could not locate entry in sysdatabases for database 'Database2'. No entry found with that name. Make sure that the name is entered correctly.How am i going to fixed this problem? Can anybody help me...Mhundie |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-29 : 00:02:02
|
Note that sysdatabases only store all databases of a SQL Server. If you run your stored procedure in Server 1, the sysdatabases will not contain 'Database2' as 'Database2' is located in a different server (Server2).You can take a look at linked server in BOL for accessing Server2
KH |
 |
|
|
|
|
|
Could not locate entry in sysdatabases