Linked Servers

Hello,

I have two databases on the same server (SQL Server 2005). I need to query data from table1 in database1 in database2. Do I need a linked server. I've had a look at the "Add Linked Server Simple" template, but I don't know what criteria to enter in the template?!

For simplicity sake, say my database1 is called DB1 with the table TBL1. Where does this go below and what else do I need?

-- =====================================

-- Add Linked Server Simplet template

-- =====================================

-- Create linked server reference to Database Engine instance on same machine

EXEC master.dbo.sp_addlinkedserver @server = N'<server_name,sysname,(local)><instance_name,sysname,SQLEXPRESS>', @srvproduct=N'SQL Server'

GO

-- Use current login's security context for the link

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'<server_name,sysname,(local)><instance_name,sysname,SQLEXPRESS>', @locallogin = NULL , @useself = N'True'

GO

-- Run a test query

SELECT * FROM [<server_name,sysname,(local)><instance_name,sysname,SQLEXPRESS>].<database_name,sysname,pubs>.<schema_name,sysname,dbo>.<table_name,sysname,authors>

GO


Thank you,

Mark