Maybe consider records to "match" if the SSN, first name and birth date all match. My reasoning: last name can change (marriage, etc.), and middle name may not be...

Or, depending on your specific needs, you could add your own logging/pseudotrace code to the proc itself, and trigger it with an optional parameter:

CREATE PROCEDURE dbo.proc_name

@...,

...

You don't really need SSMS to generate the statement. [And of course you don't try to make the change using SSMS, as SSMS will rebuild the entire table foe...

winmansoft, you should also be aware of the 14-byte-per-row overhead that READ_COMMITTED_SNAPSHOT requires. Anytime a row is updated, or a new row is inserted, the 14 bytes will be...

brettstahlman (3/18/2013)

---

Lynn Pettis (3/16/2013)

---

brettstahlman (3/16/2013)

---

Lynn Pettis (3/16/2013)

---

brettstahlman (3/16/2013)

---

opc.three (3/16/2013)

---

The reason why I disagree is because of the behavior of the after trigger when it is the instead trigger that is...

Could you go to NUMERIC(19,6)? That should work fine, and I think it will be just a metadata change.

This is off the wall, but did "AUTO_CLOSE" somehow get set on for that db?

That's a longshot, since even if it did it should auto_open when you reference it, but...

Interesting.

SSMS is probably internally running a query / stored proc to get the list of databases. Obviously the "SET ROWCOUNT" is affecting the code it uses as well.

I guess...

For certain UPDATE statements, SQL must instead actually do a DELETE and an INSERT instead of an UPDATE. So, the result is normal for SQL.

If you need to see...

Or, another possibility (with no character conversions/manipulation):

SELECT

ColA, ColB,

DATEADD(SECOND, ColB % 100, DATEADD(MINUTE, ColB % 10000 / 100, DATEADD(HOUR, ColB /...

I thought my query might meet the stated requirement while knocking out the second table scan :-).

If OP does need to list the alternate supplier(s), then yes, I think some...

Poor HAVING, nobody likes him 🙂

SELECT

ProductID, BaseSupplierID,

MIN(CASE WHEN SupplierID <> BaseSupplierID THEN Price END) AS LowestPrice,

MIN(CASE WHEN SupplierID...

You could also make the "real" column name a computed column that the developers use, and based off a "dummy name" column so they don't have to deal with NULLs....

Can you just add the column with no default value, for now, and handle the NULLs in the code temporarily?

It's almost certainly applying the default value that is taking the...

select

a.a, a.b, a.c

from @a a

left outer join (

select b

from @a a2

group by b

...