Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL Query...
1 view
Skip to first unread message
Blue Streak
Jan 21, 2008, 3:30:09 PM1/21/08
to
Hello,
I am trying to run an INSERT INTO command to draw information from one
server over to another in the form of:
INSERT INTO Country
SELECT CountryID,... FROM Server.Database.Table
What do I need to do to be able to access one MS-SQL server through
another like this: Server.Database.Table? Both are MS-SQL Server
2000.
TIA...
Dustin W. Jones
Jan 23, 2008, 12:05:17 PM1/23/08
to
setup a linked server
SQL Menace
Jan 23, 2008, 1:14:12 PM1/23/08
to
1) Linked server
2) OPENROWSET
3) Right click on the table in EM-->all tasks-->export data
4) DTS package (2 connections and paste the query in the Transform
Data Task)
2) OPENROWSET
3) Right click on the table in EM-->all tasks-->export data
4) DTS package (2 connections and paste the query in the Transform
Data Task)
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Jan 21, 3:30 pm, Blue Streak <rdlebre...@hotmail.com> wrote:
0 new messages