get Date function- HQ

Yes and No. Yes the POS is constantly checking to see if it has a connection to the Database, no it is not checking to see if it has a connection to the HQ database. Yes the POS will crash if it loses its connection to the Store Operations Database, no it will not crash if it loses its connection to the HQ database. At the store level if they have more than 1 lane, you can setup the other lanes to go into 'Offline Mode' (check SO help for more info) if they lose the connection to the SO database If the Stores can't establish a connection to the HQ they WILL still continue to operate independantly on there own.

Rob

"Andrea" wrote:

Store Operations does that - I'm not sure about HQ. To see it, use SQL Profiler (one of the tools included with versions of SQL Server other than MSDE) - each register running POS will make a call to the SQL Server for "Select getdate()" every one second. This is a heartbeat check - the register is making sure that it can still find the server. If the call fails, then yes, POS will display an error message and will shutdown. When you restart POS, it will look for the database again and if it's not there it will attempt to fail over to the offline database. This is what the heartbeat is all about - enabling that failover to offline so that the register can continue to ring sales. It's a shame that there isn't a smoother transition - like just switching to offline mode without the error message and forced shutdown, but that's what it does.

I don't remember if SO Manager or HQ Manager do this or not - you can check in SQL Profiler. In any case, SO would never be checking HQ...

Andrea,

You probably want to start posting in the reseller's groups too.

You must have your partner logon;

Finally, add the public site;

Click on the link below and click on "Open with newsreader" under the MS Retail Management System section on the right. It will configure Outlook Express for you and will bring you back to this newsgroup in Outlook Express.