>>>>Hi All,
>>>>
>>>>Is it possible to create a Link Server in SQL Express 2008?
>>>>
>>>>I have a several clients that have database that can be sometine other then SQL Server, and I need to retrieve data from them. The small application do the rerieval needs to access the external database using a Link Server (inside SQL Express), but I can not determine how to setup the Link Server in SQL Express.
>>>>
>>>>Can anyone guide me to how to do this, or an possible alternate means?
>>>
>>>Something like this (from some of my production code)..
>>>
>>>EXEC master.dbo.sp_addlinkedserver @server = N'NT00PRDSQL02', @srvproduct=N'SQL Server'
>>>
>>> /* For security reasons the linked server remote logins password is changed with ######## */
>>>EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'NT00PRDSQL02',@useself=N'False',@locallogin=NULL,@rmtuser=N'thisuser',@rmtpassword='########'
>>
>>Ok, I am formilar with this approach in SQL 2008 Standard. But what IDE would I use at the client site to execute statements like these. I do not see a IDE for SQL Express. Or am I overlooking something?
>
>These are regular T-SQL commands BTW. Anything that can send commands to the SQL Server can send these.

Thanks All, I ended up using these TSQL commands to generate the Linked Servers.