SIMS and MSSQL

[interele]

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

[kmount]

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.

[theriver]

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.