>Hi,
>I have another question about OPENQUERY in my stored proc. Is it possible to pass the linked server name as a parameter to my stored proc? It will be helpfull, but the first parameter of OPENQUERY is linked_server type, but i can't declare a parameter of this type...
Marc,
AFAIK, the OPENQUERY() doesn't accept local variables as it's parameters. Using dynamic SQL maybe a way around it.
--sb--