My client runs SQL Server 2005, multiple desktop workstations are networked into this domain server. One of the desktop PCs is running an out of the box "TimeSheet" program that stores its data locally in SQL Server Express.
My question is I want to create a VIEW from SQL 2005 to the source table(s) in this local SQL Server 2005. What is the best way to do this without having to go thru SSIS? I just want a simple solution like a SELECT statement that can recognize this other server, can I do this?
I have full admin rights also.
thanks in advance.