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