Jeff, your solution works, but using the folder name as a sort does not apply for me. In the sample table, they are in alphabetical order, but in the real...

Can you be more specific? Please note that I want to actually fill the data into the table, not just "join" the two tables for an output. Thanks

GilaMonster, you are truly my hero today. I cannot express enough gratitude for your help. If this database is loss, it would be a disaster for me because my home-based...

I ran the last command and it's also a success. Now it looks like my database become "Single User". I can see the list of tables but whenever I try...

The first two commands went through successfully. This is the message I got after the third command, namely DBCC CHECKDB:

Failed to restart the current database. The current database is switched...

I just edited the post above. Please view it. Thanks.

I am such a moron. I thought the error message was telling what's wrong with the database, but it appears I typed in the wrong sql command. Honestly, this is...

Simpler, wrong and quite likely to give you useless 'backups' that cannot be 'restored'. A file copy is not a SQL backup. That the person you work with does it,...

@SSCertifiable:

Can you explain further? I am not a SQL Server expert. I know some tsql but I'm still at beginning level. Note that I did not use any tsql command...