Thanks, I'm well aware of HIPPA deal with it everyday. I figured out how to download to a file. Still working on being able to see the data when viewing...

Thanks SSChampion tried that and no change. How do I send it to a file?

these are medical records that I'm receiving from providers using a process called PHINMS. The files come in at all hours and are inserted into a SQL database. The columns...

Thanks, I will tonight when I have some time.

AB

Server1 is currently 2005 Express and Server2 is SQL 2000. I will probably be moving from Express to Enterprise.

I also have other servers running SQL 2005 Enterprise and SQL...

I see what you are saying and that might work but I'm not sure how to do it.

Currently we receive electronic lab record from several commercial labs. The records are received as a batch at night. They are in a HL7 2.3.1 format. They are translated XML...