I ran this script with the user 'robertba' (a sys admin who left some time ago) and got the following result

The row for user 'robertba' will be fixed by...

Thanks for that.  I'll do some testing and see what I get.

Thanks again for the help (and the soapbox!)

Glad to see someone joining us on the soapbox!!  Sometimes we feel like John the Baptist ' Lo, there was a voice crying in the wilderness'!  Our last chief believed...

DBA in charge/have some say in network backups? Don't go there, Terry, it won't be pretty.  You see why we run backups in the early morning; the question is only...

Maintenance plans don't really work for our scenario.  The network is backed up by a separate system (Tivoli) which writes to the SQL Server Logs.  However this backup can take...

Having read this kb I'm not sure that my colleague did it this way; the filer software may have just moved it.  She might have just attached and re-attached the...

Phew, guys, a lot of bits to respond to...........but here I go

1. Thanks for the thought about sp_ not being the correct name but I knew that one (Yes, we've...

Thanks for all the help, guys.  I've asked the Development Manager to sort the sp_  procedures out.  I've also given the programmers a copy of the article by 'bkelley' which...

Sorry to be 'thick' but I have never written a stored procedure in anger (only having done it in a training environment).  I've had a trawl round the templates in...

The programmer reports all is OK i.e. he is now getting data.  Thanks

I have given the user the rights just on the database and withdrawn 'Process Administrator'.  I'll see how he gets on and report back.

That has got to be the weirdest thing ever but it works!!  Thanks for that

Whoops we aren't sorted.  The programmer reports that he can access DTS but it doesn't bring through his data.  I will give him 'Process Administrator' rights for him to test...

Thanks anyway.  It does seem strange though......

Thanks.  We are sorted now