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 |
|
tsiegle
Starting Member
9 Posts |
 Posted - 2004-09-20 : 16:59:47
|
| I am trying to do a data conversion from our current schema on the production server to the new schema on our development server, however while writing the queries in query analyzer I cannot seem to connect to the production server. I thought you just had to preface the table with the server and database names as follows:SELECT * FROM [SV-ADF2].[GrantsDevelopment].[dbo].[ADFGrant]I get - Server: Msg 7202, Level 11, State 2, Line 1Could not find server 'SV-ADF2' in sysservers.Any suggestions? Thank you!Thanks! Tracy Siegle |
|
|
tsiegle
Starting Member
9 Posts |
Posted - 2004-09-20 : 17:23:19
|
| I figured it out- thanks for looking - TracyThanks! Tracy Siegle |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-20 : 17:24:33
|
| Use Linked Servers See BOL.sp_addlinkedserver .....Crosspost: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40208[/url]rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
|
|
|
Data conversion across two servers