I have sql server 2005 express edition installer. I have to do queries related to joins,fulltext search,xml data,stored procedure,transaction,view,index,managed code. so i want to know can these queries run on express edition? for someone told me that express doesn't have full features.