|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 15, 2009 4:41 AM
Points: 2,
Visits: 17
|
|
I also found this useful when querying a workbook with several worksheets:
EXECUTE SP_TABLES_EX 'your_linked_servername_goes_here'
which returns the names of the worksheets
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: 2 days ago @ 1:49 AM
Points: 286,
Visits: 44
|
|
Hi,
I tested this but it is not worked for me.
when i use openrowset it showed executed.[color=#00ffff][/color]
but when i used opendatasource it shows an exception linked server is null.
and also even though i created linked server through Managementstudio.it created linked server
but does not show the table in it.
In my system IIS was not installed .is there is link between iis and linked server.Please send the details reply.
|
|
|
|
