But, IIRC, the default trace does not record what id specifically made the change if that id has certain levels of permission.  I think if you want to know the...

A DDL trigger should be enough, including putting in place things to monitor it, to make sure no one has modified that trigger.

In a business environment, no one should be...

As a first step, make sure you are on the latest CU patch level.

That's where you and I would differ... to me, the "customer number" would be the IDENTITY column.  Or, perhaps, a Random GUID. 😀  Why would your "customer...

It would be really interesting to see you design a Customer or Employee table without one.  I'd also be interested in your claim of "it's literally impossible to normalize...

Heh... so THAT's the reason why so many people end up with "slow databases" and IDENTITY columns everywhere.  😉  A lot of the important stuff isn't even considered up...

Great, sounds good.

Again, though, your initial design should NOT be "tables", it should just be data.  It should be at a business level, not at a techy level.

If at all...

Then definitely start the design before tables.  That is, do a logical data...

[Use ROW_NUMBER() partly because of inherent efficiency] And partly because it's so easy to adapt:

SELECT theDate, value, flag
FROM (
    SELECT *, ROW_NUMBER() OVER(PARTITION BY...

DECLARE @start_year int
DECLARE @start_month char(2)
DECLARE @month_count smallint
SET @start_year = 18
SET @start_month = '01'
SET @month_count = 12

;WITH
cte_tally10 AS (
    SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
cte_tally1000...

Solution:

Use COALESCE instead of ISNULL, i.e.:

select COALESCE(nullif('',''),' ')

After all these decades. I don't remember why the inmate number was that long. I believe we display the first nine digits because that matches the Social Security number....

I just notice this: is there supposed to be a space in the @CustNum value?  Just curious.  Since that appears to be your own custom data type, it might be...

Since all the people who have ever existed fit very comfortably into 12 digits, I can't imagine why you'd need 18 digits for your person id.

Interesting behavior.  Have not seen that occur "naturally" before.

Edit: Now that I think about it, I thought all changes made w/i a trans were visible to that trans, even if...

• This reply was modified 4 years, 6 months ago by ScottPletcher.