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