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 : 17:01:49
|
| 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? Thanks! Tracy Siegle |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-20 : 17:24:37
|
| Use Linked Servers See BOL.sp_addlinkedserver .....cross:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40207[/url] |
 |
|
|
|
|
|
Data conversion across two servers