Multipart name examples:
select dbo.table.column from dbo.table where dbo.table.column2 = 5
change to something like this
select tbl1.column from dbo.table tbl1 where tbl1.column2 = 5
select column form table where column2 = 5
if you have something like this:
select column1 from database.dbo.table change it to select column1 from dbo.table
If you have a HierarchyId as a column type, then you will have to wait until SQL Azure supports it or modify your table to remove HierachyId and put a pointer to itself in the table so you can do hierarchies the old way.