aurato (11/15/2011)
I'm trying to figure out what a system process would want with it. If it's something like a consistency check then it's usage that isn't important because it doesn't need to exist.And I can check with our IT Support people to find out the last time it was rebooted.
I don't know for sure why it's used but it's being used. Might be FK check or something similar, but it's used. That's all I care about.
You can check the create date of tempdb to get that as well. Just make sure your period covers end of months and if possible end of <relevant periods>.
I'm not a big fan of dropping indexes unless I can really prove there's a gain involved. Which you don't do in your script.