Yes because this account works for all the other servers we use it on

On this box the service and mail accounts are different

It is the same account my other 2008 and 2005 servers use, the difference is I used this exact account for the service accounts for sql server on myohter boxes....

Yes always 2 facid and 2 patid, it is a merge from facid and patid (1st two) to 2nd facid and patid

No I need to be able to manipulate the first facid and the first patientid and then the second facid and second patid

Thanks that was the missing table I needed

Yes it is there but they took out all the columns to manipulate, only 4 colums

Yes, I am looking for a schdule in a readable format which shows when each job is scheduled. I use to manipulate sysjobscheduled which is gone now

yes

Duh, thanks, afternoon brain freeze, i was going the whole substring road, making it way more complicated.

Am I also correct in assuming you just add data files, not log files?

Thanks

So you are saying if I go across db's in the stored procs then I need to use Execute as to get around this?

Thanks for the feedback, as far as getting help, I looked in the foxhole an I am all that is here, no money = self-learn and self-help

Still all the same, in fact one of the tables was from a linked server, checked the settings for that, still all the same. All at same SP level.

The collation on all servers involved is the same