[AccessD] SQL Server "wakeup" mystery

jwcolby jwcolby at colbyconsulting.com
Fri May 7 10:01:19 CDT 2010


Guys,

I got the following in an email from a customer.  Does anyone have any ideas?

 >John - For the past 3 months (or so) there seems to be a problem regarding the access to the check 
info that resides on the SQLSERVER on PSSERVER.

 >The pattern we seem to be seeing is that the first time someone tries to access the check info in 
DISCO the check screen fields display "?????" . When They get out and go back into it again the 
check info is present.  Then for the balance of the day all is fine.

 >John says he has a similar problem when running reports from PSSERVER.  He initiates the report, 
it hangs, he kills it, then reruns and then it is OK.

 >It just appears like there is a "wakeup" issue going on when anyone initially access the SQLSRVR 
on PSSERVER.


-- 
John W. Colby
www.ColbyConsulting.com



More information about the AccessD mailing list