we have quite a few test servers and soe developers have right to create DTSs. So we end up with 50 DTS with diff owners
Same story in production. Also some ppl leave and we still have DTS owned by their login. I am thinking of automatically loop through all of them and make one generic login that we have own all DTSs.
Is it a good idea?