Thanks for the script, you may add the CREATE ROLE as well for user defined roles before you add the role member

restart worked for me too, but mine was for Restore and backup was from another server.

Anybody did this?

 marketwiz88 , Did you get any answer for the error because I do have the same error?

Thanks

The problem which I have is to make the Year as a parmeter in the stored procedure?

Thanks,

Thanks a lot ,

 if the  Yr will be variable like it varies the range based on the return , how that can be handled

for example the above example is for...