>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='########'
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________