Insane --

That seems like a practical approach! A ticketing system.

We just need the courage and persistence to tell everyone we need a ticket for stuff that...

Thank you again. It's amazing to me how the notion of "data-tier app" and registration is so valuable yet most documentation is largely unclear on this on their purpose.

BD

Sue,

That's a great answer.  I have one question: you wrote

>>> The dacpac has the definitions and properties and registering allows SQL Server to use the files...

Jeff,

>> So, you don't care what the non-primary key columns contain at all? In other words, you never have the need for an UPDATE?

Correct. It's simply a matter of replacing...

Rookie,

Another great thought. You're not rookie!

BD

Great idea!. I was thinking about something along that line but it didn't quite crystallize. Your push got made me think about it again and it became much clearer.

Two...

No replication either (as the source DB is already involved in a replication relationship.)

I asked about that and they said "no" (as third parties are involved in the drama and that could impact their code.)

BD

Very interesting script. I'm reviewing it now....

SSC-Addicted,

We have Sql 2008! Everyone holds the tantalizing "sp_WhoIsActive" in front of me but I was hoping to find documentation describing how to effectively use...

Luis,

I will watch that URL tonight!

BD

SSC -

I'm new to SSIS 2014. You wrote

>>> To combat this I reduced the default values for how long information (365 days) and project versions (10 I believe) are...

Very good ideas! Will explore.

Thanks Gila and Grant

BD

Indeed the 8060 byte row limitation is a reality but regarding the SSIS default of 50 I would need to manually updated hundreds of fields in SSIS to correct their...

Luis --

Thanks for the answer. A part of one sentence was not complete:

"domains (racks) and upgrade domains (groups of hosts that . "

bd