Using SQL Server 2000, and VS.Net 2003

I want to load a datatable from a local server into a dataset and update it
into a linked server.  The linked server will have the exact same structured
table, and it will be empty.  Can I open a blank dataset from the linked
server, and fill it with the dataset from the local server?  I have been
trying every which way to get this working.  Is it possible?  It is too slow
doing a transact sql statement that does the insert from the local to the
linked, so I am trying this method.  Any thoughts?

Derek

.... A more "SQL" approach

EXEC sp_addlinkedserver 'your server'
EXEC sp_addlinkedsrvlogin 'your server', 'false', 'luser', 'rmtuser',
'rmtPassword'


SELECT * INTO YOUR_TABLE FROM YOUR_SERVER.DATABASE.dbo.TABLE

or

INSERT INTO YOUR_TABLE (COLUMNS) SELECT COLUMNS FROM
YOUR_SERVER.DATABASE.dbo.TABLE


Regards,
Tasos

Forgot to mention that you should

EXEC sp_dropserver 'your server', 'droplogins'

after finishing.

Tasos

logic gates in VB.NET 2005
string extraction
VB.NET INI or XML file for path locations
catching a specific exception
Q: GIF image on a form
Detect if compiling as a console application
Service unable to start
Send Image in .NET Remoting
Standard Method for Importing/Exporting to DB
Sorting a collection of collections?