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 |
|
olily
Starting Member
37 Posts |
 Posted - 2002-06-05 : 03:26:26
|
| I have two servers each for development and live environment. Recently I can't export or import the data between two servers. I'm not sure what had happened. The error message returned:"The procedure entry point ?SQLUIUpdateRegistryFromResource@@YAHJHPAUHIMSTANCE_@@IKPAPBG1@Z could not be located in the dynamic link library SQLRESLD.dll"Any idea? Alternatively, I was thinking writing a sql statement to transfer the data between two different servers. The database name is the same. Can someone tell me how to select data from two different servers with same database name? I'm using SQl Server 7. Thanks. |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-06-05 : 04:19:54
|
| you can use four part naming convention to access the db from another server.servername.databasename.owner.objectnameHTH-------------------------------------------------------------- |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-05 : 05:55:20
|
| Try this FAQ entry:How to join tables from different servers?http://vyaskn.tripod.com/programming_faq.htm#q14Your other problem looks like a client issue. Did you try it from any other machine?--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
olily
Starting Member
37 Posts |
Posted - 2002-06-06 : 00:57:43
|
| At home, I have one computer with win98 and Sql7 installed. All the while I can import/export. But suddenly, I just can't do the import/export. I don't know why. I have another computer with W2k and Sql7. I have no problem if I use this computer to import/export to that win98 machine.But in office, my workstation is in W2K and has Sql7. Recently, I face the same import/export problem that I face at home. I have tried in other workstation, still facing the same error message. |
|
|
|
|
|
|
Different Server Same Database