It won't run, because you're referencing an alias in the WHERE clause. Aliases only get assigned at a point after the WHERE has run.

You could do

SELECT change_dtim,create_dtim,ckpt_id,Format([change_dtim]-[create_dtim],'hh:nn:ss') as tempo FROM...

Eric M Russell (1/22/2016)

---

GilaMonster (1/22/2016)

---

Or a committed transaction. It's a page...

Seconded.

I did a long project at a company that mandated usp_...

Then I would suggest that you suggest to your boss that this is a bad idea, overly complicated, makes auditing hell...

Or a committed transaction. It's a page that has been modified...

Oh, and if you used the Profiler GUI against the server, you could well have caused the crash. Wouldn't be the first time.

Look at the length of each of the character columns, and the length of each field you're inserting into. One is too short, you need to investigate and see which...

You have a lot of wait types there that are meaningless or expected. Look for one of Glenn Berry's wait scripts and use that.

The totals are also very hard to...

Somewhere you're trying to insert into a column that's too small.

SQL Guy 1 (1/22/2016)

---

Nice idea, but...

Is there some reason you've decided not to use read committed snapshot or snapshot isolation?

You can use a DDL trigger, but if they've got dbo rights or above, they can disable the trigger.

This is something that probably needs to be taken up with the...

Because for procedures, the lookup for the plans in cache is database_id, object_id and some of the SET options.

Personally I prefer making the database owner 'sa'. It can't cause an inadvertent privilege increase, since sa is sysadmin always, it can't cause problems as will happen if a domain...

Grant Fritchey (1/21/2016)

---

Hugo Kornelis (1/21/2016)

---

Though I am happy to hear that he feels that he has heard enough to be able to solve it, I am at the same time...