You can try this query:

select max(resourceid) from resources

where resourceid < (select max(resourceid) from resources)

The subquery selects all the values lower than the max value and the main query picks...

For all its worth you can try renaming the dmp file to .mdf then in SQL Server click on the database folder, right click, New Database. New database will contain...