The famous Bert replied to one of my post. I read up on these boards all the time and see you Bert I feel honored that you replied to my post. :-) I appreciate it. Now on to answering question. Our IT guy set it up where we are not using express but the complete SQL. I ask him to do that from reading your post Bert. That is what I mean. Our new server has 8gb ram 3 X 250 memory Dell power edge running server 2011. Everything in the office is wired, All of our clients are running xp. There is a total in office of close to 15 and we have 2 people that work from home who remote in. Now mapped drives that question I do not know the answer to. Please let me know if they need to be mapped or not. I will call the tech guy and get him here if that is going to fix the problem.
The (auto disconnect) I did yesterday on the server; not sure if it worked but I didn't hear anyone in the office yell out "ughhhh restart again" but I will see today.
You turn off autodisconnect by going in the server to the command prompt and type NET CONFIG SERVER/AUTODISCONNECT:-1 , When we had a drop I did check out my log on the server yesterday and it said MSSQL cant except a new connection because it is shutting down. No one here shut it down. Maybe this is the cause of it. How do I fix that?
