Hi Mark

There might be a problem. How, for example, are you going to identify the open connection number for views to use SPT in? Secondly, if you have several large tables open, you risk a timeout or "out of memory" error.


>We are designing our SQL 7 implementation (while we are still learning it)& have decided on the following regarding connections. Our remote views will share connections & our SPT will use 1 connection that is opened up in the logon process. This 1 connection will remain open through out the appslication session. Are there any potential problems with this that anyone can see?