select * from [ip address].database name.dbo.table

Udi Yeger wrote:

>How do I write a select statement (from my local sql server) to query a
>table on another server.
>
>
>
>Do I need to set up a linked server?
>
>
>
>Udi Yeger
>
>Subject Wills & Company
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
>
>

MS Sql Server LazyDBA home page