|
|
Posted by <Thanks on 11/08/06 11:31
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9874F08E810F0Yazorman@127.0.0.1...
> Am_I_right (Am_I_right@world.com) writes:
>> Same system setup as before.
>> Computer A with SQL 2005
>> Computer B with SQL Express
>>
>> Is it possible to connect the SQL Express in B from the A using the SQL
>> 2005?
>>
>> I tried it, but failed.
>
> How did you try? How did it fail?
>
Computer A and Computer B are linked with network cable through a network
switch.
Both using MS Win 2003.
Thanks.
> You can always set up a linked server, but it's unclear to me if that
> is what you tried.
>
>> If I can do this, that means I can use Import function in SQL 2005 to
>> import Access databases into SQL Express.
>
> No, that is what you can do with a linked server. You could however
> import you Access database into SQL 2005 non-Express, and then
> copy the database with backup/restore as I described in my previous
> post.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|