try:
exec sp_addlinkedserver @server = 'prueba', @srvproduct='', @provider = 'SQLOLEDB', @datasrc = 'myserver\myinstance02'
> trying to link the second instance a a linked server with this sintax but gives me an err
>
>sp_addlinkedserver
> @server = 'prueba',
> @provider = 'SQLOLEDB',
> @datasrc = 'myserver\myinstance02'
>
>Server: Msg 15429, Level 16, State 1, Procedure sp_addlinkedserver, Line 72
>'(null)' is an invalid product name.
>
>
>can you help me