Read  Committed...

AND, looking a bit closer, my code doesn't work correctly using the following data but the mod to pietlinden's code does, so use his code with the mod.

Here's the...

Of course lots of changes could be made to a db that would not be reflected in sys.dm_db_index_usage_stats.  For example, file(s) added; user(s) added/removed; permissions added/removed; etc..

The most likely causes:...

Add an asterisk to the end of the string; it won't hurt if it's not needed but is vital if it is needed.

SELECT

SUBSTRING(UCL.PROCEDURE_COMMENT,

CHARINDEX('*', UCL.PROCEDURE_COMMENT) + LEN('*'),

CHARINDEX('*', UCL.PROCEDURE_COMMENT + '*', --<<--

CHARINDEX('*',...

Although it seems odd, that's actually quite normal.  The KILLed process must rollback any data it needs to.  Issue a:

KILL XXX WITH STATUSONLY

command.  If it reports 0 and 0%, then...

To me, 50/50 on using a splitter for just the first 3.  Here's code using CHARINDEX & SUBSTRING:

DECLARE @string varchar(200)

SET @string = 'NAZARE|DEV|T||Current~NAZARE|DEV|T||Previous'

SELECT string, Lastname, Firstname, Middlename
FROM...

Looks like you're trying to do something like below.  Note that if multiple, different ProductIds are INSERTed at the same time, if ANY of them fail, ALL will be rolled...

This looks like it's supposed to be looking for the @current_proc_name value, not the literal string 'SOURCE', but then WTH do I know?

AND CHARINDEX('ALTER', @proc_source) <...

How is that, specifically, when the current clus index is an identity column?  You don't...

When I used ERWin (as they spelled it at the time, IIRC) I thought it was excellent tool (once I got used to it).  However, you have to understand data...

Actually, Sergiy, for certain calcs -- such as computing interest on a house loan in some places -- it's illegal to use more than 4 digits of accuracy.

So,...

For DELETE, a DENY DELETE should work.

For DROP, if the user created the table, they likely own it, so you'd have to use a DDL trigger for that AFAIK.

Do you have a q?

Actually, Sergiy, for certain calcs -- such as computing interest on a house loan in some places -- it's illegal to use more than 4 digits of accuracy.

So, if the...

Just change the clustered index.  The other method is too much overhead and too much of a pain.  A clus index change is a one-time thing.  All the create-a-temp-table-and-then-join-to-it has...