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...

I can think of a few reasons for this, but could you post your full query?

I am not sure if it is that I am running that DMV wrong, but...

As far as I know, that should work as long as you are not wiping the disk when you go from 7 to 10.  If you wipe the disk, you...

I think what you are looking for is something similar to this website:

https://key2consulting.com/how-to-execute-and-store-transact-sql-t-sql-queries-results-in-a-powershell-array/

Basically, you create the objects then throw a query at it.  After getting the result, store it somewhere...

A nice easy question once you know where to look.  Have a look at the table sys.objects for that.

The [name] column shows you the name of the object, the [type_desc]...