Hi,

I tested this but it is not worked for me.

when i use openrowset it showed executed.

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.