Please find the same kind of code.

-- TO BE RUN ON SHCBBMS01 SERVER

-- For SQL 2000

set nocount on

go

declare @server varchar(256), @ctr int

declare @tbllist table (srvr varchar(256),id int identity)

insert @tbllist

select 'SHBAHYP01T' union

select 'SHBAHYP04' union

select 'SHBAINT02'

set @ctr = 1

while @ctr <= (select max(id) from @tbllist)

begin

select @server = srvr

from @tbllist

where id = @ctr

declare @conn varchar(200), @query varchar(8000), @sql varchar(8000)

set @conn= '''SQLOLEDB'', ''Server=' + @server +';Trusted_Connection=yes;'''

set @query = '''select @@SERVERNAME,name from master.sys.databases'''

select @sql = 'SELECT a.* FROM OPENROWSET('+@conn+','+@query+') AS a;'

exec( @sql )

select @ctr = @ctr + 1

end

go

In this script I want to replay trusted connection to user name & password.

as I'm new to query part please help me out.

Thanks in advance

Nitin