The solution is simple: Make everyone work through a terminal server, such as Citrix. Don't allow the user to copy to local drives, and you won't have to worry about copies...
Wow! What a diverse collection of responses! It makes you think about what you do as a "DBA" compared to others in the same profession. I'm entitled...
Having experienced migrating a Data Warehouse from SQL 7.0 to SQL 2000 (a MUST, believe me!), I discovered some very interesting issues with the DTS packages. You will discover...
I have resolved my issue. My foundation view was the problem. It was actually a view that was joining other views...Though the other views were not in fact...