+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SIMS and MSSQL in Technical; Will MSSQL respond to a command line stop if people are logged into SIMS - as in - will it ...
  1. #1

    Join Date
    Jan 2008
    Posts
    48
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    14

    SIMS and MSSQL

    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

  2. #2


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    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.

  3. #3

    Join Date
    Apr 2006
    Posts
    388
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 09:20 AM
  2. Open Source CMS that can use MSSQL
    By ICTNUT in forum Windows
    Replies: 4
    Last Post: 29th March 2007, 03:08 PM
  3. MSSQL Trigger (i think) Question
    By k-strider in forum Coding
    Replies: 3
    Last Post: 28th November 2006, 12:15 PM
  4. MSSQL Trigger (i think) Question
    By k-strider in forum Coding
    Replies: 0
    Last Post: 27th November 2006, 11:45 AM
  5. Autocreate AD accounts from MSSQL
    By CyberNerd in forum Coding
    Replies: 9
    Last Post: 12th July 2006, 03:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •