truncate is not working..
Gives error-
Cannot truncate table 'rolemaster' because it is being referenced by a FOREIGN KEY constraint.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/