Thanks i had found this script also and tried it but it only does one table at a time and i have about 800. But thanks.

Thanks I will give it a try. I was hoping that somebody would come up with another way.

I have been reading through this thread and I agree with what most of the responses have been about being honest. I have interviewed allot and you can tell in...

I like what it does and i also created 2 SSRS reports but my question is how do you make this work with users that are not sa and may...