Get SQL data from another server - OPENROWSET

SELECT * into tr
FROM    OPENROWSET( 'SQLOLEDB',
                    'Server=10.10.1.89\SQLEXPRESSR2;UID=sa;PWD=password',                  
                    'SET FMTONLY OFF;SET NOCOUNT ON; exec BASE89.dbo.GetPWD @UID=''21'''
                  )
select * from tr

http://technet.microsoft.com/en-us/library/ms191188%28v=sql.105%29.aspx