Are there any errors in the Windows Event Logs?

What account is the SQL Server Agent running under?

I doubt I'll have the answer, but these are some things I'd check.

I don't think you can do it with a trigger, but you can use a server-side trace to audit login's and that shows the database.

You already asked how many pages you should have before rebuilding and the BOL answer is 1000 and I provided a link as to where that number came from. ...

If all you are concerned about is if the name column has been modified I'd recommend just using a last modified date. That will tell you when the column...

Well, all your indexes, not HEAPS are 27 pages or less which probably means defragmentation won't help performance any way. With small tables you tend to get more mixed...

Nope you don't need to rebuild or reorg a non-clustered index if you rebuild a clustered index.

Here are some answers to your questions:

1. Any table without a clustered index is a heap, irregardless of the number on non-clustered indexes on it.

2. ALTER INDEX with...

BaldingLoopMan (12/14/2009)

---

actually u can use isnull in all situations if u wanted to. A coalesce is a nested isnull.

coalesce(custname, last, first) = isnull( isnull( custname, last ), first )

Therefore...

You need to join to sys.dm_exec_sessions like this:

SELECT

*

FROM

sys.dm_tran_locks AS DTL JOIN

sys.dm_exec_sessions AS DES

...

Looks like an Active Directory error to me. So I'd suggest talking to your Active Directory Admin.

Check the execution plans on both the VM and the physical server and see what is different. This could be a case where the dual-core physical machine is getting...

I understand that you are trying to audit, but updating the bemodified column when you do the update on the name is in essence doing the exact same thing as...

I don't know why other than they did not program it into SSMS. You woul dneed to query sys.triggers and check the is_disabled column.

Don't know how to do this because SSRS doesn't expose a HostName() or ComputerName() property/ function. If you have a user associated with a PC you could use the...

Why do it with a trigger? Why not do it in the T-SQL that updates NAME? So your code doing the NAME update would be:

Update demo

...