i am trying to find out the records that are in table 1 but not in table 2
i used the T-SQL statement

SELECT * from table1
EXCEPT
SELECT * from table2

but i am getting error

Incorrect syntax near the keyword 'except'.

please tell how i can fix it.........
please help