>>>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?
Did you install SQL Server Management Studio? If you didn't, you need to download and install it separately.
If it's not broken, fix it until it is.
My Blog