Phew, was beginning to think I was loosing the plot.

I think that's the only option to be honest. I'll start working through that option and see if it's viable for...

If I can replicate the view into a table I could work with that but with only access to the view and i'm having trouble implementing this idea. I've tried...

no, I have tried to add new triggers but can only add instead of triggers. unless there's something I'm missing. They have changed and locked down the new source tables...

Hi Phil,

I used insert and delete triggers on the existing tables to manage the data. Unfortunately I do not believe this is possible on a view.

An excellent script and one I use a lot however having just inherited a system with a FILESTREAM database I'm wondering the best way to get this FILESTREAM type included...

Excellent, that's done it. not sure how I missed that one. :Whistling:

Thanks

we could do but we're talking one login issue every few days and to create, manage and schedule this on 150+ servers, reporting on 1000's of login accounts isn't feasible,...

The problem really is the login ID variable and the people who I need to hand the task over to not having any SQL skills. The theory being : if...