[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Import data from linked server

bubbles

3/26/2007 4:06:00 AM

TSQL rookie, using SQL Server 2005 Enterprise.

Need to import several tables from a linked server (SQL Server 2000)
on a nightly schedule.

Question:
1) How to import a linked-server table into my local server?
(No need for checks - just SELECT INTO)

2) How to set up a scheduled job to do this?

Regards,
Bubbles
2 Answers

Uri Dimant

3/26/2007 6:15:00 AM

0

Hi
--on sql server 2005

use demo

select * into newtable from ss2000.dbname.dbo.tablename

select * from newtable







"bubbles" <bubbles.one@hotmail.com> wrote in message
news:1174881948.574555.50790@y66g2000hsf.googlegroups.com...
> TSQL rookie, using SQL Server 2005 Enterprise.
>
> Need to import several tables from a linked server (SQL Server 2000)
> on a nightly schedule.
>
> Question:
> 1) How to import a linked-server table into my local server?
> (No need for checks - just SELECT INTO)
>
> 2) How to set up a scheduled job to do this?
>
> Regards,
> Bubbles
>


bubbles

3/26/2007 6:33:00 AM

0

Ah! So simple! THANKS!
Done and successful!

The books-on-line gives so much crap...

Bubbles



On Mar 26, 2:14 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> Hi
> --on sql server 2005
>
> use demo
>
> select * into newtable from ss2000.dbname.dbo.tablename
>
> select * from newtable
>
> "bubbles" <bubbles....@hotmail.com> wrote in message
>
> news:1174881948.574555.50790@y66g2000hsf.googlegroups.com...
>