Here are the DDL for the tables

====Patients====

[PatientID] [varchar](20) NOT NULL, --Primary Key

[LastName] [nvarchar](25) NULL,

[FirstName] [nvarchar](25) NULL,

[AKA] [varchar](50) NULL,

[ClinicianId] [int] NULL,

[MEDICAID_ID] [nvarchar](8) NULL,

[PendingMedicaid] [tinyint] NULL,

[PrivatePatient] [tinyint] NULL,

[MedicaidEffectiveDate] [datetime] NULL,

[MedicaidTermDate] [datetime]...

Hi Again,

I'm experimenting some using the find dupe queries, but have run into a result I don't want. Here is the query:

SELECT APGAttendance.[PatientID], APGAttendance.[AttendDate], APGAttendance.[CTPCodes]

FROM APGAttendance

WHERE (((CTPCodes = 'G0396' or...

Hi Paul,

I thought it also may help a little bit to give a little more detail as to how we are setup now:

Note, database structure is the same for all...

Hi Paul,

Thanks for the reply.

1. I was thinking that since the portal was read only, and intake would need the ability to add/update data, that a separate db's might...

Hi GSquared. thanks for the reply. It did help. I thought about doing something similar, but wanted to see if there was an easier way (not to say that this...

In reference to question 2. Could Ownership Chaining help in allowing me not to have to create a user on all the SQL servers?

Thanks

Hi Carl,

Thanks for the reply. Now I have an issue with the SQL Server Agent not running. I have assigned the new user id to the SQL Agent Job (by...

BTW, I added this account to work with SQL Server Agent between some Linked servers I have.

Could Replication help me out here?

I've never had to use replication at this point, so please bare with me. I'm starting to read up on the topic. It looks as...

One last thing. The reason I wanted to create a index or Primary key on the original view was because I have 4 divisions in our company that I query...

Is there a way to create a local table/View of the database tables in the other databases and have the local table updated when there are Insert/updates to the other...

Thanks for the reply, I entered the query you suggested and the srvnetname, datasource and srvname are the same. IF this helps. I didn't see any error messages in the...

I'm a little perplexed right now. I still have a problem with connecting with the original program, but I installed another one of my programs (VB.NET) on the Terminal server...

Hi,

I'm not using a userId and password. We use Windows auth to allow access to the DB. My app also uses it own security. I have turned on TCP/IP in...

Thanks for the reply. I just pinged the DB from the Terminal server and appears to be working. It said it sent 4 packets and received 4 back with none...