MSSQL Stored Procedure Problem

By viju_j ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Not Optimal but Dynamic SQL will work.

by jgarcia102066 In reply to MSSQL Stored Procedure Pr ...

If you write all of your SQL code as a string (@SQL) and then run the code using EXEC(@SQL) you will be able to compile.

The problem becomes getting the string set up correctly with the number of ticks (') you need in order for it to run correctly.

Related Discussions

Related Forums