That was embarrassingly simple. Thank you for your time!

This is perfect..thank you so much for your help!

Now I am trying to figure out how to combine these two queries.

SELECT I.PartNumber, I.Description, I.TimeDateCreated as [Date Part Created], OI.TimeDateCreated as [Last Req Date]

FROM Item I

OUTER APPLY...

I have the code and I don't need anything special other than an export of the data. I was actually blocked from being able to see the Jobs option within...

I used a right join because I need the results from the TroubleTicket Table, but the Asset table is the one that links Asset to Item and Asset to TroubleTicket....

That makes more sense now. Thank you so much

I don't have access to the code itself, but I was told by the programmer that when a part is added, the first thing it does is check to see...

Ok. So I am in the right place and found the error:

"failed with the following error: "Online index operation cannot be performed for index 'HQ_SQL_PK' because the index contains...

I have model.mdf and modellog.ldf in E:\SQLData. So I just need to rename the log file?

I just tried that and it worked! It seems so obvious now but thank you...

Yes, here is the text as to where the errors begin:

Recovery is complete. This is an informational message only. No user action is required.

Login succeeded for user 'NT AUTHORITY\SYSTEM'. Connection:...

My problem in SQL 2005 is similar to this. I used the Alter Database command to move the model database (it worked on the tempdb), stopped SQL, moved the files...