I have made a stored procedure in MSSQL which connects to multiple client computers that are running MSSQL Express Edition and it collects data from some tables in those client computers, Now the problem here is that in my lab i of course wont have all those 10-20 client computers physically present on the network and so when i try to compile the Stored procedure, i get a oledb timeout error and i am not able to compile the procedure. How do i get around this problem as the the procedure needs all those client computers to be physically present on the network at the time of compilation and that is never going to be practically possible.
