Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010

    Unanswered: Openquery using a system function

    I have a table that contains the name of all of our sql servers. I want to create a procedure that will
    1. cycle through the table
    2. use sp_addlinkedserver (servername from table)
    3. issue a 'select * from openquery(linkedserver,'select serverproperty('edition')').

    I have not been able to get this to work. Is there an issue with using a system function in the select statement of an openquery?

    Any help will be greatly appreciated.
    Last edited by bettycalloway; 10-20-10 at 16:17. Reason: formating text

  2. #2
    Join Date
    Oct 2010

    Resolved my issue

    Thank you to anyone that read/replied to this question. I found that I was not using my quote marks correctly. I now have my openquery working.
    Last edited by bettycalloway; 10-20-10 at 16:27. Reason: spelling

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts