There must be a glitch with SQL Server Central's notification system... I submitted this post 4 years ago.

Sorry, but I forget the details!

Since tempdb is created everytime the SQL Services are started, why not just check sys.databases? ie: select create_date from sys.databases where name='tempdb'

eureka.... after updating statistics on the table, all expected rows appear in sys.dm_db_index_usage_stats

Nice to have a breakthrough from time to time.

Thanks everyone for your help!

Tim

Hi Jason,

But there are 4 indexes, including the heap, defined on the table (please see the middle query). Yet when I query the dmv with the same object name, information...

Hi Toby,

Thank you for the quick reply.

I was using a similar approach, but during testing turned up some weird results...

Here is a little sample which shows my confusion about...

Hi MC,

A stored procedure, amongst other stored objects, may be manually recompiled. With stored procedures, this may be accomplished by running sp_recompile <proc_name>. After running this command, the stored procedure...

Hi MC,

I believe the query will reveal stored procedures that have been created with a "WITH RECOMPILE" definition, not those that have been flagged for recompile, regardless of their definition.

Tim

Thank you for the response Paul. However, results from sys.sysobjects aren't as one would hope.

Running the following query pre and post DBCC FLUSHPROCINDB (<id>) yields the same results:

select base_schema_ver,...

Ken,

You sir are a golden demigod!

Thank you,

Tim

Perhaps I missing something but...

create a login for the user

grant access to the user database

grant select on . to

Hi Florian,

Thanks for your patience.

Can you explain how you scan the emails? What technology do you use?

thanks again for your help,

Tim

Do you compare the "hello" emails to a list of servers that you expect responses from, or handle it manually? We have quite a few servers, so an automated check...

I would speculate that the host was memory constrained.

anyone... pleezzzeee.... 🙁

a sincere thank-you to everyone's responses. It sounds to me like creating a backup device for backups to disk isn't done - named devices are for non-disk backups.

I'm from...