>>>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?

I send these as SQL commands through my application . There is an SQL Server Management Studio Express for each version of Express (seperate downloads), but I don't know if it handles adding linked servers.