Linked Server

Hi

I would like to now how to create a linked server on SQL 2005, not using a provider SQLNCLI but using a provider SQLOLEDB by T-SQL Commands.

Thanks

This might work for you

sp_addlinkedserver [ @.server = ] 'server'
[ , [ @.srvproduct = ] 'product_name' ]
[ , [ @.provider = ] 'provider_name' ]
[ , [ @.datasrc = ] 'data_source' ]
[ , [ @.location = ] 'location' ]
[ , [ @.provstr = ] 'provider_string' ]
[ , [ @.catalog = ] 'catalog' ]

|||Thank you very much