Harold Buckner (11/7/2008)
how stupid of me. I kept going though the script and finally hit me to check the permission on the procedure. I grant execute on my db role but something must have happened and I did not read the message or something. When I went back to check it, it was missing the permissions. Once I fix it, I'm getting the event now.I'm really sorry to wast your time.
No problem at all, I'm relieved there was a simple explanation. 🙂
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]