Viewing 6 posts - 1 through 6 (of 6 total)
Thanks for the feedback. The tables are not that big, a few hundred records at most, but locking could be an issue that we have considered.
March 27, 2003 at 8:13 am
Thanks for the advice, we suspect it is a network issue. If I run the stored procedure right away it works fine. Thanks for your help.
March 26, 2003 at 8:22 am
We have an MS Acess 2000 front end calling stored procedures in an instance of SQL Server through ADO (MS data access component library). The view resides in this instance...
March 25, 2003 at 3:02 pm
Let me than you first for your help.
We had a job that runs every 10 minutes and does a very simple select on the linked server to ensure that the...
March 25, 2003 at 2:23 pm
We authenticate by aliasing all remote users to a single user in the linked server. I will post the code but I do not know if it going to help....
March 25, 2003 at 2:06 pm
We authenticate by aliasing all remote users to a single user in the linked server. I will post the code but I do not know if it going to help....
March 25, 2003 at 2:06 pm
Viewing 6 posts - 1 through 6 (of 6 total)