Post reply

Error on Linkserver from SQL2008 to SQL2000

  • August 5, 2010 at 2:28 pm

    #1203134

    After going to the link server PROVIDER options and enabling Allow Inprocess

    now whe can run openquerys usign the link server wich was the problem.

    But how could I ron a dorect query like

    select * from linkserver.dbo.thattable ?

  • August 6, 2010 at 10:44 am

    #1203670

    I have realize that what I wrote on the past post have some misspells. Sorry for that it seems that I was writing English thinking in Spanish. But what I meant was:

    "After going to the link server PROVIDER options and enabling Allow Inprocess

    now we can run openquerys using the link server which was the problem.

    But how could I run a direct query like:

    select * from linkserver.dbo.thattable ?"

  • November 16, 2011 at 8:48 am

    #1408640

    I just had the same problem and found this - haven't tried it myself yet, but the comments are encouraging:

    http://sqlblog.com/blogs/roman_rehak/archive/2009/05/10/issue-with-64-bit-sql-server-using-sql-2000-linked-server.aspx

    One of the comments also says:

    GRANT EXECUTE ON [dbo].[sp_tables_info_rowset_64] TO [public]

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply