I believe this link shoud solve the problem

http://www.databasejournal.com/features/mssql/article.php/3643726

This link simply moves the table to the new partition with out creating a new table .

Regards,

Nidhi

i believe here the user can be associate with one role there fore it should be a primary key of some other table ....

now the join part ... i...