Also, does anyone know what the stored procedure definitions are used for, I found that using sp_RefreshSQLModules uses the definition, but does nayone have any other examples or a comprehensive...

MysteryJimbo (12/18/2013)

Here is my problem, I have some stored procedures where the defintion from this query is not the same as when scripting the stored procedure in an alter statement....

that way is even better, I found a flaw with the other way when using multiple claimkeys.

Thanks very much! the other way works fine. Cheers

thanks thats brillaint, sorted that issue so I can get on with the rest of it.

Thanks Again!!

Ah right I see!! Thanks will do next time

Hi all, thanks again for the replies it worked great, plus it was interesting to see the different ways to approach it. I used Paul's in the end and modified...

Hi thanks for the replies I shall try them out when I get to work on Monday, they look good though thanks!!!!