Viewing 5 posts - 1 through 5 (of 5 total)
I'm trying to craft an SSIS solution like this myself. So, just to make sure I'm understanding this...
Executing multiple tasks that start an agent jobs, using statements such as...
June 29, 2010 at 12:36 pm
yehuda klein (3/31/2009)
SELECT db_name(d.database_id),MAX(last_user_SCAN),MAX(last_user_Seek),MAX(last_user_lookup),max(last_user_update)from sys.databases d
left join sys.dm_db_index_usage_stats i on d.database_id=i.database_id
group by db_name(d.database_id)
Thanks for this script yehuda; it gives me what I need. 🙂
June 22, 2010 at 8:18 am
Thanks for the information, it really helps alot. Unfortunately, this is still a little over my head but the dmv that you gave me puts me on the right...
June 22, 2010 at 7:59 am
I was naively trying to run the sp_stop_job in a maintenance plan, which of course, was throwing errors if the job was not running. Thanks to your article, I...
June 10, 2010 at 8:27 am
Thanks for the reply.
I've deleted those views and replication was reinitialized just fine.
And FYI, I just bought your book! lol 😉
June 9, 2010 at 2:42 pm
Viewing 5 posts - 1 through 5 (of 5 total)