I think it may depend on the purpose.  If the table is going to be used to store vehicle information to be used by an external system, then Joe's method...

Not meaning to hijack the thread from Phil, but the error is clearly stated in the last bit of errors you posted:

Description: "The Microsoft Jet database engine cannot open the...

I would not recommend using VSS for a backup strategy personally.  SQL has a built in backup tool; I would use that.

As for the legality of using the tool that...

I am pretty sure that that would violate the license terms for any tool that is out there.

I highly doubt you will find anyone willing to do this for you...

My go-to steps for those types of errors are to try ping-ing the server you are connecting to from the machine that cannot connect to make sure it can even...

Are you using a SQL Alias to connect?  If so, do you get the same error when you connect with the full name?  What about if you connect with the...

Anything interesting in the windows event logs?

Might not hurt to look there around the time it crashed to see if there is any other events happening at the same time...

I think what you are trying to do using the method you are trying is not possible.  You cannot store more than 1 value in a variable except a table...

To insert it into a temp table, just insert it into a temp table instead of into dbo.details.  once that is done, to put the values from the temp table...

My job description was a "programmer analyst" and had a lot of stuff about VB6 and C# development.  Then as the needs of the department changed, my job title and...

I am chiming in just to say I like the artificial keys when it is being used for a foreign key.  As The Dixie Flatline says, client #10006 will be...

I got it wrong, but it was because I expected the stored procedure to fail to get created.  I am a bit surprised that the stored procedure would get created...

I love those "nothing changed" comments.  SOMETHING changed or the code wouldn't be slower.  Well, most of the time.

When I get those types of things coming to my desk, I...

Overall, I like what you did.  The code snippets are small and manageable.  The only downside to it is when it comes time to debug it.

What I've seen where I...

Thanks for the update!  And I am glad to hear it went off smoothly!

Some post-upgrade steps (on 2014) that you may want to check are:

1 - update statistics

2 - check...