Will MSSQL respond to a command line stop if people are logged into
SIMS - as in - will it wait until they log out or just keel over ? Just
an academic thought but I'd rather not try it just to find out :-)
Ta
M
Printable View
Will MSSQL respond to a command line stop if people are logged into
SIMS - as in - will it wait until they log out or just keel over ? Just
an academic thought but I'd rather not try it just to find out :-)
Ta
M
From memory the sql server has no real "active" concept of who has SIMS (Pulsar.exe) open on their machine, only of those requesting/providing information I'd imagine it will just shut down as you have asked it to.
It should however because MSSQL has a fairly reliable journal type system in place be fairly robust to survive the odd accidental/intentional stop service.
Hi
MSSQL will happily dump any active connections and shut down for you.
Hopefully your application uses transactions appropriately, in which case data should be left in a consistent state.