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 |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2010-04-21 : 18:44:27
|
| Hello, I have a server with 5 databases which are inter related. Now i am migrating a database(out of 5) to another server and planning to create a linked server between those two servers. When i created a test linked server and changing the stored procedures from all the databases to use the new linked server, then i am getting the error Msg 7639, Level 16, State 1, Procedure xxxxxxCannot use a full-text predicate on table 'xxxxxxxx' because it is not located on the local server.Does anybody have any idea about this??? Thanks in Advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-04-22 : 00:41:23
|
| I would highly recommend doing them all at once. Using a linked server is not the way to go. We have a system that uses 7 databases and migrated them all to 2005 a few years ago. Although your test cycle will be longer, you won't have to do it multiple times. Plus you don't have to make any code modifications to handle splitting them onto separate servers.The performance issue alone though should persuade you not to migrate them one at a time.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Problem with Cannot use a full-text predicate