Yes MDF and LDF from different times makes sense...

Good news is that even though SQL Agent history and job history didn't show any EMR db backup history we did find...

Update!!

We did find a backup of the D drive on our TSM storage server. I am checking now to see if the LDF file is there and if we can...

Thanks Gila,

I believe this is a new installation and is only a few months old. (Oct or Nov of this year)

I was never notified of the server being installed and...

I forgot to mention that we don't have any backups (Vendor just installed everything and I see where they created two maintenance plans 1. System DB backups which is working...

Thanks Gail! This makes perfect sense. I do appreciate it!

Thanks John. This data is coming from a Cobal database. Would you happen to have any links on how this might be done in SSIS?

I ran RevLogin against all the user databases and it didn't show anything different than before.

What kind of logins are these?

-- Login: SC\SQLServer2005MSSQLUser$SC$MSSQLSERVER

CREATE LOGIN [SC\SQLServer2005MSSQLUser$SC$MSSQLSERVER] FROM WINDOWS WITH DEFAULT_DATABASE =...

Sure, I can help you with that. Here's what you need to do.

http://blogs.technet.com/b/mu/archive/2008/10/02/windows-update-and-automatic-reboots.aspx

Got it! Thanks Lowell!!! I really appreciate it!

select patient_type as PATCODE,

PATDESC=

CASE

WHEN patient_type = '1'

THEN 'Inpatient'

...

Lowell (7/27/2011)

---

what you want to do is all the case logic inside the SELECT, without using that extra variable.

something like this is syntactically correct...let me know if it is logically...

Koen Verbeeck (7/8/2011)

---

What source component are you using?

You can always use a Data Conversion component and cast the column explicitly to integer.

Remember, this component doesn't actually cast a column, it...

Gift Peddie (7/6/2011)

---

Funny you added a derived task when you...

Thanks! I eventually got it to work by using "\"" + CHG_PATNUM + "\"" in the Derived Column expression box.

Lowell (6/30/2011)

---

it depends completely on how you are exporting the data; you never mentioned what you are using.

Are you using SSIS? bcp? your own application?

bcp requires a format file to...

Anybody?