Using linked server alias in view in SQL server 2000

• Brian Qing

  Grasshopper

  Points: 17

  More actions

  February 9, 2006 at 3:20 pm

  #167438

  I created a Linked Server alias on server instance A(2000) to link to server instance B(2000) under 'sa' account.  In A, I can run statement: select * from alias.database.dbo.table in Query  Analyzer, however, if I want to create a new view using the same statement, I have 'Statement(s) could not be prepared.' error.

  If I create the same Linked Server in my local SQL server instance A1(2005, linking to server instance B), under my Window account domain\myname.  In A1, I was able to create a new view using this statement without any problem.

  Please let me know where is the problem in using linked server alias in view in SQL server 2000 under 'sa' account.  Thanks a lot.

• February 13, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Pete Dobbs-356510

  Valued Member

  Points: 73

  More actions

  August 8, 2006 at 5:25 am

  #653809

  This may help:

   

  http://support.microsoft.com/default.aspx?scid=kb;en-us;825019