Ok. I'll repost with examples.
Please delete this...

GilaMonster

Testing should be the first thing done, in a dev/test environment, long before the production server is touched. If you test after the upgrade, you don't have much (any) time...

darshan.joshi29 (12/28/2016)

---

The first step you have check your applications compatibility with 2016 So in this situation mirroring is best option because with this in minimum down time you check all...

Thank you Jason for the helpful information.

JasonClark (12/25/2016)

---

Microsoft described this in brief:

https://www.microsoft.com/en-us/sql-server/sql-server-editions

you may have...

Thank you Vivek for the very helpful information and the links!

Now I know what are the preliminary and important steps to follow.

SQL Learner - VKG (12/23/2016)

---

There are couple of important...

Hi Jeff,

I have not yet run the 'update advisor'. Thanks for the idea. I'll run it.

Currently in SQL Server 2008 R2 , Standard edition we are running 2 databases.

We...

Thank you!

This will definitely help. And YES we are going for 16.

GilaMonster (12/23/2016)

---

Go to 16.

Upgrading to SQL 2014 is the same work as upgrading to 16, and leaves you with...

This is not as simple as it seems. It sounds like you need a dynamic solution where the number of columns is unknown. Please refer to the 2 articles in...

Thank you Venu512, This was the quick help I really needed to produce the year end report!

eklavu (12/27/2012)

---

Looks like a challenging solutions and I want to try it. I'm not busy today because my boss is on holiday (yehey!!!) :-).Can you post some data and sample...

Lowell (8/14/2012)

---

if a transaction rolls back or fails, the identity() columns still increment.

it sounds like an error occurred inserting the data that was not handled/reported by the .net application.

i've...

I also add that 78871 was missing.

78869

78870

78872

78873

78874

Sorry for the confusion