Hi jpeters (first name would be nice)

First, welcome to AC.

OK, for number one, I am not completely sure about the question but if you are saying you want your nurses to enter data like PMH, FH, etc., and sign off so it's already in the chart, then either have them do it under your account or just elevate their privileges to doctor level. As you said, we are a family, and I believe it is all about intent. Licensing is per physician, but I believe physician means a person who is going to see patients and actually be a provider. Temporarily making someone a physician is probably no big deal. Check with Jon on that. I doubt he would care.

On the second part, this has come up about three times on here. I would say that means it is probably happening a lot more. I am convinced after reviewing all these that it is directly related to SQL Server Express and offices with many computers. Yes, Express should be able to handle 28 computers, but that is if the following is true:

The computer which is housing the databases and SQL Server should have at least 2GB of memory, 4GB if possible. Second, the key is what is on the other computer? Is there anything elses utilizing SQL? What applications is it running? Is that computer isolated or being used?

It would be helpful if I knew more about your network. Are you running peer-to-peer or client/server? Are you on a domain? What are you using for a server. What OS are you using? SQL Server Express can handle quite a few computers but that is given that it gets its full allotment of memory. While it gets 1GB of memory if your main machine has 2GB and is using 1.5GB, then SQL is running on 512MBs. The OS alone is going to take up its fair share.

Here's the deal. I have tried to help people with this before (and at the risk of offending someone who has tried to work with my tech buddies -- I haven't heard the outcome), it has been quite frustrating.

I have two guys I use to help me. They are good. One, Raja, remoted into my server the other day to help me with some ICD-9 code issues, and watching him in SQL Server Management Studio was like watching Michaelangelo. An artist. I have taught myself a ton about computers and networking, and I am determined to learn SQL. But, it is an entirely different beast. To work with it, you need a SQL Server expert and a DBA.

I think you will need SQL Server 2005 Workstation or Standard. Yes, it will cost for licenses, but once you have them, you will not have the connectivity issues. Given it has much less issues with the amount of RAM it can use, you will probably want to have a server that can house a lot of RAM. A 32-bit OS is limited to 4GB which is really 3.2GBs. A 64-bit OS can hold up to 64GB of RAM. SBS 2008 on a decent server will give you that capability. 2008 comes with both SQL Servers 2005 and 2008, although you get a license only for one.

Now installing AC to an instance of SQL Server 2005 and 2008 is possible, it isn't necessarily a walk in the park. This is where I would recommend an expert.

You can either utilize the two I mentioned in Experts Exchange (www.experts-exchange.com) which you probably won't, because no one ever does on here, or you can hire them directly.

I know that Raja could likely log in and find out where your performance issue lies. The difference between the other group's method and the one I would recommend is they took forever going back and forth trying to set up a time and a method, when it is probably best to do a few emails and then let the SQL expert remote into your network and look at the setup.

If you are interested at all in trying to fix things, let me know, and I will have Raja email you. I can't guarantee you that he will fix the problem, but I think you will know if SQL Express is the problem.

Meanwhile, if you can give me more specs on your network hardware and software including network switches, cabling, router, Cat5e vs Cat6, etc., it would be helpful.

Thanks.


Bert
Pediatrics
Brewer, Maine